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

Description

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