{"product_id":"mailmint-imap-supplier-invoice-emails-to-google-sheets-via-n8n","title":"MailMint IMAP Supplier Invoice Emails to Google Sheets via n8n","description":"\u003ch3\u003eTurn supplier invoice emails into auditable Google Sheets rows—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches an IMAP mailbox for supplier invoices, extracts the invoice fields with \u003cstrong\u003eMailMint\u003c\/strong\u003e, and appends \u003cstrong\u003eone verified row per email\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including \u003cstrong\u003econfidence\u003c\/strong\u003e and the \u003cstrong\u003everbatim text\u003c\/strong\u003e each value came from, so you can audit instead of trust.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWatches your invoices mailbox\u003c\/strong\u003e using n8n’s built-in \u003cstrong\u003eEmail Trigger (IMAP)\u003c\/strong\u003e. Point it at the mailbox your suppliers send to—supporting all \u003cstrong\u003ethree Email Trigger formats\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSets your spreadsheet policy in one place\u003c\/strong\u003e: configure the target spreadsheet, the tab, the expected \u003cstrong\u003ecurrency\u003c\/strong\u003e, and the \u003cstrong\u003eamount threshold\u003c\/strong\u003e where a human should review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads invoice fields with MailMint\u003c\/strong\u003e: the MailMint node is left on \u003cstrong\u003eInput = Automatic\u003c\/strong\u003e, so it understands the IMAP trigger’s RAW, Resolved, and Simple formats without manual mapping.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns confidence + verbatim extraction\u003c\/strong\u003e for every field. Each extracted value includes:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003econfidence\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003ethe \u003cstrong\u003elayer it came from\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ethe \u003cstrong\u003everbatim text\u003c\/strong\u003e used\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles missing required fields\u003c\/strong\u003e: if a required field can’t be found, it routes to the node’s \u003cstrong\u003esecond output\u003c\/strong\u003e so you don’t silently get blank cells.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNever hard-stops the workflow\u003c\/strong\u003e: if the MailMint API is unreachable, it’s set to \u003cstrong\u003econtinue on failure\u003c\/strong\u003e and writes an \u003cstrong\u003eerror row\u003c\/strong\u003e to the sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAccounts payable teams who currently \u003cem\u003eretype\u003c\/em\u003e supplier invoices from email into spreadsheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need repeatable \u003cstrong\u003einvoice-to-Spreadsheet\u003c\/strong\u003e processing with audit trails.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an \u003cstrong\u003eIMAP → MailMint → Google Sheets\u003c\/strong\u003e workflow for supplier document ingestion.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Email Trigger (IMAP)\u003c\/strong\u003e to watch the mailbox (all three supported formats).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMailMint\u003c\/strong\u003e for invoice field extraction (Input: Automatic).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as the destination for appended rows.\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes include \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and supporting logic (plus Google Sheets output and canvas-configured policy).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938295996595,"sku":"N8N-18943","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XOlS4xpvqnF43EKsVG2ji_jpPdKn5j.png?v=1788341340","url":"https:\/\/buyflowscripts.com\/products\/mailmint-imap-supplier-invoice-emails-to-google-sheets-via-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}