Personalized Email Campaign Automation using Google Docs & SMTP - n8n Workflow

• Sales teams needing scalable, personalized cold outreach.
• Marketers running bulk email campaigns with strict rate limits.
• Users seeking reliable n8n templates for integrating G Suite services.
• Businesses that require tracking of successful sends directly in their contact database (Google Sheets).

This robust n8n workflow solves the tedious problem of mass personalization in outreach while ensuring compliance with SMTP sending limits. It leverages Google Sheets as the CRM or contact source and Google Docs for easily editable rich email templates. The core functionality of this n8n template relies on dynamic substitution: it pulls a template and, for every contact, replaces placeholders (like {{firstname}} and {{company}}) with actual data. A critical feature of this n8n workflow is the integrated rate limiting using a Wait n8n node, which manages sending speed to adhere to SMTP provider quotas (such as OVHCloud limits mentioned in the notes), ensuring high deliverability and preventing account suspension. This scheduled n8n trigger system provides a fully automated, set-it-and-forget-it solution.

The process begins with the Schedule Trigger n8n node, which initiates the automated campaign run. First, a Set n8n node (settings) defines essential global variables, including the email subject and the document IDs for Google Sheets and Google Docs.

Simultaneously, the Google Docs n8n node fetches the raw email template content, and the Google Sheets n8n node retrieves the full contact list. A Filter n8n node immediately processes the contact list, selecting only rows where the 'process' and 'err' columns are empty, ensuring recipients are not duplicated.

All data is combined via a Merge n8n node. The subsequent Set n8n node (updatebody) is where the heavy lifting of personalization occurs, using Javascript expressions to dynamically replace template variables with specific contact data (e.g., replacing {{firstname}} with the contact's actual first name).

The workflow then enters a loop using the Loop Over Items (Split In Batches) n8n node. For each item (contact), the Email Send n8n node utilizes configured SMTP credentials to dispatch the personalized message.

Following a successful send, the Google Sheets n8n node (updatecontacts) immediately updates the corresponding row, marking the 'process' column with a current timestamp, thereby tracking progress. Finally, a Wait n8n node introduces a 20-second delay, crucial for managing the sending rate, before the flow loops back to send the next email. This structure ensures a compliant and steady sending pace for the entire n8n workflow.

1. Import the n8n Workflow: Copy the provided JSON and import it into your n8n instance using the 'New' menu -> 'Import from JSON'.


2. Configure Credentials: You will need to configure three sets of credentials:

1. Set Document IDs: In the settings n8n node, replace the placeholders for googledocid and googlesheetid with the actual IDs of your template and contact list documents.


2. Define Template Variables: Ensure your Google Docs template uses the supported variables: {{firstname}}, {{lastname}}, {{company}}, and {{email}}.


3. Review Google Sheet Headers: Your contact sheet must contain the required columns: email, firstname, lastname, company, process, and err.


4. Adjust Rate Limit: Review the Wait n8n node configuration. Adjust the delay (default 20 seconds) to match the quota limits imposed by your specific SMTP provider.

Schedule Trigger

Set (settings)

Google Docs (template)

Google Sheets (contacts)

Filter (notemailed)

Set (updatebody)

Email Send (sendemail)

Google Sheets (updatecontacts)

Wait