Overview

Objective:

Automate the first contact with live venues for a 90s/2000s pop rock cover band (Ultraligero) using a structured spreadsheet connected to Zapier and Gmail.

Impact:

Save time, avoid human error, and scale outreach to multiple venues without manual repetition.

Tools used

• Zapier (automation)
• Gmail (email delivery)
• Google Sheets (database)

Automation flow

Google Sheets → Zapier Trigger → Filter → Gmail Action → Manual status update in sheet

This automation sends a personalized email to the contact if:

• The field “Enviar” is marked as “Sí”