Overview

Objective:

Automate personalized outreach to potential clients using Google Sheets, OpenAI, and Gmail. This agent generates a custom email based on name, company, and segment, then sends it automatically and updates the source sheet.

Impact:

Reduces manual outreach effort, ensures tailored messaging, and scales cold contact strategy for AI automation services.

Tools used:

• Zapier (automation engine)
• Google Sheets (contact database)
• OpenAI via Zapier (email drafting)
• Gmail (email delivery)

Automation Flow

Google Sheets → Zapier Trigger → Filter (ENVIAR = "Sí") → ChatGPT (email generation) → Gmail (send email) → Google Sheets (update row)