Automatically send weekly sales reports from Square via Outlook

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

What this workflow does

This workflow has 9 nodes and runs on a schedule (every week at 08:00). Along the way it connects Microsoft Outlook. It also calls connect.squareup.com over HTTP.

How it runs

Trigger: On a schedule (every week at 08:00).

1. Get Dates From Last Week (Code): runs custom JavaScript code
2. Get Square Locations (HTTP Request): calls connect.squareup.com
3. Turn Locations Into List (Split Out): splits a list into separate items
4. Get Sales from Square (HTTP Request): calls connect.squareup.com (POST)
5. Ignore Locations w/o Sales (If): checks a condition and branches into true / false
6. Compile Sales Reports (Code): runs custom JavaScript code
7. Convert Sales Summary to CSV File (Convert to File): converts data to a file
8. 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 Weekly Sales Reports from Square via Outlook What It Does This workflow automatically connects to the Square API and generates a weekly sales summary report for all your Square locations. The report matches the figures displayed in Square…

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