{"product_id":"aruba-e-invoice-imap-to-excel-openai-dropbox-gmail-alerts-n8n","title":"Aruba e-Invoice IMAP to Excel: OpenAI, Dropbox \u0026 Gmail Alerts (n8n)","description":"\u003ch3\u003eTurn Aruba e-invoice emails into monthly Excel reports in Dropbox—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors Aruba “Hai ricevuto una nuova fattura elettronica” email notices via IMAP, extracts invoice data, and generates a consolidated Excel report each month—then uploads it to Dropbox. You’ll also receive Gmail alerts if parsing fails or if the workflow errors.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003ePolls Aruba e-invoice notice emails\u003c\/b\u003e using IMAP, filtering by the configured email subject and tracking the \u003cb\u003elast processed message\u003c\/b\u003e to avoid reprocessing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eParses email content\u003c\/b\u003e to extract key fields: \u003cb\u003esupplier\u003c\/b\u003e, \u003cb\u003einvoice number\u003c\/b\u003e, \u003cb\u003edocument date\u003c\/b\u003e, \u003cb\u003edocument type\u003c\/b\u003e, and \u003cb\u003etotals\u003c\/b\u003e, plus the \u003cb\u003ereceipt timestamp\u003c\/b\u003e in \u003cb\u003eEurope\/Rome\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDerives a monthly key (yyyy.MM)\u003c\/b\u003e and \u003cb\u003eupserts** successfully parsed invoices into an n8n data table\u003c\/b\u003e using a unique key to prevent duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNotifies you when parsing fails\u003c\/b\u003e by sending a \u003cb\u003eGmail email notification\u003c\/b\u003e, so you can review and update the parsing logic.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOn schedule, consolidates monthly data\u003c\/b\u003e: on the \u003cb\u003e1st of each month at 07:10\u003c\/b\u003e (or via an authenticated \u003cb\u003ewebhook\u003c\/b\u003e with a target month), it selects the stored invoices for that month.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCreates an Excel file\u003c\/b\u003e for the chosen month, treating \u003cb\u003ecredit notes as negative\u003c\/b\u003e, then \u003cb\u003euploads it to Dropbox\u003c\/b\u003e to a prepared destination path.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eErrors trigger Gmail alerts\u003c\/b\u003e including the \u003cb\u003elast executed step\u003c\/b\u003e and a \u003cb\u003elink to the failed n8n execution\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators consolidating Aruba e-invoices into monthly bookkeeping spreadsheets.\u003c\/li\u003e\n  \u003cli\u003en8n users who want automated data extraction from email notices without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eFinance teams needing Dropbox-hosted Excel reports with built-in monitoring via Gmail alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIMAP + subject filter for Aruba notice emails (“Hai ricevuto una nuova fattura elettronica”).\u003c\/li\u003e\n  \u003cli\u003eData parsing and monthly logic implemented with \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, and \u003cb\u003ecode\u003c\/b\u003e nodes.\u003c\/li\u003e\n  \u003cli\u003eEmail alerts via \u003cb\u003eGmail\u003c\/b\u003e (parsing failures and workflow errors).\u003c\/li\u003e\n  \u003cli\u003eMonthly scheduling and month selection via \u003cb\u003eswitch\u003c\/b\u003e (plus optional authenticated \u003cb\u003ewebhook\u003c\/b\u003e).\u003c\/li\u003e\n  \u003cli\u003eExcel generation and delivery to \u003cb\u003eDropbox\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46289275453619,"sku":"N8N-21528","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Xgxd4GIBSXfDE5saDWDpf_P255aIrB.png?v=1793006809","url":"https:\/\/buyflowscripts.com\/products\/aruba-e-invoice-imap-to-excel-openai-dropbox-gmail-alerts-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}