Manage school fee receipts and GPT-4o reminders with Razorpay and Google Sheets

by Rahul Joshi ✓ · 30 views · created 2026-08-10 · Invoice Processing, AI Summarization

What this workflow does

This AI workflow has 20 nodes and runs when an HTTP GET request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets, Gmail, OpenAI and Telegram and 1 more.

How it runs

Trigger: When an HTTP GET request hits its webhook URL (plus 2 other triggers).

1. Parse and Validate Payment Payload (Code): runs custom JavaScript code
2. Fetch All Student Records (Google Sheets): uses Google Sheets
3. Slack: uses Slack
4. Look Up Student Record in Sheets (Google Sheets): uses Google Sheets
5. Identify and Tier Defaulters (Code): runs custom JavaScript code
6. Calculate Updated Fee Balance (Code): runs custom JavaScript code
7. Any Defaulters Found? (If): checks a condition and branches into true / false
8. Update Student Balance in Sheets (Google Sheets): uses Google Sheets
9. AI Draft Personalised Fee Reminder (OpenAI): uses OpenAI
10. Build Branded HTML Receipt (Code): runs custom JavaScript code

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

Services it uses

Google SheetsGmailOpenAITelegramSlack

Before you upgrade to n8n 3.0

Nodes used (11)

• Webhookn8n-nodes-base.webhook
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Convert to Filen8n-nodes-base.convertToFile
• Gmailn8n-nodes-base.gmail
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Ifn8n-nodes-base.if
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Telegramn8n-nodes-base.telegram
• Error Triggern8n-nodes-base.errorTrigger
• Slackn8n-nodes-base.slack

From the author

Quick overview This workflow automates school fee collection by processing Razorpay payment webhooks, updating student balances in Google Sheets, generating a PDF receipt, and sending it via Gmail, plus running a weekly Google Sheets defaulter scan that uses…

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