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
   • Google Sheet Template
   • 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?

Contact me on LinkedIn or ask in the n8n Community Forum!