Automates pulling previous week's sales from Square API across locations, generates CSV summary matching Square Dashboard, and emails to team.
This n8n workflow connects to the Square API to fetch sales data for all linked locations every Monday at 8 AM, covering the prior week's completed orders. It aggregates the data using a custom Code node to replicate Square's Sales Summary report exactly, filters out inactive locations, creates a CSV file, and sends it via email (Gmail or Outlook) to managers or finance teams.
Benefits include time savings by eliminating manual report exports from Square Dashboard, ensuring consistent weekly in
Platform
n8n
Category
Education
Price
$16.99
Creator
Maxim Luong
Square
Sales Report
Gmail
Weekly Automation
CSV Export
E-commerce
Business Intelligence
API Integration
Sales Summary
Automation
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.