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/1sR1Mjee0heur6CgEVssYzOUbFNaDnyEnPSt1CFEMWI/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.