{"product_id":"extract-gulf-tax-invoices-with-gemini-google-drive-to-sheets-n8n","title":"Extract Gulf Tax Invoices with Gemini: Google Drive to Sheets (n8n)","description":"\u003ch3\u003eExtract Arabic\/English Gulf Tax Invoices automatically with Google Drive + Gemini → Google Sheets (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive inbox for new invoice PDFs\/images, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract invoice + line-item data, validates and normalizes Arabic dates\/numbers, and then records everything into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—routing files to \u003cem\u003eProcessed\u003c\/em\u003e or \u003cem\u003eNeeds review\u003c\/em\u003e based on validation flags.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects new invoices:\u003c\/strong\u003e Triggers when a new file is created in your specified Google Drive inbox folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts invoice data with Gemini:\u003c\/strong\u003e Downloads the file and sends it to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract invoice fields and line items as a single JSON object.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes numbers and dates:\u003c\/strong\u003e Converts Arabic-Indic digits, attempts \u003cstrong\u003eHijri (Umm al-Qura)\u003c\/strong\u003e to \u003cstrong\u003eGregorian\u003c\/strong\u003e date conversion, and standardizes the extracted values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates Gulf VAT details:\u003c\/strong\u003e Checks KSA\/UAE VAT number formats and verifies totals\/VAT calculations and model confidence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets:\u003c\/strong\u003e\n    \u003cul\u003e\n      \u003cli\u003eAppends one row to the \u003cstrong\u003eInvoices\u003c\/strong\u003e tab for each normalized invoice.\u003c\/li\u003e\n      \u003cli\u003eExpands extracted line items into \u003cstrong\u003eone row per item\u003c\/strong\u003e in the \u003cstrong\u003eLine items\u003c\/strong\u003e tab.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes files for governance:\u003c\/strong\u003e Moves each original file to \u003cstrong\u003eNeeds review\u003c\/strong\u003e when validation flags issues; otherwise moves it to \u003cstrong\u003eProcessed\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomating invoice ingestion for \u003cstrong\u003eKSA\/UAE\u003c\/strong\u003e VAT workflows without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eBack-office processing where invoices arrive as PDFs\/images in a shared Google Drive folder.\u003c\/li\u003e\n  \u003cli\u003eSaaS operations teams needing audit-friendly validation and line-item detail in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n trigger\/integrations:\u003c\/strong\u003e Google Drive, Google Sheets, Google Gemini (Google AI Studio API key).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic nodes:\u003c\/strong\u003e if, set, code, sticky note (for orchestration and validation flags).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e Configure Google credentials, create Drive folders (inbox, processed, needs review), and ensure your spreadsheet has tabs named \u003cstrong\u003eInvoices\u003c\/strong\u003e and \u003cstrong\u003eLine items\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244543922355,"sku":"N8N-21146","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tSa0vyknjl563BxrEd5zP_o1zaJ24Q.png?v=1792401220","url":"https:\/\/buyflowscripts.com\/products\/extract-gulf-tax-invoices-with-gemini-google-drive-to-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}