Weekly Square Sales Reports Automated via Gmail
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
- Quentin Andersen
- 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.
Related Education workflows
- Learn JSON Basics with an Interactive Step-by-Step Tutorial for Beginners$14.99
- Learn n8n Expressions with an Interactive Step-by-Step Tutorial for Beginners$14.99
- Automated AI Degree Audit Using Google Sheets and OpenAI$9.99
- Learn API Fundamentals with an Interactive Hands-On Tutorial Workflow$24.99
- Master Webhook Integration and Security with Supabase in n8n$14.99
- Master JavaScript Code Node with Interactive n8n Tutorial$9.99
More from Quentin Andersen
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.