Automated Cold Email Campaigns with Random Templates and Google Sheets Tracking

This n8n workflow automates the process of sending cold emails, incorporating random email templates and tracking the campaign's progress in Google Sheets. It's designed to streamline outreach efforts and add a layer of personalization through template variation.

What it does

This workflow simplifies and automates your cold email outreach by:

1. Triggering Manually: The workflow is initiated manually, allowing you to control when a batch of emails is sent.
2. Fetching Data from Google Sheets: It reads contact information and email template details from a Google Sheet.
3. Looping Over Contacts: It processes each contact individually, ensuring personalized emails.
4. Selecting Random Email Template: For each contact, it dynamically selects a random email template from the available options.
5. Composing and Sending Emails: It constructs the email using the contact's data and the chosen template, then sends it via an SMTP server.
6. Updating Google Sheets: After sending an email, it updates the Google Sheet to track which template was used and when the email was sent, preventing duplicate outreach to the same contact.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: A Google account with access to Google Sheets. You'll need a spreadsheet containing your contact list (e.g., Name, Email, Company, etc.) and a separate sheet or section for your email templates.
• SMTP Credentials: Access to an SMTP server for sending emails (e.g., Gmail, Outlook, SendGrid, Mailgun, etc.). You'll need the host, port, username, and password.

Setup/Usage

1. Import the Workflow:

   • Copy the provided JSON code.
   • In your n8n instance, click "New" in the workflows section.
   • Click the three dots in the top right corner and select "Import from JSON".
   • Paste the JSON code and click "Import".

2. Configure Credentials:

   • Google Sheets Node: Click on the "Google Sheets" node. You will need to set up a Google Sheets credential. Follow the n8n documentation for connecting your Google account. Ensure the account has read/write access to your campaign spreadsheet.
   • Send Email Node: Click on the "Send Email" node. You will need to configure an SMTP credential. Provide your SMTP host, port, username, password, and sender email address.

3. Customize Google Sheet Details:

   • Google Sheets (Read): In the Google Sheets node that reads data, specify the "Spreadsheet ID" and "Sheet Name" where your contact list and templates are located.
   • Google Sheets (Update): In the Google Sheets node that updates data, specify the "Spreadsheet ID" and "Sheet Name" for tracking.

4. Customize Email Templates and Logic:

   • Code Node: The "Code" node is likely where the logic for selecting a random template and constructing the email body/subject resides. Review and adjust the JavaScript code within this node to match your specific template structure and personalization fields.
   • Edit Fields Node: The "Edit Fields" (Set) node is used to prepare the data for the email. Ensure the fields being set (e.g., toEmail, subject, body) correctly map to your Google Sheet columns and the output of the Code node.
   • If Node: The "If" node likely contains logic to determine if an email should be sent (e.g., if a contact hasn't been emailed yet). Adjust its conditions as needed.

5. Activate and Execute:

   • Once all credentials and configurations are set, save the workflow.
   • Click "Activate" to enable the workflow.
   • To run the campaign, click the "Execute Workflow" button on the "Manual Trigger" node.

Remember to test the workflow with a small subset of data first to ensure everything is configured correctly before running a large campaign.