Razorpay 80G Receipt & CSR Workflow with n8n, GPT-4o & Google

Automatically verify Razorpay donation webhooks and generate sequential 80G receipts with n8n + GPT-4o

This Razorpay 80G Receipt & CSR Workflow uses n8n to verify Razorpay payment.captured donations, produce orderly 80G receipt PDFs, and send personalized AI thank-you messages via Gmail and WhatsApp—while keeping Google Sheets and Slack fully in sync.

What this workflow does

• Receives Razorpay webhooks: listens for Razorpay payment.captured, normalizes donor details, and ignores non-captured events.
• Re-verifies payments: checks the donation against the Razorpay Payments API and uses Google Sheets to deduplicate by payment ID.
• Computes 80G receipt numbering: calculates the financial-year receipt number, donor tier, and flags required for accurate receipts.
• Ensures data quality: if verification fails, posts a payment mismatch alert to Slack for manual review.
• Generates AI-written thank-you + 80G receipt: uses OpenAI (gpt-4o-mini) to draft a personalized message, builds an HTML 80G receipt, and uses Gotenberg to convert it to a PDF.
• Sends donor communications: archives the receipt to Google Drive, emails the thank-you and receipt via Gmail, and sends a WhatsApp thank-you message.
• Logs donors and upgrades: appends donation data to a Google Sheets Donations ledger, upserts donors in a Donors sheet, and alerts Slack when tiers upgrade or a major gift is detected.
• Runs quarterly impact drafting: on Jan/Apr/Jul/Oct, aggregates Google Sheets data, uses OpenAI to draft an impact story, creates one Gmail draft per donor tier, and notifies Slack.
• Supports CSR enquiries: when a CSR enquiry form is submitted, matches the brief to the pro (as defined by the workflow logic).

Use cases

• NGOs and SaaS operators processing Razorpay donations that need sequential 80G receipts and reliable donor communication.
• Automation engineers building an end-to-end webhook → verification → PDF receipt → email/WhatsApp pipeline.
• CSR teams that require quarterly impact updates drafted automatically from ledger metrics.

Technical details

• n8n workflow nodes: if, code, webhook, gmail, slack, switch.
• Core integrations: Razorpay Payments API, OpenAI (gpt-4o-mini), Google Sheets, Google Drive, Gmail, Slack, Gotenberg, and WhatsApp.