Monitor Google Maps reviews with Pinecone: n8n workflow

Monitor Google Maps reviews with Pinecone

Started by an incoming Telegram message, and works across Google Sheets, Pinecone and Telegram. It puts OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 30 steps, 4 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAIRetrieval

The flow

Starts it 4Model 10Logic 9Service 7

The steps in the order they run, from what starts it.

1Trigger at midnightSchedule triggerStarts it
2Telegram TriggerTelegram triggerStarts it
3Embeddings OpenAI1Embeddings Open AiModel
4OpenAI Chat ModelLm Chat Open AiModel
5Every Sunday at 11pmSchedule triggerStarts it
6Default Data LoaderDocument Default Data LoaderModel
7Structured Output ParserOutput Parser StructuredModel
8Embeddings OpenAIEmbeddings Open AiModel
9When clicking "Execute"Manual triggerStarts it
10GPT 5 miniLm Chat Open AiModel
11⚠️ CONFIGURATIONSetLogic
12⚠️ CONFIGURATION1SetLogic
13Pinecone Search ToolVector Store PineconeModel
14AI Data AnalystAgentModel
15⚠️ CONFIGURATION2SetLogic
16Pinecone IngestVector Store PineconeModel
17AI Review AnalystAgentModel
18Start Google Maps ScraperHttp RequestService
19Send a text messageTelegramService
20Empty Namespace (Keep DB)Http RequestService
21Wait 2sWaitLogic
22Send AlertTelegramService
23Wait for ScraperWaitLogic
24Confirmation textTelegramService
25Loop Over ItemsSplit In BatchesLogic
26Get Dataset ResultsHttp RequestService
27Aggregate DataAggregateLogic
28Format Data (Reviews)SetLogic
29Log dataGoogle SheetsService
30Wait 5sWaitLogic

How it's built

Starts on: An incoming Telegram message
Steps: 30, 4 loops or waits
Size: Large: read it before trusting it with anything live
Connects to: Google Sheets, Pinecone, Telegram
Model: OpenAI
Retrieval: Answers are drawn from documents you supply, not from the model alone

Questions

What does it need to run?

An n8n account, plus your own Google Sheets, Pinecone and Telegram accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an incoming Telegram message.

Does it use AI?

Yes. It calls OpenAI. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 30 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 30 steps before you point it at anything that matters.