{"product_id":"gmail-erp-sales-report-summarizer-with-gemini-excel-reply","title":"Gmail ERP Sales Report Summarizer with Gemini \u0026 Excel Reply","description":"\u003ch3\u003eTurn incoming Gmail Excel ERP sales files into an Arabic dashboard + clean XLSX—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Gmail inbox for a specific sender, extracts attached Excel (.xls\/.xlsx) ERP sales reports, uses Google Gemini to clean and analyze the data, then replies in the same Gmail thread with an Arabic HTML sales dashboard and a newly generated XLSX report attached.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eMonitors Gmail every minute\u003c\/b\u003e for new messages from the configured sender and downloads attachments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFilters attachments to Excel files\u003c\/b\u003e only, passing the selected .xls\/.xlsx file(s) onward.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts structured ERP sales data\u003c\/b\u003e from the XLS attachment(s) and aggregates rows into a single dataset.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses Google Gemini (PaLM) to fix and analyze sales data\u003c\/b\u003e—including cleaning corrupted Arabic encoding, removing\/renaming empty or unclear columns, computing \u003cb\u003eachievement rates\u003c\/b\u003e, and calculating \u003cb\u003enet sales (invoices minus returns)\u003c\/b\u003e, plus generating BI insights.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eParses strict JSON output\u003c\/b\u003e from the agent to create an \u003cb\u003eArabic-ready HTML dashboard\u003c\/b\u003e email body.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExports a cleaned Excel report\u003c\/b\u003e: converts the cleaned dataset into a new \u003cb\u003eXLSX\u003c\/b\u003e file and replies to the original thread with both the dashboard and the attachment.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eERP sales teams receiving periodic Excel exports via email and needing consistent, cleaned reporting without manual work.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want automated “data-to-dashboard” reporting directly from Gmail attachments.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building reliable Excel summarization with AI-powered Arabic fixes and computed KPIs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n Gmail OAuth2 trigger\u003c\/b\u003e (runs every minute; sender filter applied)\u003c\/li\u003e\n  \u003cli\u003eNodes used include: \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003esplit out\u003c\/b\u003e, \u003cb\u003eaggregate\u003c\/b\u003e, and \u003cb\u003emerge\u003c\/b\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Gemini (PaLM)\u003c\/b\u003e chat model agent for Arabic encoding correction, column cleanup, KPI computation, and insights generation\u003c\/li\u003e\n  \u003cli\u003eOutputs: \u003cb\u003eArabic HTML email dashboard\u003c\/b\u003e + \u003cb\u003enew XLSX\u003c\/b\u003e file attached to the Gmail reply\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eIdeal for\u003c\/b\u003e anyone running n8n workflows that summarize ERP sales data from Gmail-based Excel exports—reliably, with an AI-assisted cleaned dataset and instant reporting.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865760686259,"sku":"N8N-18372","price":71.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/12VF4qrhzC2B4UgrbVHwa_t02dK0Wl.png?v=1787044269","url":"https:\/\/buyflowscripts.com\/products\/gmail-erp-sales-report-summarizer-with-gemini-excel-reply","provider":"N8N Commerce","version":"1.0","type":"link"}