Automation library · Data collection

Macro tracker with Groq and OpenAI

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

LargeCalls a model: Groq, OpenAIRetrieval

32 stepsLarge: read it before trusting it with anything live
4Branches: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 1Model 6Logic 8Service 17

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

  1. 1Telegram TriggerTelegram triggerStarts it
  2. 2Groq Chat ModelLm Chat GroqModel
  3. 3Get row(s) in sheet in Google SheetsGoogle Sheets ToolService
  4. 4Append row in sheet in Google SheetsGoogle Sheets ToolService
  5. 5SerpAPITool Serp ApiModel
  6. 6Embeddings OpenAIEmbeddings Open AiModel
  7. 7Reranker CohereReranker CohereModel
  8. 8SwitchSwitchLogic
  9. 9AI AgentAgentModel
  10. 10Qdrant Vector StoreVector Store QdrantModel
  11. 11Get_messageSetLogic
  12. 12Get a fileTelegramService
  13. 13Get a file1TelegramService
  14. 14IfIfLogic
  15. 15Rename KeysRename KeysService
  16. 16Extract from FileExtract From FileService
  17. 17Extract from File1Extract From FileService
  18. 18Send a text messageTelegramService
  19. 19Groq Whisper Model1Http RequestService
  20. 20Get_message2SetLogic
  21. 21Convert to Mp3Convert To FileService
  22. 22Groq llama Model2Http RequestService
  23. 23Send an audio fileTelegramService
  24. 24Groq Whisper ModelHttp RequestService
  25. 25Edit FieldsSetLogic
  26. 26Rename Keys1Rename KeysService
  27. 27If2IfLogic
  28. 28HTTP RequestHttp RequestService
  29. 29Send a text message2TelegramService
  30. 30If1IfLogic
  31. 31Edit Fields2SetLogic
  32. 32Send a text message1TelegramService

How it's built

Starts on
An incoming Telegram message
Steps
32, with 4 branches
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets, Qdrant, Telegram
Model
Groq, 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, Qdrant and Telegram accounts, and a key for Groq and 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 Groq and 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 32 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 32 steps before you point it at anything that matters.