{"product_id":"gmail-to-gstr-2b-gst-reconciliation-in-google-sheets-openai-n8n","title":"Gmail to GSTR-2B GST Reconciliation in Google Sheets (OpenAI + n8n)","description":"\u003ch3\u003eAutomatically reconcile Gmail purchase invoices with GSTR-2B in Google Sheets (OpenAI + n8n)\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGmail to GSTR-2B GST Reconciliation\u003c\/strong\u003e workflow pulls GST invoice PDFs from your \u003cstrong\u003eGmail\u003c\/strong\u003e, extracts invoice details using \u003cstrong\u003eOpenAI\u003c\/strong\u003e, compares them against your \u003cstrong\u003eGSTR-2B\u003c\/strong\u003e data in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and produces an \u003cstrong\u003eITC-at-risk\u003c\/strong\u003e summary—plus vendor follow-ups as Gmail drafts.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns monthly:\u003c\/strong\u003e Scheduled for \u003cstrong\u003e10:00 AM on the 15th\u003c\/strong\u003e to set company details, the return period, tax tolerance, and a Gmail search query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Gmail and processes invoice PDFs:\u003c\/strong\u003e Finds relevant messages, downloads \u003cstrong\u003ePDF attachments\u003c\/strong\u003e, and splits each invoice PDF into a separate item while keeping sender\/thread context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts invoice fields with OpenAI:\u003c\/strong\u003e Reads each PDF and parses key fields such as \u003cstrong\u003eGSTINs\u003c\/strong\u003e, \u003cstrong\u003einvoice number\/date\u003c\/strong\u003e, \u003cstrong\u003etaxable value\u003c\/strong\u003e, and \u003cstrong\u003eIGST\/CGST\/SGST\u003c\/strong\u003e. It skips \u003cstrong\u003enon-tax invoices\u003c\/strong\u003e and avoids \u003cstrong\u003eduplicates\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReconciles against GSTR-2B:\u003c\/strong\u003e Matches by \u003cstrong\u003esupplier GSTIN\u003c\/strong\u003e and \u003cstrong\u003einvoice number\u003c\/strong\u003e, with a fallback match on tax amounts within the configured \u003cstrong\u003etolerance\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlags issues and gaps:\u003c\/strong\u003e Identifies missing invoices in GSTR-2B, tax mismatches, invalid supplier GSTINs, invoices billed to the wrong buyer GSTIN, and any GSTR-2B entries with no matching invoice email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results and emails a summary:\u003c\/strong\u003e Appends\/updates a Google Sheets “Reconciliation” tab, then emails an \u003cstrong\u003eHTML\u003c\/strong\u003e summary to accounts with counts and \u003cstrong\u003etotal ITC at risk\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates vendor reminders:\u003c\/strong\u003e Groups flagged items by vendor, uses OpenAI to draft a concise reminder per vendor, and saves each as a \u003cstrong\u003eGmail draft\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonthly GST operations: reconcile purchase invoices automatically against \u003cstrong\u003eGSTR-2B\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eReduce ITC risk by quickly identifying mismatches and missing supplier reporting.\u003c\/li\u003e\n  \u003cli\u003eGenerate vendor follow-up communication drafts without manual drafting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation platform:\u003c\/strong\u003e n8n workflow automation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI extraction:\u003c\/strong\u003e OpenAI for parsing GST invoice PDFs\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Google Sheets “GSTR-2B” tab and a reconciliation output tab\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123230986419,"sku":"N8N-20089","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/SJ0vZXDY17hRhWLWlwLIN_zOXisQ59.png?v=1790673724","url":"https:\/\/buyflowscripts.com\/products\/gmail-to-gstr-2b-gst-reconciliation-in-google-sheets-openai-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}