{"product_id":"gmail-to-google-sheets-invoice-parsing-with-pdf-co-ai-in-n8n","title":"Gmail to Google Sheets Invoice Parsing with PDF.co AI in n8n","description":"\u003ch3\u003eAutomatically turn Gmail PDF invoices into structured rows in Google Sheets using PDF.co AI—powered by n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors a Gmail label for incoming PDF invoice attachments, uses \u003cstrong\u003ePDF.co AI Invoice Parser\u003c\/strong\u003e to extract key invoice fields, and writes them to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (then labels each processed email so nothing gets duplicated).\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 messages in your specified label that include a \u003cstrong\u003ePDF attachment\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the email and filters attachments\u003c\/strong\u003e to keep only \u003cstrong\u003ePDF files\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads the PDF to PDF.co\u003c\/strong\u003e to generate a file URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns the PDF.co AI Invoice Parser\u003c\/strong\u003e using that file URL to extract invoice data as \u003cstrong\u003estructured JSON\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects key invoice fields\u003c\/strong\u003e (vendor, invoice number, invoice\/due dates, totals, tax) and also captures \u003cstrong\u003eemail metadata\u003c\/strong\u003e like sender, subject, and received date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates or appends in Google Sheets\u003c\/strong\u003e by matching on \u003cstrong\u003einvoice number\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLabels the processed email in Gmail\u003c\/strong\u003e to prevent the same invoice from being processed again.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAccounts teams who receive supplier invoices by email and need a live invoice register in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators consolidating recurring invoices from multiple senders into one structured sheet.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building reliable invoice ingestion without manual copy\/paste from PDFs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail Trigger\u003c\/strong\u003e (OAuth2): polls every minute using your label-based search query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter\u003c\/strong\u003e: ensures only PDF attachments continue in the workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePDF.co nodes (n8n-nodes-pdfco \/ PDF.co API key)\u003c\/strong\u003e: uploads PDFs and invokes \u003cstrong\u003ePDF.co AI Invoice Parser\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData mapping step\u003c\/strong\u003e: extracts vendor, invoice number, dates, totals, tax, plus email metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2): appends or updates rows by matching on invoice number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail label step\u003c\/strong\u003e: marks invoices as processed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet up Gmail OAuth2 + a PDF.co API key + Google Sheets OAuth2, create a sheet with matching columns, and you’ll have a focused Gmail-to-Google-Sheets invoice parsing automation built for n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029372948659,"sku":"N8N-19601","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dPl34Sgvtw-IN78v2E7TP_EbVXzGj7.png?v=1789463392","url":"https:\/\/buyflowscripts.com\/products\/gmail-to-google-sheets-invoice-parsing-with-pdf-co-ai-in-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}