This n8n workflow automates the process of fetching, compiling, and sharing weekly sales data from Square. It schedules the task every Monday at 8:00 AM, then retrieves all Square locations via an HTTP request to the Square API. For each location, it pulls completed orders from the previous week using another HTTP request, filtering out locations with no sales. A custom code node processes the raw order data, calculating key sales metrics such as gross sales, total returns, discounts, taxes, tips, and different tender types, generating a comprehensive sales summary that mimics Square’s built-in reports. The data is then exported into a CSV file, which is automatically emailed to designated recipients, such as management or finance teams, with a clear and professional report attached. This workflow is ideal for businesses seeking to streamline weekly sales reporting, improve accuracy, and save time by automating data collection and distribution. Practical use cases include sales monitoring, financial reporting, and operational decision-making, effortlessly integrating Square data into ongoing business processes.