{"product_id":"carrefour-receipt-ocr-workflow-with-mistral-gemini-google-sheets","title":"Carrefour Receipt OCR Workflow with Mistral, Gemini \u0026 Google Sheets","description":"\u003ch3\u003eTurn receipt images into structured data—with confidence checks and human approval\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eCarrefour Receipt OCR\u003c\/strong\u003e n8n workflow receives receipt images via \u003cstrong\u003eWebhook\u003c\/strong\u003e or \u003cstrong\u003eTelegram\u003c\/strong\u003e, runs OCR using \u003cstrong\u003eMistral\u003c\/strong\u003e with word-level confidence scoring, routes low-confidence documents to \u003cstrong\u003eGmail approval\u003c\/strong\u003e, then extracts fields and line items with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e and upserts them into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—while logging every step to \u003cstrong\u003ePostgres\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests a receipt\u003c\/strong\u003e from a POST webhook request (preferred for accuracy) or an incoming Telegram message attachment (downloads the image).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts the file to a base64 data URL\u003c\/strong\u003e and sends it to the \u003cstrong\u003eMistral OCR API\u003c\/strong\u003e for text extraction with \u003cem\u003eword-level confidence\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates confidence metrics\u003c\/strong\u003e (minimum\/average) and flags low-confidence words; stores execution metadata and inserts an audit row into the Postgres \u003ccode\u003edocument_processing_log\u003c\/code\u003e table.\u003c\/li\u003e\n  \u003cli\u003eIf OCR confidence is below the threshold, sends a \u003cstrong\u003eGmail “send and wait” approval email\u003c\/strong\u003e containing the OCR text and flagged words, then updates the log as \u003cstrong\u003eapproved or rejected\u003c\/strong\u003e based on the response.\u003c\/li\u003e\n  \u003cli\u003eIf approved (or if no review is needed), uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e with a \u003cstrong\u003estructured output schema\u003c\/strong\u003e to extract receipt header fields and item lines from the OCR text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e: splits extracted items into individual rows and appends or updates them in the receipts sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinalizes and notifies\u003c\/strong\u003e: updates Postgres status (including “inserted”) and emails a \u003cstrong\u003esuccess or rejection notification\u003c\/strong\u003e with the original document attached.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCarrefour receipt capture for \u003cstrong\u003eexpense tracking\u003c\/strong\u003e with an audit trail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHuman-in-the-loop\u003c\/strong\u003e review when OCR confidence is uncertain.\u003c\/li\u003e\n  \u003cli\u003eSaaS operations where receipt data must be reliably stored in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and logged in \u003cstrong\u003ePostgres\u003c\/strong\u003e.\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\/tools\u003c\/strong\u003e: webhook, telegram (download attachment), code (confidence scoring + data handling), Mistral OCR API, Gemini (structured extraction), Google Sheets (append\/update), Gmail (send and wait + notifications), Postgres (document_processing_log), and sticky note for workflow guidance.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764322164915,"sku":"N8N-17856","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xAy8jeLxSQqCOgYc0TEIY_WZijapKi.png?v=1786007284","url":"https:\/\/buyflowscripts.com\/products\/carrefour-receipt-ocr-workflow-with-mistral-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}