Templates / Send multiple emails in Gmail directly via Google Sheets

Send multiple emails in Gmail directly via Google Sheets

Ready for 3.0

by AlQaisi ✓ · 77,052 views · created 2024-02-09 · Social Media

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.

What this workflow does

This workflow has 7 nodes and runs on a schedule (every minute). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: On a schedule (every minute).

  1. Retrieve Customer Messages Data (Google Sheets): uses Google Sheets
  2. Filter: keeps only the items that match a condition
  3. Merge: merges the data from its input branches
  4. Send a message (Gmail) (Gmail): uses Gmail
  5. Set data (Edit Fields (Set)): sets or maps fields
  6. Update Message Status (Google Sheets): update

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (6)

From the author

Send multiple emails in Gmail directly via Google Sheets Video for workflow process In today's fast-paced digital world, businesses are constantly seeking ways to streamline their processes and enhance customer engagement. One powerful tool that facilitates…

Excerpt from AlQaisi's description on n8n.io.

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.