Pull Square Sales Summary Reports for Automated Analysis

This n8n sub-workflow connects to the Square API to programmatically generate daily sales summary reports for all linked locations, exactly matching the data shown in Square Dashboard > Reports > Sales Summary. It requires a 'report_date' input to pull completed orders, filter out inactive locations, and aggregate key metrics like gross sales, net sales, refunds, taxes, and more via a custom Code node for precise calculations.

Setup is straightforward: configure Header Auth credentials with your Square access token (Bearer format). No additional apps needed beyond n8n. It's designed for reuse in parent workflows, outputting clean, structured JSON data ready for downstream processing.

Key steps include fetching locations, looping to retrieve orders per location, filtering empty results, and producing a consolidated summary. Benefits include time savings on manual reporting, data consistency, and scalability for multi-location businesses.

Ideal use cases: auto-store data in Google Sheets, databases, or accounting tools like QuickBooks/Xero; send daily Slack/email reports; build weekly/monthly aggregates; automate commissions or rent calculations based on sales volume. Enhances BI pipelines without custom coding beyond n8n.