Templates / Automate B2B cold email outreach with Gemini, Gmail and Google Sheets

Automate B2B cold email outreach with Gemini, Gmail and Google Sheets

Unknown

by Ravi Patel ✓ · 469 views · created 2026-05-20 · Lead Nurturing, Multimodal AI

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 69 nodes and runs on a schedule (every minute) (plus 3 other triggers). Along the way it connects Google Sheets, Google Gemini Chat Model, Gmail and OpenRouter Chat Model and 1 more.

How it runs

Trigger: On a schedule (every minute) (plus 3 other triggers).

  1. Working Hours Protection (Code): runs custom JavaScript code
  2. Working Hours Protection (Code): runs custom JavaScript code
  3. Reply Identifier (Code): runs custom JavaScript code
  4. Run after working hours (Code): runs custom JavaScript code
  5. Read Daily Limit (Google Sheets): uses Google Sheets
  6. Read Daily Limit (Google Sheets): uses Google Sheets
  7. Mark Done (Google Sheets): append or update
  8. Get row(s) in sheet (Google Sheets): uses Google Sheets
  9. Compare Limit (Code): runs custom JavaScript code
  10. Compare Limit (Code): runs custom JavaScript code

…plus 51 more steps. See the full node list below.

Services it uses

Google SheetsGoogle Gemini Chat ModelGmailOpenRouter Chat ModelPuppeteer (community)

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

  • Check that n8n-nodes-puppeteer is verified or supports 3.0 (used in Website Scraper).

Nodes used (12)

From the author

Enterprise AI Outreach Automation Description This n8n template demonstrates how to build a complete AI-powered outbound email system using Google Sheets, Gmail, Gemini, and website scraping. The workflow is designed to help you move from basic lead data to…

Excerpt from Ravi Patel'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.