n8n Gmail to Arabic Sales Dashboard with Gemini + Excel

Turn Gmail Excel sales emails into an Arabic AI dashboard—automatically

This n8n workflow watches your Gmail inbox for incoming Excel (.xls) attachments from a specific sender, uses Google Gemini to clean and analyze the sales data, then replies with an Arabic HTML dashboard plus a new, cleaned Excel (.xlsx) file—back to the same Gmail thread.

What this workflow does

• Runs every minute when a new Gmail message arrives from the configured sender and downloads attachments.
• Filters attachments to keep only .xls Excel files and forwards them as binary data for processing.
• Extracts tabular data from the Excel file and aggregates rows into a single dataset.
• Sends the dataset to a Google Gemini (PaLM)–powered AI agent to:
  • fix corrupted Arabic encoding,
  • remove/rename empty columns,
  • compute achievement rates,
  • generate an Arabic HTML dashboard and cleaned/enriched records for export.
• Parses Gemini output into:
  • an HTML report for the email body,
  • an array of cleaned records for Excel export.
• Splits, converts, and exports the cleaned records into a new .xlsx file.
• Replies in Gmail to the incoming thread using the incoming message ID, attaching the generated Excel and sending the Arabic HTML dashboard.

Use cases

• Automatically convert weekly/monthly sales spreadsheets emailed by a partner into a ready-to-share Arabic dashboard.
• Clean corrupted Arabic text and restructure inconsistent Excel layouts without manual rework.
• Provide operations/SaaS teams with achievement rate reporting immediately after Excel submissions arrive.

Technical details

• Gmail Trigger (sender filter + thread reply using incoming message ID)
• Excel binary handling and tabular data extraction
• Google Gemini (PaLM) AI agent for Arabic encoding fixes, column cleanup, achievement rate computation, and HTML generation
• n8n nodes mentioned in the workflow: set, code, gmail, merge, split out, aggregate