Forecast sales trends and weekly reports with Stripe, Sheets, Slack, and Gemini AI
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Google Gemini Chat Model, Notion and Slack and 1 more. It also calls api.stripe.com over HTTP.
How it runs
Trigger: On a schedule (every day).
- Configuration Settings (Edit Fields (Set)): sets or maps fields
- Get Stripe Charges (HTTP Request): calls api.stripe.com
- Get Stripe Subscriptions (HTTP Request): calls api.stripe.com
- Get Stripe Refunds (HTTP Request): calls api.stripe.com
- Load Historical Sales (Google Sheets): uses Google Sheets
- Merge and Process Data (Code): runs custom JavaScript code
- Calculate Trends (Code): runs custom JavaScript code
- Generate Sales Analysis (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini AI Model
- Check for Anomalies (If): checks a condition and branches into true / false
- Log to Historical Sheet (Google Sheets): append
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: api.stripe.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - If
n8n-nodes-base.if - Notion
n8n-nodes-base.notion - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set
From the author
Forecast sales trends and generate reports with Stripe, Sheets, and Gemini AI Who is this for Revenue operations teams, SaaS growth managers, and sales directors who need automated weekly insights from their Stripe payment data. Perfect for small to medium…