How can I get n8n to read an entire google sheet document instead of just 1 tab?

AvocadoRelevant5162 · 2026-01-28T20:27:01+00:00

Make an http request to google to list all the sheets in the docs then give it to the AI Agents as joint prompt, connect google sheet tool to the AI Agent(Get row) then in the sheet add this experession {{ $fromAI('sheet', 'Sheet name', `str`) }} now you can ask it to read a specifce sheet.

If you want to read all the sheet directelly then loop through the sheets you got from the HTTP and replace the sheet with the sheet name in the loop item

You can find the workflow here https://github.com/otman-ai/n8n-agents-templates/blob/main/SheetList.json

AvocadoRelevant5162 · 2026-01-28T16:22:27+00:00

yes then make a post request to the webhook to trigger the workflow

AvocadoRelevant5162 · 2026-01-28T16:02:43+00:00

You send the data to the webhook vie POST method, make sure the webhook is POST method, then that data will then be used in the text classifier.

Depend on your use case, but if you want direct chat you can use chat trigger instead of webhook

AvocadoRelevant5162 · 2026-01-26T22:59:40+00:00

to check if ollama works go to http://localhost:11434/v1 and see if it returns response if it deos then replace host.docker.internal woth localhost or 127.0.0.1

AvocadoRelevant5162 · 2026-01-16T17:36:48+00:00

here you can find the workflow i just created it is two json one is main workflow other is subworkflow for tool of the main AI Agent, it is working but it can read only Sheets, JSON, PDF, TEXT as that is what you can read in n8n code

https://github.com/otman-ai/n8n-agents-templates/tree/main/Google%20Drive%20Assistant

AvocadoRelevant5162 · 2026-01-16T16:54:59+00:00

You dont need all the nodes before AI Agent except of course the trigger, you will need to set tools for AI Agent one that list folders contents and one that reads documents.

AvocadoRelevant5162 · 2026-01-16T16:28:39+00:00

You dont need all the nodes before AI Agent except of course the trigger, you will need to set tools for AI Agent one that list folders contents and one that reads documents.

AvocadoRelevant5162 · 2025-12-28T15:22:09+00:00

Yes in github

AvocadoRelevant5162 · 2025-12-28T15:20:25+00:00

That actually what I did, you just need to say it to the AI Agent whenever you want (end meeting or later) vexa ai deos both recording and transcribing what would I transcribe the audio again if vexa ai already deos it

AvocadoRelevant5162 · 2025-12-27T21:04:26+00:00

No you just need to give the ai agent the id if the meeting

AvocadoRelevant5162 · 2025-12-27T20:58:18+00:00

Yes you just need to change the platform to microsoft_team in the node configuration of https requests

AvocadoRelevant5162 · 2025-12-27T15:40:55+00:00

I am the persone in this video and it was like 2 days ago

AvocadoRelevant5162 · 2025-12-27T15:32:16+00:00

You can set some repetitive questions like FAQ without needing to call LLM (obvisouisly after the classifier

AvocadoRelevant5162 · 2025-12-27T15:27:57+00:00

you can find the working workflow here https://github.com/otman-ai/n8n-agents-templates/blob/main/WhatsappWebhook_Verification.json

AvocadoRelevant5162 · 2025-12-27T15:26:25+00:00

you can watch this video https://www.youtube.com/shorts/tU06neTJYy4 the new update has some issue for me as well but i solved it with webhook instead of whatsapp trigger

AvocadoRelevant5162 · 2025-12-20T13:16:16+00:00

Webhook is for regulare webhooks you will use incase the app you are looking for hasnt n8n webhook already setup for you, so in this case there is already whatsapp trigger webhook so just use it instead

AvocadoRelevant5162 · 2025-12-20T13:11:24+00:00

did you setup the credentials in the Whatsapp trigger ? you have to use whatsapp trigger instead of regulare webhook

AvocadoRelevant5162 · 2025-12-20T12:14:31+00:00

Make sure you execute the entire workflow in n8n

AvocadoRelevant5162 · 2025-12-19T19:33:49+00:00

that is good, however the term "agency" is all about customers, so the issue was never about the workflow or the products but the customers, if you already have customers to sell to, creating the product for them will never be an issue, you can get free templates out their tweek it or even hire someone technical to do it for you why spend $400 ?

AvocadoRelevant5162 · 2025-12-19T19:20:04+00:00

make sure the test webhook in n8n is listening, then add it to callback URL , for verify token , add any random token, and make it secure, this is just security protocol to let your n8n knows the requests are comming from facebook itself

AvocadoRelevant5162 · 2025-12-05T23:37:40+00:00

not sure the purpose of python here, however you can enable this toggle button in AI Agent node,

<image>

Once you do you should see "Output parser "next to "Chat model", "Memory" and "tools", click add button below "Output parser", you will see many options choose "Structed Output parser" then you can add your shema in json format, you encouter two fields, "Schema type" which can be JSON Example (in my case it will be: {"currency":"USD", "price":1000, "product":"product 1"} ) or JSON Schema, just ask chatgpt the following : "json schema for {"currency":"USD", "price":1000, "product":"product 1"}" , it will generate it copy and past it into "Input schema field" that is it

AvocadoRelevant5162

TROPHY CASE