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

Description

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.