{"product_id":"gmail-invoice-pdf-extractor-to-google-sheets-crm-n8n","title":"Gmail Invoice PDF Extractor to Google Sheets CRM (n8n)","description":"\u003ch3\u003eAutomatically Extract Invoice Data from Gmail PDFs into Google Sheets (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow polls your \u003cstrong\u003eGmail\u003c\/strong\u003e for new invoice emails, extracts text from attached \u003cstrong\u003ePDFs\u003c\/strong\u003e, uses \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to convert the invoice into structured fields, and appends the results to your Google Sheets \u003cstrong\u003eInvoice\u003c\/strong\u003e tab—while sending anything unprocessable to a \u003cstrong\u003eReview\u003c\/strong\u003e tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Gmail every minute\u003c\/strong\u003e for new emails and downloads attachments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses multiple attachments per email\u003c\/strong\u003e by splitting each email into one item per attachment (so multiple invoices are handled separately).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes non-PDF attachments\u003c\/strong\u003e directly to a Google Sheets \u003cstrong\u003eReview\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts text from each PDF\u003c\/strong\u003e attachment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects unreadable\/scanned PDFs\u003c\/strong\u003e (no extracted text, e.g., image-only) and routes those files to the \u003cstrong\u003eReview\u003c\/strong\u003e tab for manual handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses invoice fields with OpenRouter\u003c\/strong\u003e by sending the extracted invoice text to a chat model and structuring key outputs such as \u003cem\u003evendor\u003c\/em\u003e, \u003cem\u003einvoice number\u003c\/em\u003e, \u003cem\u003edates\u003c\/em\u003e, and \u003cem\u003etotals\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends records to Google Sheets\u003c\/strong\u003e with added metadata, including received date, source email address, and a “New” status.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAccounts teams who receive invoices by email and want \u003cstrong\u003eautomatic invoice line ingestion\u003c\/strong\u003e into a Google Sheets CRM.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who centralize invoice tracking without building a full custom system—using an \u003cstrong\u003en8n Gmail → Google Sheets\u003c\/strong\u003e pipeline.\u003c\/li\u003e\n  \u003cli\u003eTeams handling mixed attachments where non-PDFs or scanned documents should be \u003cstrong\u003eflagged for review\u003c\/strong\u003e instead of blocking automation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Gmail Trigger\u003c\/strong\u003e (OAuth2): monitors your selected mailbox\/filters and polls every minute.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e actions: appends to \u003cstrong\u003eInvoice\u003c\/strong\u003e and \u003cstrong\u003eReview\u003c\/strong\u003e tabs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenRouter\u003c\/strong\u003e node: parses extracted invoice text into structured fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore workflow nodes\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, and supporting logic for attachment splitting and routing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIncludes a practical review path for non-PDF and textless PDFs, so your Google Sheets stays accurate while you handle exceptions.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916547121331,"sku":"N8N-18836","price":46.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sRSe40EU-ffqnW_PSjtEK_T7JKpOCu.png?v=1788035058","url":"https:\/\/buyflowscripts.com\/products\/gmail-invoice-pdf-extractor-to-google-sheets-crm-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}