{"product_id":"n8n-gmail-to-arabic-sales-dashboard-with-gemini-excel","title":"n8n Gmail to Arabic Sales Dashboard with Gemini + Excel","description":"\u003ch3\u003eTurn Gmail Excel sales emails into an Arabic AI dashboard—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Gmail inbox for incoming \u003cb\u003eExcel (.xls)\u003c\/b\u003e attachments from a specific sender, uses \u003cb\u003eGoogle Gemini\u003c\/b\u003e to clean and analyze the sales data, then replies with an \u003cb\u003eArabic HTML dashboard\u003c\/b\u003e plus a \u003cb\u003enew, cleaned Excel (.xlsx)\u003c\/b\u003e file—back to the same Gmail thread.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns every minute\u003c\/b\u003e when a new Gmail message arrives from the configured sender and downloads attachments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFilters attachments\u003c\/b\u003e to keep only \u003cb\u003e.xls\u003c\/b\u003e Excel files and forwards them as binary data for processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts tabular data\u003c\/b\u003e from the Excel file and \u003cb\u003eaggregates rows\u003c\/b\u003e into a single dataset.\u003c\/li\u003e\n  \u003cli\u003eSends the dataset to a \u003cb\u003eGoogle Gemini (PaLM)–powered AI agent\u003c\/b\u003e to:\n    \u003cul\u003e\n      \u003cli\u003efix corrupted \u003cb\u003eArabic encoding\u003c\/b\u003e,\u003c\/li\u003e\n      \u003cli\u003eremove\/rename \u003cb\u003eempty columns\u003c\/b\u003e,\u003c\/li\u003e\n      \u003cli\u003ecompute \u003cb\u003eachievement rates\u003c\/b\u003e,\u003c\/li\u003e\n      \u003cli\u003egenerate an \u003cb\u003eArabic HTML dashboard\u003c\/b\u003e and cleaned\/enriched records for export.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eParses Gemini output\u003c\/b\u003e into:\n    \u003cul\u003e\n      \u003cli\u003ean HTML report for the email body,\u003c\/li\u003e\n      \u003cli\u003ean array of cleaned records for Excel export.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSplits, converts, and exports\u003c\/b\u003e the cleaned records into a new \u003cb\u003e.xlsx\u003c\/b\u003e file.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReplies in Gmail\u003c\/b\u003e to the incoming thread using the \u003cb\u003eincoming message ID\u003c\/b\u003e, attaching the generated Excel and sending the Arabic HTML dashboard.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically convert weekly\/monthly sales spreadsheets emailed by a partner into a ready-to-share Arabic dashboard.\u003c\/li\u003e\n  \u003cli\u003eClean corrupted Arabic text and restructure inconsistent Excel layouts without manual rework.\u003c\/li\u003e\n  \u003cli\u003eProvide operations\/SaaS teams with achievement rate reporting immediately after Excel submissions arrive.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail Trigger\u003c\/b\u003e (sender filter + thread reply using incoming message ID)\u003c\/li\u003e\n  \u003cli\u003eExcel binary handling and \u003cb\u003etabular data extraction\u003c\/b\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Gemini (PaLM)\u003c\/b\u003e AI agent for Arabic encoding fixes, column cleanup, achievement rate computation, and HTML generation\u003c\/li\u003e\n  \u003cli\u003en8n nodes mentioned in the workflow: \u003cb\u003eset, code, gmail, merge, split out, aggregate\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865760555187,"sku":"N8N-18373","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sg1LxpggMrP-PjcgWAt1L_qCilDyPn.png?v=1787044244","url":"https:\/\/buyflowscripts.com\/products\/n8n-gmail-to-arabic-sales-dashboard-with-gemini-excel","provider":"N8N Commerce","version":"1.0","type":"link"}