Automatically send monthly sales reports from Square via Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs on a schedule (every month at 08:00). Along the way it connects Gmail. It also calls connect.squareup.com over HTTP.
How it runs
Trigger: On a schedule (every month at 08:00).
- Get Dates From Last Month (Code): runs custom JavaScript code
- Get Square Locations (HTTP Request): calls connect.squareup.com
- Turn Locations Into List (Split Out): splits a list into separate items
- Get Sales from Square (HTTP Request): calls connect.squareup.com (POST)
- Ignore Locations w/o Sales (If): checks a condition and branches into true / false
- Compile Sales Reports (Code): runs custom JavaScript code
- Convert Sales Summary to CSV File (Convert to File): converts data to a file
- Send Report (Gmail): uses Gmail
Services it uses
HTTP calls to: connect.squareup.com
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 (7)
- HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Convert to File
n8n-nodes-base.convertToFile - Gmail
n8n-nodes-base.gmail
From the author
Automatically Send Monthly Sales Reports from Square via Gmail What It Does This workflow automatically connects to the Square API and generates a monthly sales summary report for all your Square locations. The report matches the figures displayed in Square…