N8N Chatbot to pull content from different tables in Supabase

Tech Stack:

Chat widget Embed through N8N

Supabase Database

Outcome needed:

I am wanting to add a chat support features as a member support bot for logged in members to my clients site. We have Docs from Google Docs, and all the other pieces of their wordpress website like courses, events, lessons, etc pulled into a Supabase Database. I have those pieces added to supabase so there is content in there that the agent COULD pull from looking at rows.

Issue and Needs:

Right now I do have when google docs are added to a Google Drive they are being added to the table in Supabase. And the chatbot works when asked about documents that are in the Google Drive and when the chat asks the agent to pull from those other tables it "Looks" like it succeeds (green checks). But the output does not pull from the tables in Supabase at all. I have all these different elements separate so they dont get jumbled or out off wack with management. I spent an hour on the phone with someone this morning that had zero idea on how to fix it and really need to get this fixed ASAP to prove the MVP to my client.

Just noticed: Should I use a Tools Agent or an SQL agent for those queries?

25 comments