Send daily marketplace KPI reports via Slack and Microsoft Outlook
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs on a schedule (every day at 10:00). Along the way it connects Microsoft Outlook and Slack.
How it runs
Trigger: On a schedule (every day at 10:00).
- Read Config File from Disk (Read/Write Files from Disk): reads a file from disk
- Extract Config Data (Extract from File): extracts data from a file (from json)
- Split Data by Field (Split Out): splits a list into separate items
- Loop Over Split Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Set Additional Metrics (Edit Fields (Set)): sets 11 fields: date, marketplace, nombre_offres…
- Fetch Marketplace Stats (HTTP Request): calls an HTTP API
- Convert Data to File (Convert to File): converts data to a file (xlsx)
- Set Marketplace Metrics (Edit Fields (Set)): sets 12 fields: marketplace, nombre_offres, nombre_commande…
- Post Slack Alert (Slack): uses Slack
- Send Outlook Notification (Microsoft Outlook): uses Microsoft Outlook
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Edit Fields (Set)
n8n-nodes-base.set - Read/Write Files from Disk
n8n-nodes-base.readWriteFile - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Slack
n8n-nodes-base.slack - Convert to File
n8n-nodes-base.convertToFile - Extract from File
n8n-nodes-base.extractFromFile - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick Overview This workflow runs daily at 10am, reads a marketplaces configuration file, fetches KPI statistics from marketplace APIs via HTTP requests, compiles the results into an Excel file, then posts a Slack notification and emails the file using…