Daily Square Sales Summary Reports via Gmail Automation

This n8n workflow connects to the Square API to fetch and aggregate sales data from all linked locations, producing a CSV report identical to Square's Sales Summary dashboard. It triggers daily at 4:00 AM, pulls yesterday's completed orders, filters out zero-sales locations, processes data via custom code for accurate summaries, creates a CSV file, and sends it via Gmail to managers or finance teams.

Key benefits include time savings by eliminating manual report generation, ensuring consistent daily insights without dashboard logins, and scalability across multiple locations. It builds on Square API best practices, requiring only Header Auth credentials for Square and Gmail setup.

Ideal use cases: E-commerce businesses tracking daily performance, restaurants monitoring POS sales, retail chains distributing reports to stakeholders. Enhances decision-making with automated, reliable data delivery, reducing errors from manual exports.