{"product_id":"claude-invoice-pdf-extractor-to-google-sheets-n8n","title":"Claude Invoice PDF Extractor to Google Sheets (n8n)","description":"\u003ch3\u003eAutomatically extract invoice data from PDF files into Google Sheets using Claude (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive folder for new invoice PDFs, uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to extract structured invoice fields, and then saves the results into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including duplicate detection and logging.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Google Drive\u003c\/strong\u003e: Triggers whenever a new file is created in a specified Google Drive folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads and prepares the PDF\u003c\/strong\u003e: Retrieves the PDF from Google Drive and converts it to \u003cstrong\u003ebase64\u003c\/strong\u003e for processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Claude to extract JSON\u003c\/strong\u003e: Sends the base64 PDF to the \u003cstrong\u003eAnthropic Messages API\u003c\/strong\u003e (Claude) with instructions to extract invoice data as \u003cstrong\u003estructured JSON\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and enriches results\u003c\/strong\u003e: Interprets Claude’s JSON response and records metadata such as:\n    \u003cul\u003e\n      \u003cli\u003efile name\u003c\/li\u003e\n      \u003cli\u003esource Google Drive file ID\u003c\/li\u003e\n      \u003cli\u003eprocessing timestamp\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects duplicates\u003c\/strong\u003e: Searches the Google Sheets \u003cstrong\u003e“Invoices”\u003c\/strong\u003e tab for an existing row with the same \u003cstrong\u003einvoice number\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs duplicate warnings\u003c\/strong\u003e: If a match exists, appends a warning entry to the \u003cstrong\u003e“Duplicates”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends new invoice rows\u003c\/strong\u003e: If no match is found, adds a new row to \u003cstrong\u003e“Invoices”\u003c\/strong\u003e, including totals and \u003cstrong\u003eline items JSON\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAccounts teams: centralize invoice processing by turning incoming invoice PDFs into a searchable Google Sheets ledger.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators: keep financial records up to date automatically as invoice files land in Google Drive.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers: reduce manual data entry by combining n8n + Claude + Google Sheets with duplicate handling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ components\u003c\/strong\u003e: \u003ccode\u003egoogle drive\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eif\u003c\/code\u003e, and supporting workflow logic (including notes\/sticky notes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClaude integration\u003c\/strong\u003e: Calls the \u003cstrong\u003eAnthropic Messages API\u003c\/strong\u003e to extract invoice fields as JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets tabs\u003c\/strong\u003e: Requires tabs named \u003cstrong\u003e“Invoices”\u003c\/strong\u003e and \u003cstrong\u003e“Duplicates”\u003c\/strong\u003e with headers matching the fields written by the workflow (e.g., Invoice Number, Vendor, Invoice Date, Subtotal, Tax, Total, Currency, and line items).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862250676403,"sku":"N8N-18313","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/3VaSlFUjgm-TtTQ2Z_kBG_7KR7XrUC.png?v=1786957894","url":"https:\/\/buyflowscripts.com\/products\/claude-invoice-pdf-extractor-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}