Automate Personalized Email Campaigns with Google Docs, Sheets & SMTP

This n8n workflow streamlines personalized email marketing by integrating Google Sheets for contact management, Google Docs for dynamic templates, and SMTP for reliable delivery. It reads recipient data (email, firstname, lastname, company) from a Google Sheet, replaces variables like {{firstname}} in the Docs template for each contact, sends individualized emails in batches of one with a Wait node to respect quotas, and logs the send date/time back into the sheet's 'process' column.

Benefits include massive time savings on manual mail merges, scalability for large lists without overwhelming servers, and full automation reducing human error. It's ideal for newsletters, sales outreach, customer updates, or promotional campaigns, ensuring compliance with rate limits while maintaining personalization at scale.

Use cases span marketing teams running lead nurturing sequences, sales automating follow-ups, or e-commerce sending order confirmations. Setup is straightforward: use provided template links, input Doc/Sheet IDs, configure credentials, and test with small batches. Perfect for businesses leveraging Google Workspace for cost-effective, high-impact email automation.