Qualify leads and send outreach emails with Google Sheets, CometAPI, and Gmail
UnknownUnknown. 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 workflow has 8 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, Gmail and Cometapi (community).
How it runs
Trigger: On Google Sheets events (row added).
- Qualify Lead via CometAPI (Comet Api): uses Comet Api
- Extract Lead Score (Code): runs custom JavaScript code
- Check Lead Score Threshold (If): checks a condition and branches into true / false
- Summarize Lead Info (Comet Api): uses Comet Api
- Update Lead Data in Sheets (Google Sheets): append or update
- Draft Outreach Email (Comet Api): uses Comet Api
- Send Email via Gmail (Gmail): uses Gmail
Services it uses
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 @cometapi-dev/n8n-nodes-cometapi is verified or supports 3.0 (used in Qualify Lead via CometAPI, Summarize Lead Info, Draft Outreach Email).
Nodes used (6)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Comet Api
@cometapi-dev/n8n-nodes-cometapi.cometApi - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if
From the author
Quick overview This workflow watches a Google Sheets lead intake sheet for new rows, uses CometAPI to score and summarize each lead, and for high-scoring leads drafts and sends a personalized outreach email via Gmail, then saves the score, summary, and email…