n8n Email Campaign Builder 2026: Free Mailchimp Alternative (Gmail + Sheets)

What this workflow does

Inputs

• Google Sheet: Contains lead emails and info like name, company, plus tracking columns.

• Gmail account: Used to send and read emails for follow-up decisions.

• n8n instance: Runs the automation and uses OAuth2 credentials.

Processing steps

• Reads lead data from Google Sheets.

• Sends first email personalized with placeholders replaced.

• Checks Gmail threads to see if a reply came.

• If no reply and timing fits, sends follow-up emails.

• Updates Google Sheets with first email sent date.

• Stops emails on weekends to avoid bothering contacts.

• Manages multiple follow-ups based on schedule in email sequence node.

Outputs

• Sent emails to leads with personalized content.

• Updated Google Sheet keeping outreach status.

• Kept Gmail threads organized for tracking replies.

Who should use this workflow

Tools and services used

• Google Sheets API: Read and write contact and tracking data.

• Gmail API: Send emails and get threads for reply states.

• n8n Workflow: Automates the logic and timing of sending messages.

Beginner step-by-step: How to build this in n8n

Step 1: Import the workflow

2. Download the workflow file using the "Download" button on this page.

2. Open the n8n editor.

2. Click "Import from File" and upload the downloaded workflow.

Step 2: Add credentials and settings

2. Add Google Sheets OAuth2 credentials in the Get emails and Update last contacted time nodes.

2. Add Gmail OAuth2 credentials in the Get previous message threads, Get thread details, Reply to message, and Send new message nodes.

2. Go to the Settings node and update the sheet_url, email subject, sender_name, email column name, and mail_id to your values.

Step 3: Adjust email templates (optional)

2. Edit the Email sequence node to change email content or timing.

2. Make sure placeholders like {name} match your Google Sheet columns.

Step 4: Test the workflow

2. Run the workflow manually for a small set of contacts.

2. Check if emails send and updates happen in the sheet.

Step 5: Activate for production

2. Turn on the workflow by clicking the Activate toggle at the top right.

2. The scheduled trigger node will run hourly and send emails automatically.

How the workflow works

Input

Process

Output

Customization ideas

• Change message text or add HTML in the Email sequence node JSON.

• Add more placeholders by editing Google Sheet columns and updating the Fill message placeholders code node.

• Change follow-up days by editing send_on_day in Email sequence.

• Modify or disable weekend filter node to send emails on Saturdays or Sundays if wanted.

• Use different Google Sheet URL in Settings to switch contact list.

Troubleshooting common issues

Missing data for placeholder error

No emails send

Replies not detected for follow-ups

Pre-production checklist

• Confirm Google Sheet contains all needed columns matching placeholders.

• Verify Google Sheets and Gmail credentials are authorized and working.

• Test the workflow with few contacts first.

• Check no emails send on weekends unless desired.

• Backup Google Sheet data before running bulk messages.

Deployment guide

• Activate the workflow in n8n with the schedule trigger running hourly.

• Monitor execution logs for success or errors.

• Watch Gmail API quota in Google Cloud Console to avoid limits.

• Update message templates or timing as campaign needs change.

Summary of outcomes