{"product_id":"ocr-invoices-from-google-drive-to-google-sheets-n8n","title":"OCR Invoices from Google Drive to Google Sheets (n8n)","description":"\u003ch3\u003eOCR invoices from your Google Drive—automatically filled into Google Sheets (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a folder for invoice\/receipt files, runs OCR recognition, and saves the extracted data into a Google Sheets document—so you can turn messy uploads into a structured spreadsheet without manual copy\/paste.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors a Google Drive folder\u003c\/strong\u003e for new receipt\/invoice files and also supports manual execution via the \u003cstrong\u003e“Test workflow”\u003c\/strong\u003e button.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecognizes files in .pdf, .png, or .jpg format\u003c\/strong\u003e (make sure your documents are saved in one of these formats).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses an OCR API via RapidAPI\u003c\/strong\u003e to recognize the invoice\/receipt content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites the OCR results into Google Sheets\u003c\/strong\u003e using the provided sheet template.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eQuick setup notes (important)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n import glitch:\u003c\/strong\u003e after importing, the trigger node for \u003cem\u003e“Test workflow”\u003c\/em\u003e may be disconnected. Connect it using \u003cstrong\u003e2 arrows\u003c\/strong\u003e to \u003cstrong\u003eGoogle Sheets1\u003c\/strong\u003e and \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e nodes (you’ll have \u003cstrong\u003etwo triggers\u003c\/strong\u003e: one via button, one via the Google Drive “new file” event). See: \u003ca href=\"https:\/\/ocr.oakpdf.com\/n8n_fix.png\" target=\"_blank\" rel=\"noopener\"\u003ehttps:\/\/ocr.oakpdf.com\/n8n_fix.png\u003c\/a\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRapidAPI HTTP auth:\u003c\/strong\u003e create an \u003cstrong\u003e“HTTP header” credential\u003c\/strong\u003e and add your RapidAPI key from \u003ca href=\"https:\/\/rapidapi.com\/restyler\/api\/receipt-and-invoice-ocr-api\" target=\"_blank\" rel=\"noopener\"\u003eRapidAPI\u003c\/a\u003e, then ensure the \u003cstrong\u003eHTTP Request\u003c\/strong\u003e node uses it.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle OAuth:\u003c\/strong\u003e set up Google credentials for \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheets template:\u003c\/strong\u003e copy the provided Google Sheets document to use with the workflow.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDrop scanned receipts into a Google Drive folder and have them \u003cstrong\u003eOCR processed into line items\/fields\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eMaintain an always-up-to-date bookkeeping spreadsheet from recurring invoice uploads.\u003c\/li\u003e\n  \u003cli\u003eAutomate OCR invoice intake for SaaS operations teams and automation engineers using n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTech stack \/ nodes:\u003c\/strong\u003e code, merge, sticky note, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOCR provider:\u003c\/strong\u003e Receipt and Invoice OCR API on RapidAPI (\u003cstrong\u003eHTTP header\u003c\/strong\u003e credential)\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eVideo demo:\u003c\/strong\u003e \u003ca href=\"https:\/\/youtu.be\/mGPt7fqGQD8\" target=\"_blank\" rel=\"noopener\"\u003ehttps:\/\/youtu.be\/mGPt7fqGQD8\u003c\/a\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45756678897843,"sku":"N8N-2389","price":30.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wdr-wcFmrr0ho7TKav6ti_j3aNi7M9.png?v=1785748345","url":"https:\/\/buyflowscripts.com\/products\/ocr-invoices-from-google-drive-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}