{"product_id":"razorpay-webhook-school-fees-automation-to-google-sheets-gmail","title":"Razorpay Webhook School Fees Automation to Google Sheets + Gmail","description":"\u003ch3\u003eRazorpay payment webhooks that automatically update school fee records—plus PDFs, Gmail receipts, and AI defaulter reminders\u003c\/h3\u003e\n\u003cp\u003eIf you run school fee collection on Razorpay, this n8n workflow turns \u003cstrong\u003epayment.captured\u003c\/strong\u003e webhooks into real-time updates in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates a \u003cstrong\u003ePDF receipt\u003c\/strong\u003e, emails it via \u003cstrong\u003eGmail\u003c\/strong\u003e, and runs a \u003cstrong\u003eweekly defaulter scan\u003c\/strong\u003e with \u003cstrong\u003eOpenAI\u003c\/strong\u003e-drafted reminder emails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses Razorpay webhooks:\u003c\/strong\u003e Receives the \u003cem\u003epayment.captured\u003c\/em\u003e webhook, validates the payload, and extracts student identifiers, payer details, amount, and transaction metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates student balances in Google Sheets:\u003c\/strong\u003e Finds the matching student record, calculates updated fees paid and outstanding balance, and updates the sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates and sends a receipt:\u003c\/strong\u003e Creates a branded HTML receipt, converts it into a \u003cstrong\u003ePDF\u003c\/strong\u003e, emails it via \u003cstrong\u003eGmail\u003c\/strong\u003e, and logs the event to a Google Sheets audit sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Telegram message:\u003c\/strong\u003e The same receipt step also sends a message via \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly Monday defaulter automation (9:00 AM):\u003c\/strong\u003e Fetches all students, identifies defaulters using balance due and overdue-day tiers (gentle \/ firm \/ escalation), and uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to draft a short, tiered reminder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReminder logging:\u003c\/strong\u003e Emails the reminder via Gmail to the parent\/guardian and appends a reminder entry to the Google Sheets audit sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e If the workflow errors, an alert is sent to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel via the Error Trigger.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate student fee tracking when payments come from \u003cstrong\u003eRazorpay\u003c\/strong\u003e—no manual reconciliation.\u003c\/li\u003e\n  \u003cli\u003eSend instant, document-ready fee receipts with \u003cstrong\u003ePDF + Gmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRun consistent defaulter follow-ups every week with \u003cstrong\u003eAI-assisted\u003c\/strong\u003e tiered reminders.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e Webhook, if, code, Gmail, Telegram, Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData store:\u003c\/strong\u003e Google Sheets (Students + audit logging sheet).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e Every Monday at \u003cstrong\u003e9:00 AM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI drafting:\u003c\/strong\u003e Uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to write reminder messages by defaulter tier.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirement:\u003c\/strong\u003e Create a Razorpay webhook for successful payments and configure Google Sheets OAuth + correct spreadsheet and sheet names\/IDs.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45812007076019,"sku":"N8N-17974","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/KUmwslNR6zVWweg7IDw0v_lD77dEmv.png?v=1786352718","url":"https:\/\/buyflowscripts.com\/products\/razorpay-webhook-school-fees-automation-to-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}