{"product_id":"gmail-google-drive-receipt-tracker-to-google-sheets-n8n","title":"Gmail + Google Drive Receipt Tracker to Google Sheets (n8n)","description":"\u003ch3\u003eAutomatically turn Gmail + Google Drive receipts into a live Google Sheets expense log\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Gmail and a Google Drive receipts folder, extracts expense details from receipt emails and files using \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e, archives attachments back to Drive, and appends validated expenses to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including a link to the original receipt.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail every minute\u003c\/strong\u003e: triggers when new messages matching \u003cem\u003elabel:receipts\u003c\/em\u003e arrive and downloads any attachments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eArchives receipts to Google Drive\u003c\/strong\u003e: normalizes email content, uploads attachments to a specified Drive location, and generates a permanent Drive link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Google Drive every minute\u003c\/strong\u003e: triggers on new files created in your chosen Drive folder, downloads the file, and normalizes it as receipt input.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts receipt data with Claude\u003c\/strong\u003e: routes each item as \u003cem\u003ePDF\u003c\/em\u003e, \u003cem\u003eimage\u003c\/em\u003e, or \u003cem\u003eemail-body text\u003c\/em\u003e, extracting PDF text when needed. Uses Claude (text or vision) to extract structured fields: \u003cstrong\u003evendor\u003c\/strong\u003e, \u003cstrong\u003edate\u003c\/strong\u003e, \u003cstrong\u003etotal\u003c\/strong\u003e, \u003cstrong\u003ecurrency\u003c\/strong\u003e, \u003cstrong\u003ecategory\u003c\/strong\u003e, and \u003cstrong\u003epayment method\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates receipts\u003c\/strong\u003e: flags whether the content is a real receipt, filters out non-receipts, and then \u003cstrong\u003eappends expenses to Google Sheets\u003c\/strong\u003e with a timestamp and the receipt link.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture recurring receipt emails by using the Gmail \u003cstrong\u003ereceipts\u003c\/strong\u003e label and keep daily expenses automatically updated in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eCentralize receipt uploads: drop PDFs\/images into the Drive folder and let the workflow log structured expenses.\u003c\/li\u003e\n  \u003cli\u003eBuild an audit-friendly expense tracker by storing a permanent Drive link alongside each logged line item.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Gmail, Google Drive, Google Sheets, Anthropic Claude\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e, plus supporting notes\/stages and \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e operations\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClaude configuration\u003c\/strong\u003e: separate Claude model selection for text extraction and vision extraction\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e connect credentials for Gmail, Google Drive, and Google Sheets, choose the target sheet, add Anthropic credentials, label Gmail receipt emails with \u003cem\u003ereceipts\u003c\/em\u003e, and configure the Drive receipts folder.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748943356083,"sku":"N8N-17706","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/GbkOn-DXDh_VK5wOMQrMz_JTAgzaDs.png?v=1785575019","url":"https:\/\/buyflowscripts.com\/products\/gmail-google-drive-receipt-tracker-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}