{"product_id":"razorpay-80g-receipt-csr-workflow-with-n8n-gpt-4o-google","title":"Razorpay 80G Receipt \u0026 CSR Workflow with n8n, GPT-4o \u0026 Google","description":"\u003ch3\u003eAutomatically verify Razorpay donation webhooks and generate sequential 80G receipts with n8n + GPT-4o\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eRazorpay 80G Receipt \u0026amp; CSR Workflow\u003c\/strong\u003e uses n8n to verify \u003cem\u003eRazorpay payment.captured\u003c\/em\u003e donations, produce orderly \u003cstrong\u003e80G receipt PDFs\u003c\/strong\u003e, and send personalized AI thank-you messages via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eWhatsApp\u003c\/strong\u003e—while keeping \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e fully in sync.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives Razorpay webhooks\u003c\/strong\u003e: listens for Razorpay \u003ccode\u003epayment.captured\u003c\/code\u003e, normalizes donor details, and ignores non-captured events.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRe-verifies payments\u003c\/strong\u003e: checks the donation against the Razorpay Payments API and uses Google Sheets to \u003cstrong\u003ededuplicate by payment ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes 80G receipt numbering\u003c\/strong\u003e: calculates the \u003cstrong\u003efinancial-year receipt number\u003c\/strong\u003e, donor tier, and flags required for accurate receipts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnsures data quality\u003c\/strong\u003e: if verification fails, posts a \u003cstrong\u003epayment mismatch alert to Slack\u003c\/strong\u003e for manual review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates AI-written thank-you + 80G receipt\u003c\/strong\u003e: uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to draft a personalized message, builds an HTML 80G receipt, and uses \u003cstrong\u003eGotenberg\u003c\/strong\u003e to convert it to a PDF.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends donor communications\u003c\/strong\u003e: archives the receipt to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, emails the thank-you and receipt via \u003cstrong\u003eGmail\u003c\/strong\u003e, and sends a WhatsApp thank-you message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs donors and upgrades\u003c\/strong\u003e: appends donation data to a \u003cstrong\u003eGoogle Sheets Donations ledger\u003c\/strong\u003e, upserts donors in a \u003cstrong\u003eDonors\u003c\/strong\u003e sheet, and alerts Slack when tiers upgrade or a major gift is detected.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns quarterly impact drafting\u003c\/strong\u003e: on \u003cstrong\u003eJan\/Apr\/Jul\/Oct\u003c\/strong\u003e, aggregates Google Sheets data, uses OpenAI to draft an impact story, creates one Gmail draft per donor tier, and notifies Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupports CSR enquiries\u003c\/strong\u003e: when a CSR enquiry form is submitted, matches the brief to the pro (as defined by the workflow logic).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNGOs and SaaS operators processing \u003cstrong\u003eRazorpay donations\u003c\/strong\u003e that need \u003cstrong\u003esequential 80G receipts\u003c\/strong\u003e and reliable donor communication.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an end-to-end \u003cstrong\u003ewebhook → verification → PDF receipt → email\/WhatsApp\u003c\/strong\u003e pipeline.\u003c\/li\u003e\n  \u003cli\u003eCSR teams that require \u003cstrong\u003equarterly impact updates\u003c\/strong\u003e drafted automatically from ledger metrics.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003ewebhook\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore integrations\u003c\/strong\u003e: Razorpay Payments API, OpenAI (gpt-4o-mini), Google Sheets, Google Drive, Gmail, Slack, Gotenberg, and WhatsApp.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223980462259,"sku":"N8N-20879","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tES6D606ac74J8FBVsPai_asYQVQXE.png?v=1791970066","url":"https:\/\/buyflowscripts.com\/products\/razorpay-80g-receipt-csr-workflow-with-n8n-gpt-4o-google","provider":"N8N Commerce","version":"1.0","type":"link"}