Automatically Import Square Sales Summary Reports into Google Sheets

This n8n workflow connects to the Square API to generate and import daily sales summary reports directly into Google Sheets. It runs automatically every day at 4:00 AM, pulling completed orders from the previous day across all linked Square locations. The aggregation logic in a custom Code node replicates the exact figures shown in Square Dashboard > Reports > Sales Summary, ensuring accuracy for business tracking. Key steps include retrieving locations via HTTP request, fetching orders per loc