Overview

Objective:

Automate booking outreach for a 90s/2000s pop rock cover band (Ultraligero) using a centralized Google Sheet and conditional logic. The system selects the appropriate contact channel (email or WhatsApp), applies fallback logic, and sends personalized messages accordingly.

Impact:

Maximize outreach efficiency by sending personalized booking messages through multiple channels while preserving tone, context and professional image. Ensure no opportunity is missed due to incomplete data.

Tools used

• Google Sheets (contact database)
• Zapier (automation engine)
• Gmail (email delivery and WhatsApp simulation)
• Formatter by Zapier (conditional fallback text)

Screenshot: Google Sheet with sample row and “Enviar = Sí”

Google Sheet with structured booking data for all contact types. Includes new columns for phone cleaning and contact classification. Active test row with “Enviar = Sí” highlighted. Data redacted for privacy.