AI Agent to send Emails from Google Sheets (video tutorial)

Video Introduction

Want to automate your inbox or need a custom workflow? 📞 Book a Call | 💬 DM me on Linkedin

What this workflow does

This workflow automates repetitive email sending directly from Google Sheets, eliminating hours of manual work each week. It reads email data from your spreadsheet, uses AI to generate personalized content based on recipient context, sends messages through Gmail, and automatically tracks responses back to your sheet. Perfect for sending reminders, follow-ups, or regular customer communications at scale.

Key features

• Smart filtering: Only processes rows marked with Status = "To send", preventing duplicate sends
• AI personalization: Generates tailored email content using OpenAI based on brief recipient introductions
• Automatic status updates: Marks emails as "Sent" after delivery to maintain accurate records
• Response tracking: Monitors Gmail replies and logs them back to your spreadsheet automatically

Common use cases

• Event reminders and webinar notifications with personalized context
• Customer follow-up sequences that feel individually crafted
• Regular business communications requiring recipient-specific details
• Sales outreach campaigns with AI-generated personalization at scale

Setup requirements

Credentials needed:

• Google Sheets OAuth2 connection
• Gmail OAuth2 connection
• OpenAI API credentials

Google Sheet structure:
Create columns for: To (email address), Subject, Introduction (one-sentence recipient context), Status ("To send" or "Sent"), and Response (auto-filled).

Configuration:
Update the Google Sheets document ID and sheet names to match your spreadsheet. Customize the AI prompt template in the AI Agent node to match your desired email tone and format. The response tracking branch runs automatically every minute to capture replies.