This workflow is built from 24 nodes. Here's what each one does:
| # | Node | Type | What it does |
|---|---|---|---|
| 1 | Weekly Monday Trigger | Schedule Trigger | Starts the workflow automatically on a schedule. |
| 2 | CONFIG — Store Settings | Set | Holds editable configuration values — fill in your own settings here before activating. |
| 3 | Log Run — Status NEW | Google Sheets | Reads from or writes to a Google Sheet — this workflow's log and state store. |
| 4 | List Store Sheets — Google Drive | Google Drive | Uploads, downloads, or manages files in Google Drive. |
| 5 | Prepare Store List | Code | Runs custom JavaScript to transform, filter, or compute data between steps. |
| 6 | IF — Sheets Found | IF | Splits the flow into branches based on a condition. |
| 7 | Loop Stores — Split In Batches | Split In Batches | Processes a long list of items in small batches. |
| 8 | Read Store Sheet | Google Sheets | Reads from or writes to a Google Sheet — this workflow's log and state store. |
| 9 | Tag Rows — Add Store Name | Code | Runs custom JavaScript to transform, filter, or compute data between steps. |
| 10 | Append Consolidated Rows | Google Sheets | Reads from or writes to a Google Sheet — this workflow's log and state store. |
| 11 | Read Consolidated Rows — This Week | Google Sheets | Reads from or writes to a Google Sheet — this workflow's log and state store. |
| 12 | Compute Weekly Totals | Code | Runs custom JavaScript to transform, filter, or compute data between steps. |
| 13 | Log Run — Status PROCESSING | Google Sheets | Reads from or writes to a Google Sheet — this workflow's log and state store. |
| 14 | AI Agent — Weekly Sales Analyst | AI Agent | The AI brain — reasons over the task and calls tools to get it done. |
| 15 | OpenAI Chat Model — Analyst | OpenAI Chat Model | The language model powering the AI agent. |
| 16 | Structured Output Parser — Sales Insights | Structured Output Parser | Forces the AI to return clean, structured JSON instead of free text. |
| 17 | IF — Revenue Anomaly | IF | Splits the flow into branches based on a condition. |
| 18 | Telegram — Anomaly Alert | Telegram | Sends you a Telegram message or alert. |
| 19 | Build Report HTML | Code | Runs custom JavaScript to transform, filter, or compute data between steps. |
| 20 | Gmail — Send Weekly Report | Gmail | Sends or reads email through your Gmail account. |
| 21 | Log Run — Status DONE | Google Sheets | Reads from or writes to a Google Sheet — this workflow's log and state store. |
| 22 | Telegram — Success Notification | Telegram | Sends you a Telegram message or alert. |
| 23 | Log Run — Status FAILED | Google Sheets | Reads from or writes to a Google Sheet — this workflow's log and state store. |
| 24 | Telegram — Failure Alert | Telegram | Sends you a Telegram message or alert. |