Weekly Square Sales Reports Automated via Gmail

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 insights without errors, and scalability across multiple locations. It's ideal for e-commerce businesses, retailers, or restaurants using Square, providing actionable sales analytics automatically.

Use cases: Send reports to executives for performance reviews, integrate with BI tools for deeper analysis, or notify teams of trends like top-selling items. Builds on Square API basics, requiring only Header Auth credentials. Perfect for automating business intelligence in sales operations.