Automation library · Research and reporting

Business AI command center: Modular agents

Started by an incoming WhatsApp message, and works across Gmail, Google Drive, Google Sheets, Slack and three others. It puts Claude, OpenAI and one other behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 58 steps, 2 branches: large, and worth reading before you trust it with anything live.

LargeCalls a model: Claude, OpenAIRetrieval

58 stepsLarge: read it before trusting it with anything live
2Branches: places the flow splits
0Loops or waits
7Services it connects to

The flow

Starts it 8Model 25Logic 6Service 19

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

  1. 1Google Sheets - Read DataGoogle Sheets ToolService
  2. 2Google Sheets - Clear DataGoogle Sheets ToolService
  3. 3Google Sheets - Add DataGoogle Sheets ToolService
  4. 4Google Sheets - Create SheetGoogle Sheets ToolService
  5. 5Google Sheets - Update DataGoogle Sheets ToolService
  6. 6Google Sheets - Delete SheetGoogle Sheets ToolService
  7. 7When clicking ‘Execute workflow’Manual triggerStarts it
  8. 8Recursive Character Text Splitter1Text Splitter Recursive Character Text SplitterModel
  9. 9Embeddings OpenAI1Embeddings Open AiModel
  10. 10When Executed by Another WorkflowExecute Workflow triggerStarts it
  11. 11Read File From GDriveTool WorkflowModel
  12. 12Search Files from GdriveGoogle Drive ToolService
  13. 13Postgres Chat Memory1Memory Postgres ChatModel
  14. 14Embeddings OpenAI2Embeddings Open AiModel
  15. 15Reranker Cohere1Reranker CohereModel
  16. 16Anthropic Chat Model1Lm Chat AnthropicModel
  17. 17structured data1Postgres ToolService
  18. 18Think1Tool ThinkModel
  19. 19Message a model in Perplexity1Perplexity ToolService
  20. 20search about any doc in google drive1Mcp Client ToolModel
  21. 21MCP SheetsMcp Client ToolModel
  22. 22Reasoning model (recommended)Lm Chat Open RouterModel
  23. 23CalculatorTool CalculatorModel
  24. 24Postgres Chat MemoryMemory Postgres ChatModel
  25. 25OpenAI Chat Model1Lm Chat Open AiModel
  26. 26HTTP Request1Http Request ToolService
  27. 27Create reportsTool WorkflowModel
  28. 28OpenRouter Chat ModelLm Chat Open RouterModel
  29. 29Slack TriggerSlack triggerStarts it
  30. 30Telegram TriggerTelegram triggerStarts it
  31. 31Gmail TriggerGmail triggerStarts it
  32. 32WhatsApp TriggerWhats App triggerStarts it
  33. 33MCP Server SheetsMcp triggerStarts it
  34. 34Download fileGoogle DriveService
  35. 35Default Data Loader1Document Default Data LoaderModel
  36. 36Add to Supabase Vector DBVector Store SupabaseModel
  37. 37OperationSwitchLogic
  38. 38Google Drive MCP ServerMcp triggerStarts it
  39. 39Knowledge Agent1Agent ToolModel
  40. 40General knowledge1Vector Store SupabaseModel
  41. 41MAIN AGENTAgentModel
  42. 42Linkedin ScraperAgent ToolModel
  43. 43Create structured ReportsAgentModel
  44. 44Set message variableSetLogic
  45. 45Download File1Google DriveService
  46. 46Send a text messageTelegramService
  47. 47Send messageWhats AppService
  48. 48Send a message2SlackService
  49. 49Send a message1GmailService
  50. 50Markdown to HTMLMarkdownLogic
  51. 51FileTypeSwitchLogic
  52. 52Send a messageGmailService
  53. 53Extract from PDFExtract From FileService
  54. 54Extract from CSVExtract From FileService
  55. 55Analyse ImageOpen AiModel
  56. 56Transcribe AudioOpen AiModel
  57. 57Get PDF ResponseSetLogic
  58. 58Get CSV ResponseSetLogic

How it's built

Starts on
An incoming WhatsApp message
Steps
58, with 2 branches
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Drive, Google Sheets, Slack, Supabase vectors, Telegram, WhatsApp
Model
Claude, OpenAI, OpenRouter
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 Gmail, Google Drive, Google Sheets, Slack, Supabase vectors, Telegram and WhatsApp accounts, and a key for Claude and OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an incoming WhatsApp message.

Does it use AI?

Yes. It calls Claude, OpenAI and OpenRouter. 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 58 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 58 steps before you point it at anything that matters.