Analytics Workflow.json

This Analytics Workflow is an automated system designed to retrieve weekly order data, update records in Airtable, and send a summary report to Discord.

Workflow Overview

• Schedule: The process triggers automatically every Monday at 9:00 AM.
• Data Retrieval: It fetches the latest order information from an internal ERP system via an HTTP Request.

Processing Logic

The workflow splits the retrieved data into two paths based on the orderStatus:

1. For Orders "In Processing":
   • The system extracts the orderID and employeeName.
   • It then creates a new record in the Processed Orders table within the "Orders - Alex" Airtable base.
2. For All Other Orders (Booked Orders):
   • Calculation: A JavaScript snippet calculates the total number of orders and the sum of their prices.
   • Notification: It sends a summary message to Discord stating: "This week we've [Total] booked orders with a total value of [Sum].".

Key Integrations

• ERP System: Primary data source.
• Airtable: Used for tracking specific processing details.
• Discord: Used for weekly performance reporting.