Automatically send daily sales summary reports from Square via Microsoft Outlook

by Rosh Ragel ✓ · 250 views · created 2025-08-07 · CRM

What this workflow does

This workflow has 8 nodes and runs on a schedule (every day). Along the way it connects Microsoft Outlook. It also calls connect.squareup.com over HTTP.

How it runs

Trigger: On a schedule (every day).

1. Get Square Locations (HTTP Request): calls connect.squareup.com
2. Turn Locations Into List (Split Out): splits a list into separate items
3. Get Sales from Square (HTTP Request): calls connect.squareup.com (POST)
4. Ignore Locations w/o Sales (If): checks a condition and branches into true / false
5. Compile Sales Reports (Code): runs custom JavaScript code
6. Convert Sales Summary to CSV File (Convert to File): converts data to a file
7. Send Report (Microsoft Outlook): uses Microsoft Outlook

Services it uses

Microsoft Outlook

HTTP calls to: connect.squareup.com

Before you upgrade to n8n 3.0

Nodes used (7)

• HTTP Requestn8n-nodes-base.httpRequest
• Split Outn8n-nodes-base.splitOut
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Convert to Filen8n-nodes-base.convertToFile
• Microsoft Outlookn8n-nodes-base.microsoftOutlook

From the author

Automatically Send Square Summary Report for Yesterday's Sales via Microsoft Outlook What It Does This workflow automatically connects to the Square API and generates a daily sales summary report for all your Square locations. The report matches the figures…

View the original on n8n.io → Check your own copy