Templates / Forecast sales trends and weekly reports with Stripe, Sheets, Slack, and Gemini AI

Forecast sales trends and weekly reports with Stripe, Sheets, Slack, and Gemini AI

Ready for 3.0

by Oka Hironobu ✓ · 130 views · created 2026-03-10 · CRM, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Configuration Settings (Edit Fields (Set)): sets or maps fields
  2. Get Stripe Charges (HTTP Request): calls api.stripe.com
  3. Get Stripe Subscriptions (HTTP Request): calls api.stripe.com
  4. Get Stripe Refunds (HTTP Request): calls api.stripe.com
  5. Load Historical Sales (Google Sheets): uses Google Sheets
  6. Merge and Process Data (Code): runs custom JavaScript code
  7. Calculate Trends (Code): runs custom JavaScript code
  8. Generate Sales Analysis (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini AI Model
  9. Check for Anomalies (If): checks a condition and branches into true / false
  10. Log to Historical Sheet (Google Sheets): append

…plus 4 more steps. See the full node list below.

Services it uses

Google SheetsGoogle Gemini Chat ModelNotionSlackGmail

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)

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…

Excerpt from Oka Hironobu's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.