Automation library · Chat assistants

Create a context-aware Slack assistant with Google Sheets

Started by an event in a connected app, and works across Google Sheets, Pinecone and Slack. It puts Azure OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 19 steps: a working afternoon to understand properly.

MediumCalls a model: Azure OpenAIRetrieval

Download free
19 stepsMedium: a working afternoon
0Branches: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 1Model 15Logic 1Service 2

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

  1. 1Slack TriggerSlack triggerStarts it
  2. 2Azure OpenAI Chat Model1Lm Chat Azure Open AiModel
  3. 3Embeddings Azure OpenAI2Embeddings Azure Open AiModel
  4. 4Get row(s) in sheet in Google SheetsGoogle Sheets ToolService
  5. 5Embeddings Azure OpenAI3Embeddings Azure Open AiModel
  6. 6Reranker Cohere1Reranker CohereModel
  7. 7Structured Output Parser1Output Parser StructuredModel
  8. 8Embeddings Azure OpenAI5Embeddings Azure Open AiModel
  9. 9Reranker Cohere3Reranker CohereModel
  10. 10Azure OpenAI Chat Model3Lm Chat Azure Open AiModel
  11. 11Structured Output Parser2Output Parser StructuredModel
  12. 12Get a user's profileSlackService
  13. 13AI Agent1AgentModel
  14. 14Pinecone Vector Store2Vector Store PineconeModel
  15. 15Pinecone Vector Store3Vector Store PineconeModel
  16. 16Pinecone Vector Store5Vector Store PineconeModel
  17. 17AI Agent3AgentModel
  18. 18Auto-fixing Output ParserOutput Parser AutofixingModel
  19. 19Edit Fields1SetLogic

How it's built

Starts on
An event in a connected app
Steps
19
Size
Medium: a working afternoon
Connects to
Google Sheets, Pinecone, Slack
Model
Azure 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 Slack accounts, and a key for Azure OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an event in a connected app.

Does it use AI?

Yes. It calls Azure 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?

Plan an afternoon. 19 steps is enough that you should read each one before running it.

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 19 steps before you point it at anything that matters.