💷 Cash Forecast AI Agent (Zapier)

An AI-powered CFO assistant automating short-term cash forecasting, visualisation, and reporting.
Built with Zapier AI Agents, ChatGPT, Google Workspace, Slack, and Notion.
Author: Marjaana Peeters

---

🧭 Overview

This Cash Forecast AI Agent automates short-term cash forecasting by integrating Google Sheets, ChatGPT reasoning, and Google Workspace outputs - producing an executive-ready forecast and slides deck in minutes.

🧮 Google Sheets → 🤖 ChatGPT → 🎞️ Google Slides → 💾 Google Drive → 🧱 Notion → 💬 Slack

The agent reads transaction data, generates a 14-day forecast, creates a PowerPoint deck, logs results in Notion, and posts a summary in Slack - all automatically.

---

⚙️ Core Capabilities

Feature	Description
📊 Data Ingestion	Reads transactions and control data from Google Sheets
🧠 Forecasting & Narration	ChatGPT produces cash forecast + summary insights
🎞️ Visualisation	Generates a Google Slides forecast deck
💾 Export & Logging	Exports PPTX to Drive and logs key data to Notion
💬 Slack Summary	Posts daily forecast highlights to Slack
🔒 DRY_RUN Mode	Safe testing — no real messages or files sent

---

🧩 Architecture at a Glance

1️⃣ Google Sheets (Transactions & Controls) 2️⃣ ChatGPT (Forecast generation) 3️⃣ Google Slides (Deck creation) 4️⃣ Google Drive (Export) 5️⃣ Notion (Run log) 6️⃣ Slack (Forecast summary)

yaml Copy code

---

📸 Key Screenshots

1️⃣ Google Sheets — Data Tabs

Transactions, controls, and forecast output combined.

2️⃣ Zapier Agent — Tools Configuration

Connected tools: Sheets · ChatGPT · Slides · Drive · Notion · Slack.

3️⃣ Zapier Agent — Instructions Panel

The “Instructions to follow” box showing the Cash Forecast logic.

4️⃣ Zapier Agent — Run Activity

Execution flow: rows read → forecast generated → Slides created → Slack posted.

5️⃣ Google Slides — Generated Deck

Automated forecast presentation created via the Slides API.

6️⃣ Slack — Summary Message

Slack summary confirming forecast results and log completion.

---

🖼️ Full Screenshot Gallery

Click to view all screenshots

Step	Screenshot
Agent Trigger
Gmail Draft (optional)
Drive Export
Notion Log

---

🧾 Setup Summary

1. Import CSVs from /data into a new Google Sheet (transactions, controls, forecast_output).
2. In Zapier → create a new AI Agent named Cash Forecast Agent.
3. Connect: Google Sheets · ChatGPT (OpenAI API key) · Slack · Google Slides · Google Drive · Notion.
4. Paste contents of docs/AGENT_INSTRUCTIONS.md into the “Instructions to follow” box.
5. Trigger manually (On Demand) for first test.
6. Confirm:
   • ✅ Slides deck created
   • ✅ PPTX exported to Drive
   • ✅ Notion log added
   • ✅ Slack message posted
   • ✅ Sheet updated

---

💬 Example Outputs

Slack Summary:

“Cash Forecast Agent run — 2025-09-24
Forecast generated for 14 days ahead.
Opening £45,000 → Closing £49,800 (+£4.8k).
PPTX + Notion log created. DRY_RUN=TRUE.”

Google Slides Deck:

Four slides: Summary · Drivers · Risks · Recommendations — all auto-generated by ChatGPT.

---

🧰 Tech Stack

Layer	Tools
Data	Google Sheets
AI	ChatGPT (OpenAI API)
Workflow	Zapier AI Agents
Output	Google Slides + Drive
Collaboration	Slack
Logging	Notion

---

👩‍💼 Author

Marjaana Peeters
AI-savvy Finance Leader
🌐 LinkedIn: www.linkedin.com/in/marjaana-peeters-0442a4

---

🪶 License

MIT © 2025 Marjaana Peeters