Qualify student leads from Google Sheets with OpenAI, Twilio, Telegram and Gmail

by Rahul Joshi ✓ · 35 views · created 2026-08-19 · Lead Generation, AI Summarization

What this workflow does

This AI workflow has 14 nodes and runs on a schedule (every 15 minutes) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI, Telegram and Gmail and 1 more. It also calls api.twilio.com over HTTP.

How it runs

Trigger: On a schedule (every 15 minutes) (plus 1 other trigger).

1. Fetch Unprocessed Leads from Sheet (Google Sheets): uses Google Sheets
2. Slack: uses Slack
3. Filter – Skip Empty or Incomplete Rows (If): checks a condition and branches into true / false
4. Normalise Lead Data (Code): runs custom JavaScript code
5. AI – Score and Classify Lead Intent (OpenAI): uses OpenAI
6. Parse AI Response and Assign Counsellor (Code): runs custom JavaScript code
7. Write Enriched Lead to CRM Sheet (Google Sheets): append or update
8. Mark Source Row as Processed (Google Sheets): update
9. Build WhatsApp and Telegram Message Content (Code): runs custom JavaScript code
10. WhatsApp – Send Welcome Message via Twilio (HTTP Request): calls api.twilio.com

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

Services it uses

Google SheetsOpenAITelegramGmailSlack

HTTP calls to: api.twilio.com

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• OpenAI@n8n/n8n-nodes-langchain.openAi
• HTTP Requestn8n-nodes-base.httpRequest
• Telegramn8n-nodes-base.telegram
• Gmailn8n-nodes-base.gmail
• Error Triggern8n-nodes-base.errorTrigger
• Slackn8n-nodes-base.slack

From the author

Quick overview This workflow polls a Google Sheets lead intake every 15 minutes, uses OpenAI (GPT-4o-mini) to score and classify each student enquiry, logs it to a CRM sheet, then sends a Twilio WhatsApp welcome message plus Telegram and Gmail notifications…

View the original on n8n.io → Check your own copy