How to Automate Gmail Lead Follow Ups?
Description
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.
Tools Required
What this workflow does?
- 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 to set this up?
- 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.
- You'll need accounts with Gmail and Google Sheets. See the Tools Required section above for links to create accounts with these services.
- 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.
- In the n8n credentials manager, create a new Google Sheets credential the same way. Approve access so n8n can read and update your sheet.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Need help or want to customize this?
Ask in the Futurise Pro Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
