{"product_id":"gmail-gemini-n8n-workflow-sales-excel-to-arabic-dashboard","title":"Gmail + Gemini n8n Workflow: Sales Excel to Arabic Dashboard","description":"\u003ch3\u003eTurn Excel sales emails into an Arabic AI dashboard—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGmail + Gemini n8n workflow\u003c\/strong\u003e watches a Gmail inbox for incoming \u003cstrong\u003eExcel (.xls\/.xlsx) sales files\u003c\/strong\u003e, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to clean and analyze the data, then replies in the same email thread with a \u003cstrong\u003eready-to-read Arabic HTML dashboard\u003c\/strong\u003e and a newly generated \u003cstrong\u003eXLSX\u003c\/strong\u003e attachment.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail every minute\u003c\/strong\u003e for new messages from your configured sender and downloads attachments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters attachments\u003c\/strong\u003e to keep only Excel files, then passes the Excel content forward for processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and aggregates sales rows\u003c\/strong\u003e from the attached spreadsheet into a single dataset.\u003c\/li\u003e\n  \u003cli\u003eSends the dataset to a \u003cstrong\u003eGoogle Gemini–powered AI agent\u003c\/strong\u003e to:\n    \u003cul\u003e\n      \u003cli\u003efix \u003cstrong\u003ecorrupted Arabic text\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eremove\/rename empty columns\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003ecalculate achievement rates\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003ecalculate net sales\u003c\/strong\u003e (invoices minus returns)\u003c\/li\u003e\n      \u003cli\u003eproduce an \u003cstrong\u003eArabic HTML dashboard\u003c\/strong\u003e plus cleaned tabular data\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses the AI response\u003c\/strong\u003e into (1) an HTML report for the email body and (2) cleaned rows for export.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a new XLSX\u003c\/strong\u003e from the cleaned rows and \u003cstrong\u003ereplies\u003c\/strong\u003e to the original Gmail thread with the HTML dashboard and the updated spreadsheet attached.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate weekly sales reporting when sales teams email Excel files to a shared address.\u003c\/li\u003e\n  \u003cli\u003eClean corrupted Arabic columns and deliver consistent dashboards without manual spreadsheet work.\u003c\/li\u003e\n  \u003cli\u003eProvide finance\/management with computed \u003cstrong\u003eachievement rate\u003c\/strong\u003e and \u003cstrong\u003enet sales\u003c\/strong\u003e directly in an Arabic email view.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail trigger\u003c\/strong\u003e (OAuth2) with \u003cstrong\u003esender filtering\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eExcel handling with nodes including \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, and \u003cstrong\u003eaggregate\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM) chat model\u003c\/strong\u003e for Arabic text correction and sales calculations\u003c\/li\u003e\n  \u003cli\u003eOutputs: \u003cstrong\u003eArabic HTML dashboard\u003c\/strong\u003e + \u003cstrong\u003ecleaned XLSX\u003c\/strong\u003e attachment, sent via Gmail reply\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e connect a Gmail OAuth2 credential, set the sender filter, and connect a Google Gemini (PaLM) API credential. Incoming emails should include an \u003cstrong\u003e.xls\u003c\/strong\u003e (Excel) attachment.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865760817331,"sku":"N8N-18371","price":35.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/90v_N8azNjkLcvjzxdy-I_YGaoRHGw.png?v=1787044292","url":"https:\/\/buyflowscripts.com\/products\/gmail-gemini-n8n-workflow-sales-excel-to-arabic-dashboard","provider":"N8N Commerce","version":"1.0","type":"link"}