Automate Personalized Email Campaigns with Google Docs, Sheets, and SMTP - n8n Workflow | Neura Market
Automate Personalized Email Campaigns with Google Docs, Sheets, and SMTP
# Emailing Using Google Sheet, Google Docs, and SMTP
Automate personalized email campaigns using a Google Sheets contact list, a Google Docs template, and SMTP delivery.
## How It Works
- **Google Docs** is used as the email template with variables: `{{firstname}}`, `{{lastname}}`, `{{company}}`, `{{email}}`.
- **Google Sheet** contains your list of recipients (one per row).
- For each contact, the workflow merges personal data into the Google Docs template.
- Email is sent to each recipient via SMTP (batch size: 1). Use the `Wait` node to respect provider quotas.
- After sending, the workflow updates the process column of the Google Sheet with the date/time.
## How to Use
1. **Copy Templates:**
- [Google Docs Template](https://docs.google.com/document/d/1sR1Mjee0heur6CgEV_ssYzOUbFNaDnyEnPSt1CFEMWI/edit?usp=sharing)
- [Google Sheet Template](https://docs.google.com/spreadsheets/d/1mFKp3wmbV9qp2tpGGsN72zdiC32y8H1nhjdgP885y-U/edit?usp=sharing)
- Find each document's ID (the text after `/d/` and before `/edit` in the URL).
2. **Configure Workflow:**
- Enter your Google Docs and Google Sheets IDs in the `settings` node.
- Set your email subject in the appropriate parameter.
3. **Set Up Credentials:**
- Connect your Google account.
- Configure the SMTP node with your mail server details.
4. **Update Data:**
- Edit the Google Docs template with your message and variables.
- Prepare your Google Sheet with these columns: **email**, **firstname**, **lastname**, **company**.
5. **Deploy and Test:**
- Connect all nodes.
- Test with a small contact batch.
- Troubleshoot any node errors (indicated in red in n8n).
## Requirements
- **Google Credentials & Permissions**: For Sheets and Docs access.
- **SMTP Server**: For email delivery (adjust Wait node for rate limits).
- **n8n Version**: Tested on 1.105.2 (Ubuntu).
## Need Help?
- Comment on this [post](https://www.linkedin.com/posts/n8n-about_n8n-emailing-smtp-activity-7358928869015310336-G_9n/) or contact me on [LinkedIn](https://www.linkedin.com/in/stephaneheckel/)
- Ask in the [n8n Community Forum](https://community.n8n.io/)!
## See Also
After running your email campaign, some messages may fail to deliver. This [workflow](https://n8n.io/workflows/7251-flag-bounced-emails-in-google-sheets-from-gmail-delivery-error-messages/) scans your email inbox for delivery errors (e.g., bounced messages), flags problematic email addresses in the Google Sheet, and ensures future campaigns skip them.