n8n

How to Automate Gmail Lead Follow Ups?

Keep lead outreach on track with automated Gmail sequences. The system reads contacts from Google Sheets, sends the first email, and follows up on time if no one replies. It suits small teams that want reliable follow up without manual work.

An hourly schedule checks your Google Sheet for new or pending contacts. A weekend guard stops sending on Saturdays and Sundays. The flow builds each message from your email sequence, fills placeholders from the sheet, and adds a hidden tracking tag so later steps can read mail sequence data. It looks up recent Gmail threads by subject, decodes messages, and classifies each thread to see if a follow up is due. If a reply exists, it stops. If no reply and the wait period has passed, it decides whether to reply in the same thread or send a fresh email. After sending, it writes back the first_emailed date to the sheet.

Setup needs a Google Sheet with the right columns and a Gmail account with send permission. Results include faster follow ups, fewer missed leads, and cleaner records. Great for cold campaigns, event follow ups, and demo requests captured in a sheet.

What are the key features?

  • Hourly schedule that scans contacts and pending follow ups
  • Weekend pause so messages are not sent on Saturdays and Sundays
  • Google Sheets read and update to manage leads and log first_emailed dates
  • Email sequence builder with send_on_day delays and HTML messages
  • Placeholder filling from sheet columns to personalize each email
  • Gmail thread search by subject and date to avoid duplicate or early sends
  • Thread classification to detect replies and decide if the next message is due
  • Smart branch to reply in thread or send a new message based on context
  • Hidden tracking tag injected into emails for sequence and placeholder context

What are the benefits?

  • Reduce manual follow up from hours to minutes each week
  • Automate up to 90% of routine outreach while keeping replies personal
  • Eliminate duplicate sends by checking Gmail threads before emailing
  • Improve data accuracy by writing send dates back to Google Sheets
  • Connect Gmail and Google Sheets with no extra tools
  • Handle more contacts by scaling sequences from a simple sheet

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Gmail and Google Sheets. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, create a new Gmail credential: open any Gmail node, choose Credential to connect with, click Create new credential, and follow the on screen steps to grant access.
  4. In the n8n credentials manager, create a new Google Sheets credential the same way. Approve access so n8n can read and update your sheet.
  5. Prepare your Google Sheet with at least these columns: email and first_emailed. Add any extra columns that match your placeholder names like name or company.
  6. Open the Settings node and paste the full URL of your Google Sheet into the sheet_url field. Make sure your n8n Google account can access the sheet.
  7. Open the Email sequence node and set your subject, HTML message, and send_on_day for each step. Keep the subject stable across the sequence so Gmail thread lookups work.
  8. Set sender name or other parameters in the Settings and parameter Set nodes if available. Match placeholder names in your messages to column names in the sheet.
  9. Add one test row in the sheet with your own email. Click Execute in n8n to run a manual test. Confirm the email arrives and the first_emailed column updates.
  10. Check Gmail Sent and the thread view. Verify that the workflow will reply in the same thread when a follow up is due and will stop if you send a real reply.
  11. Review the Don't email on weekends node if you want to allow weekend sends. Adjust the schedule trigger timing to fit your time zone and sending window.
  12. Troubleshooting: if no emails send, confirm the sheet URL, column names, and credentials. If duplicates appear, ensure subjects are consistent across the sequence and that dates in the sheet use the yyyy-MM-dd format.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.