AutomationMart
Home/Browse/Automate personalized email campaigns with Google Docs, Sheets and SMTP
n8n

Automate personalized email campaigns with Google Docs, Sheets and SMTP

n8nn8n12 modulesv1.0
emailSendfiltergoogleDocsgoogleSheetsmergenoOpscheduleTriggersetsplitInBatcheswait

Emailing Using Google Sheet, Google Docs, and SMTP Automate personalized email campaigns using a Google Sheets contact list, a Google Docs template, and SMTP delivery. How It Works - Google Docs is used as the email template with variables: {{firstname}}, {{lastname}}, {{company}}, {{email}}. - Google Sheet contains your list of recipients (one per row). - For each contact, the workflow merges personal data into the Google Docs template. - Email is sent to each recipient via SMTP (batch size: 1)

At a glance

Automate personalized email campaigns with Google Docs, Sheets and SMTP is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects emailSend, filter, googleDocs, googleSheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
emailSend, filter, googleDocs, googleSheets, merge, noOp
Modules
12
Price
Free
Version
v1.0
Automate personalized email campaigns with Google Docs, Sheets and SMTP workflow diagram

About this workflow

Emailing Using Google Sheet, Google Docs, and SMTP Automate personalized email campaigns using a Google Sheets contact list, a Google Docs template, and SMTP delivery. How It Works - Google Docs is used as the email template with variables: {{firstname}}, {{lastname}}, {{company}}, {{email}}. - Google Sheet contains your list of recipients (one per row). - For each contact, the workflow merges personal data into the Google Docs template. - Email is sent to each recipient via SMTP (batch size: 1). Use the Wait node to respect provider quotas. - After sending, the workflow updates the "process" column of the Google Sheet with the date/time. How to Use 1. Copy Templates: - Google Docs Template - Google Sheet Template - Find each document’s ID (the text after /d/ and before /edit in the URL). 2. Configure Workflow: - Enter your Google Docs and Google Sheets IDs in the settings node. - Set your email subject in the appropriate parameter. 3. Set Up Credentials: - Connect your Google account. - Configure the SMTP node with your mail server details. 4. Update Data: - Edit the Google Docs template with your message and variables. - Prepare your Google Sheet with these columns: email, firstname, lastname, company. 5. Deploy and Test: - Connect all nodes. - Test with a small contact batch. - Troubleshoot any node errors (indicated in red in n8n). Requirements - Google Credentials & permissions: For Sheets and Docs access. - SMTP Server: For email delivery (adjust Wait node for rate limits). - n8n Version: Tested on 1.105.2 (Ubuntu). Need Help? - Comment this post or contact me on LinkedIn - Ask in the n8n Community Forum! See Also After running your email campaign, some messages may fail to deliver. This workflow scans your email inbox for delivery errors (e.g., bounced messages), flags problematic email addresses in the Google Sheet and ensures future campaigns skip them.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

LinkedIn talent pipeline: AI-powered candidate search & ranking with GPT-4o

The Ultimate AI Recruiting Solution for Finding Perfect Candidates with GPT-4o Are you tired of manually sifting through hundreds of LinkedIn profiles to find the right talent? Say goodbye to inefficient recruiting processes and embrace the power of AI-driven candidate selection. Our AI Candidate Ranking Flow automates the entire process from job description to ranked candidate lists, saving you countless hours while delivering superior results. 💼 Key Features & Benefits - Automatic Candidate Di

Free

Discord daily digest for multiple Google Analytics accounts

Overview Fetch Multiple Google Analytics GA4 metrics daily, post to Discord, update previous day’s entry as GA data finalizes over seven days. Benefits - Automates daily traffic reporting - Maintains single message per day, avoids channel clutter - Provides near–real-time updates by editing prior messages Use Case - Teams tracking website performance via Discord (or any chat tool) without manual copy–paste. Marketing managers, community moderators, growth hackers. - If your manager asks you for

Free

Generate an AI summary of your Notion comments

Use case This automation is for teams working in Notion. When you have a lot of back and forth in the comment section, it’s easy to lose track of what is going on in the conversation. This automation relies on AI to generate a summary of the comment section. How it works Every hour (the trigger can be adapted to your need and usecase), the automation checks if new comments have been added to the pages of your Notion database. If there are new comments, the comments are sent to an AI model to wr

Free

Generate & edit images with OpenAI GPT-Image-1 and share via Telegram

AI Image Generator & Editor with GPT-4 Vision - Complete Workflow Template Description Transform text prompts into stunning images or edit existing visuals using OpenAI's latest GPT-4 Vision model through an intuitive web form interface. This comprehensive n8n automation provides three powerful image generation modes: 🎨 Text-to-Image Generation Simply enter a descriptive prompt and generate high-quality images from scratch using OpenAI's gpt-image-1 model. Perfect for creating original artwork,

Free

Extract and structure X Post Comments with Airtop Browser Automation

Extracting Comments from an X Post Use Case Engaging with conversations on X (formerly Twitter) is critical for brands and individuals monitoring sentiment, leads, or emerging trends. Manually collecting comments is time-consuming—this automation enables scalable extraction of comment data to inform your outreach or analysis. What This Automation Does This automation extracts comments from a specified X post, with the following input parameters: - airtopprofile: The name of your Airtop Profile c

Free

Automated YouTube channel lead generation & email outreach with Apify and ZeroBounce

Workflow Overview This sophisticated n8n automation is a powerful lead generation and outreach tool designed to transform YouTube channel research into actionable marketing opportunities. By intelligently connecting multiple services and APIs, this workflow: 1. Discovers Targeted Channels: - Scrapes YouTube channels based on specific keywords - Extracts comprehensive channel metadata - Identifies potential business opportunities 2. Intelligent Lead Qualification: - Filters channels with con

Free

Capture website screenshots via Google Sheets to Google Drive with CustomJS

n8n Workflow: Automating Website Screenshots from Google Sheets This n8n workflow captures screenshots of websites listed in a Google Sheet and saves them to Google Drive using the CustomJS PDF Toolkit. @custom-js/n8n-nodes-pdf-toolkit Features - Monitors a Google Sheet for new rows with website URLs. - Captures screenshots of the websites using the CustomJS PDF Toolkit. - Uploads the screenshots to a specified Google Drive folder. Notice Community nodes can only be installed on self-hosted ins

Free

Generate marketing ad banners with LINE, Gemini, and Nano Banana Pro

About This Template This workflow creates high-quality, text-rich advertising banners from simple LINE messages. It combines Google Gemini (for marketing-focused prompt engineering) and Nano Banana Pro (accessed via Kie.ai API) to generate images with superior text rendering capabilities. It also handles the asynchronous API polling required for high-quality image generation. How It Works 1. Input: Users send a banner concept via LINE (e.g., "Coffee brand, morning vibe"). 2

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free