Send sales forecast charts and answer Q&A on WhatsApp with OpenAI

Automatically generates sales forecasts from Google Sheets data, creates visual charts, and provides AI-powered Q&A via WhatsApp.

workflowcrm

by Lee Linon n8n

Nodes

Triggers

Platform

n8n

Tech Stack

AI Agent

OpenAI

Google Sheets

How It Works

This workflow pulls historical sales data from Google Sheets, runs 7 statistical algorithms to select the most accurate forecasting model, and generates business insights with visual charts. An AI agent sends forecast reports to WhatsApp and answers follow-up questions on demand.

Pull historical sales data from Google Sheets

Retrieves sales history data including year, month, and sales figures from your connected Google Sheets document.

Run statistical forecasting algorithms

Executes 7 different forecasting models and backtests them against historical data to select the most accurate algorithm.

Generate AI-powered business insights

AI agent analyzes the mathematical output and translates it into actionable business insights with confidence scores.

Create visual trend chart

Generates a PNG chart showing sales forecasts and trends for easy visualization of future performance.

Attached Files

workflow.json