Templates / Cost-free email follow-up sequence with Google Sheets and Gmail

Cost-free email follow-up sequence with Google Sheets and Gmail

Ready for 3.0

by Gerald Denor ✓ · 147 views · created 2025-08-25 · Lead Nurturing, Multimodal AI

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

Nodes used (11)

Google SheetsGoogle DocsGmail

What it does

Simple But Powerful Email Automation for Everyone: No AI, No API Costs! This n8n workflow template, "Email Outreach Automation," is designed to help you set up an automated email outreach system using tools you might already be familiar with: Google Sheets and Google Docs. At its core, this workflow is a sequence of steps that n8n follows to send personalized emails to a list of contacts. The best part? It's built to be incredibly cost-effective, meaning you won't need to pay for any external API services or AI subscriptions to make it work. This makes it an ideal starting point for anyone new to automation or looking to manage their budget. How Does This Workflow Work? Think of this n8n workflow as a digital assistant that handles your email outreach from start to finish. Here's a simplified breakdown of what happens behind the scenes: 1. Your Contact List (Google Sheet): The workflow starts by reading your contact information (like names, emails, and company details) from a Google Sheet. This is where you'll keep all the people you want to email. 2. Email Content (Google Docs): Instead of writing each email individually, you'll create email templates in Google Docs. The workflow can then pull the content from these documents and personalize it for each recipient. This means you can use placeholders like {{firstname}} or {{company}} in your Google Doc, and the workflow will automatically replace them with the correct information for each person. 3. Smart Email Sequencing: The workflow is designed to send a series of emails to each contact. It keeps track of which email was sent last to each person in your Google Sheet. This ensures that your contacts receive the emails in the correct order and don't get the same email twice. 4. Sending Emails (Gmail or SMTP): Once the workflow has the contact's details and the personalized email content, it uses your Gmail account (or any other SMTP service you configure) to send the email. It even includes a built-in delay to avoid hitting email sending limits. 5. Updating Your Records: After sending an email, the workflow updates your Google Sheet to record which email was sent and when. This helps you keep track of your outreach efforts and ensures that contacts who have completed the email sequence are not emailed again. Key Features for Beginners: No Coding Required: While n8n involves visual programming, you don't need to write complex code to use this workflow. It's pre-built and ready for you to configure with your Google Sheet and Google Doc IDs. Free to Use (No Hidden Costs): This is a major advantage! Unlike many other email automation tools that charge per email or require expensive API keys, this workflow leverages free services. You can run your campaigns without worrying about unexpected bills. Easy Configuration: The workflow includes a "Settings" node where you can easily input your Google Sheet and Google Doc IDs, as well as your email subjects. This centralizes all your important settings in one place. Built-in Safeguards: Features like the "Filter passes only unprocessed contacts" and "Has contact completed email sequence?" nodes ensure that you only email the right people at the right time, preventing accidental re-sends. Scalable: As you get more comfortable, you can easily expand this workflow to handle more contacts or more complex email sequences. It's a great foundation for learning more about automation. What You'll Need to Get Started: An n8n instance (you can run it locally, use a cloud provider, or n8n.cloud) A Google account (for Google Sheets and Google Docs) A Gmail account (or SMTP credentials for sending emails) This workflow is your entry point into efficient and affordable email automation. It's designed to be straightforward for beginners while offering powerful capabilities. Get ready to automate your outreach and see the results! Setup Guide: Sample Google Doc Sample Google Sheet Need Help? Reach me: https://www.linkedin.com/in/gerald-akhidenor-1ab1a45/

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.