Google Sheets AI Analyst

Who is this for?

You run reporting for a 4-shop coffee chain answering 6 sheet questions per sub-workflow call, and this Sheets analyst workflow pulls and reasons for you. Each question needs three sheets reopened, filtered, and pasted into Slack.

What problem does this solve?

You reopen three sheets, filter, then paste the answer into Slack. When another workflow calls it as a sub-workflow, the flow pulls the sheet contents, reasons with its agent, and returns a clean answer. You just scan the returned answer instead of rebuilding the pivot.

What this workflow does

1. Get Google sheet contents (Google Sheets)
2. OpenAI Chat Model (OpenAI)
3. AI Agent (AI Agent)

How it works

Another workflow calls it as a sub-workflow → Set Google Sheet URL, Get Google sheet contents, Check operation, ending in Prepare output.

Setup

1. Open danielgrey.shop/app/templates/dg-0025 → Copy JSON → n8n → Import from Clipboard (or Push to n8n)
2. Connect credentials: Google Sheets, OpenAI
3. Run once manually to verify each branch — it imports clean and goes green first try — then a 10-minute review and activate.

Requirements

- n8n 1.50.0 or later
- Credentials for Google Sheets, OpenAI
- Free — import and run.

Customising

- Tune the logic inside Prepare output for the answer format you need.
- Point Set Google Sheet URL at your source and adjust Check operation for your query type.