Generate Cold Outreach Drafts from Google Sheets with GPT-4o-mini & Gmail

How It Works Starts with a Manual Trigger

Reads lead list from Google Sheet

Filter rows where email wasn’t sent

Generate personalized email body (AI)

Generate email subject line (AI)

Merge AI outputs with original row data

Create Gmail draft

Update Google Sheet with email content and date

Wait 3 seconds between updates to avoid API limits

Setup Steps Connect Google Sheets, Gmail, and OpenAI credentials Check sheet column names (business_name, email, contact_name, city, business_type, email_sent) Run Manual Trigger to test one row Adjust AI prompts if needed

Customization Add unique ID column to match rows if needed Change AI prompts to adjust email style Increase wait time to avoid rate limits

Use Cases Draft cold emails for review before sending Automate lead outreach while keeping human oversight Generate personalized emails and subject lines quickly

Troubleshooting Tips Draft not created → check Gmail credentials and scopes Sheet not updating → check matching column exists AI outputs empty → increase tokens or check response path