{"product_id":"gmail-receipt-parsing-with-claude-to-google-sheets-reconcile","title":"Gmail Receipt Parsing with Claude to Google Sheets Reconcile","description":"\u003ch3\u003eTurn Gmail PDF receipts into a reconciled spreadsheet + Slack status—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your \u003cstrong\u003eGmail\u003c\/strong\u003e for \u003cstrong\u003ePDF receipts\u003c\/strong\u003e, uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to extract structured data, saves validated results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then matches receipts to a pasted \u003cstrong\u003ecard statement\u003c\/strong\u003e and posts a reconciliation summary to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomatically monitors Gmail\u003c\/strong\u003e: Triggers every 15 minutes when an unread email with the label \u003cem\u003ereceipts\u003c\/em\u003e arrives with a PDF attachment (or you can run the reconciliation flow manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses PDFs one by one\u003c\/strong\u003e: Splits each email into one item per PDF attachment and extracts PDF text for verification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts receipt fields with Claude\u003c\/strong\u003e: Sends each PDF to \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to extract receipt data as JSON, including vendor, date, currency, line items, tax, totals, and payment method.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates before saving\u003c\/strong\u003e: Checks Claude output against the extracted PDF text and performs basic arithmetic validation. Problem cases are flagged as \u003cem\u003eNeeds review\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores results in Google Sheets\u003c\/strong\u003e: Appends\/updates receipt records in the \u003cstrong\u003eReceipts\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReconciles against card lines\u003c\/strong\u003e: On manual reconciliation, reads \u003cstrong\u003eReceipts\u003c\/strong\u003e and \u003cstrong\u003eCard\u003c\/strong\u003e tabs, matches by amount within a configurable date window, and rebuilds the \u003cstrong\u003eMatches\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts via Slack\u003c\/strong\u003e: Creates a short status summary of items needing attention and posts it to a selected Slack channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need reliable, auditable receipt capture for monthly spend tracking.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a receipt-to-reconciliation pipeline using Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTeams that want Slack notifications whenever receipt parsing or reconciliation needs review.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\/logic\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets (OAuth2)\u003c\/strong\u003e, \u003cstrong\u003eAnthropic\u003c\/strong\u003e (Claude), \u003cstrong\u003eSlack\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUtilities\u003c\/strong\u003e: \u003ccode\u003ehttp request\u003c\/code\u003e and workflow notes via \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSet up Gmail, Google Sheets, Anthropic, and Slack credentials, initialize the \u003cstrong\u003eReceipts\u003c\/strong\u003e, \u003cstrong\u003eCard\u003c\/strong\u003e, and \u003cstrong\u003eMatches\u003c\/strong\u003e tabs, and start reconciling receipt data with confidence.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217906946227,"sku":"N8N-20855","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bdRTpGzOBymRBATt4QNk-_R71zC2m4.png?v=1791882390","url":"https:\/\/buyflowscripts.com\/products\/gmail-receipt-parsing-with-claude-to-google-sheets-reconcile","provider":"N8N Commerce","version":"1.0","type":"link"}