Send and triage cold emails with Groq, Google Sheets, Gmail and Telegram
Ready for 3.0What this workflow does
This workflow has 29 nodes and runs on Google Sheets events (row added) (plus 2 other triggers). Along the way it connects Google Sheets, Gmail and Telegram. It also calls api.groq.com and gmail.googleapis.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added) (plus 2 other triggers).
- Validate prospect (Code): runs custom JavaScript code
- Read prospect rows (Google Sheets): uses Google Sheets
- Read approval rows (Google Sheets): uses Google Sheets
- Groq personalized outreach (HTTP Request): calls api.groq.com (POST)
- Select active prospects (Code): runs custom JavaScript code
- Authorize draft send (Code): runs custom JavaScript code
- Check outreach draft (Code): runs custom JavaScript code
- Search prospect replies (Gmail): get many
- Send approved Gmail draft (HTTP Request): calls gmail.googleapis.com (POST)
- Save outreach copy (Google Sheets): update
…plus 16 more steps. See the full node list below.
Services it uses
HTTP calls to: api.groq.com, gmail.googleapis.com
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 (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Telegram
n8n-nodes-base.telegram - Telegram Trigger
n8n-nodes-base.telegramTrigger
From the author
Quick overview This workflow turns new prospects in Google Sheets into Groq-written cold emails sent or drafted in Gmail, monitors Gmail for replies, then uses Groq to classify and draft responses while sending Telegram alerts and requiring a Telegram button…