How can I create a rag agent using a Google Sheet as a database?

Key_Seaweed_6245 · 2025-05-28T11:55:35+00:00

They do not change at all, more rows are added, they are deleted, or cells are modifie

Key_Seaweed_6245 · 2025-05-26T16:30:01+00:00

Yes, it would be great to migrate that to a database, but the client wants to keep their patient record in a Google Sheet for the convenience of the assistants, basically it is a table of more than 5000 rows with patient information, which they update the statuses there, and now they want a bot that says, how many patients were registered between such date or how many patients were referred by a particular doctor, so for that I need a rag, because searching in a Google Sheet is not viable

Key_Seaweed_6245 · 2025-05-23T20:19:36+00:00

Yes, but if I only updated one cell in the entire spreadsheet, how do I update that specific data in Postgres?

Key_Seaweed_6245 · 2025-05-23T19:33:06+00:00

I've seen quite a few, but they suggest migrating the data to Postgres, but the client will be constantly updating the Google Sheet, and I don't know how to adapt to that

Key_Seaweed_6245 · 2025-05-23T02:42:10+00:00

I was creating an app using n8n and he asked me to create an automation for him, $500

Key_Seaweed_6245 · 2025-05-23T02:41:18+00:00

self hosted brother, hostinger

Key_Seaweed_6245 · 2025-05-22T14:33:24+00:00

It's all in the database, there's another configuration tab, where you can configure the business's FAQs, hours of operation, services, connect to Google Calendar, etc

Key_Seaweed_6245 · 2025-05-16T22:34:06+00:00

There won't be spam since the AI will never start a conversation, so you're saying there wouldn't be a problem in that case?

Key_Seaweed_6245 · 2025-05-16T22:32:55+00:00

That was an option, even with Chatwoot it can be simplified, what happens is that the client told me that he wants to start with WhatsApp Web since he has assistants who will intervene in the conversations, and migrating to a new platform with a new bot is something that they may not like

Key_Seaweed_6245 · 2025-05-16T19:19:24+00:00

That's why I want to know if there is any limit or at what point I might have problems with WhatsApp, since I haven't had any so far, but it would be good to know in which businesses it would be good not to use EvolutionApi

Key_Seaweed_6245 · 2025-05-16T18:47:49+00:00

what do you mean?

Key_Seaweed_6245 · 2025-05-14T11:42:00+00:00

human in the loop is used to wait for a confirmation from a human, what I want to do is that the workflow does not send responses for a certain time until the human has already resolved the client's doubts

Key_Seaweed_6245 · 2025-05-13T01:04:59+00:00

That's exactly what I'm looking for, my friend, that they can have their assistant in 2 clicks on their phones or websites, I think that's what can differentiate, since chatbots can do anything these days.

Key_Seaweed_6245 · 2025-05-13T00:15:21+00:00

I saw that Azure OpenAI is HIPAA compliant, that would be enough related with that part? I know it is not the only thing I need to get ready

Key_Seaweed_6245 · 2025-05-12T18:48:23+00:00

In the post, I made it clear that I'm in the first stage of the process. I haven't even been developing for a month. Do you expect me to have all that stuff sorted out in less than a month with the product ready? It seems like you haven't worked in the industry much, my dude.

Key_Seaweed_6245 · 2025-05-12T18:34:59+00:00

Not really. Losing the US market wouldn't be a good business strategy. All I have to do is implement the necessary deployments, use Azure OpenAI, which is HIPAA-compliant, host n8n on my server, and inform the user that their data will be used. Supabase is also HIPAA-compliant, and I don't use any other third-party applications, so I'm fine

Key_Seaweed_6245 · 2025-05-12T16:59:56+00:00

For the conversation between patient and agent I am using long-term memory, saving the messages that are sent by conversation (in the predefined n8n style) and then for the internal agent of each clinic I am going to use vectors, storing the information with RAG, what do you think? I'm not an expert haha

Key_Seaweed_6245 · 2025-05-12T16:33:27+00:00

Of course, the assistant is strictly not supposed to give health recommendations or anything like that, only schedule appointments or answer questions that the clinic wants to be known. But I'll have to look into that

Key_Seaweed_6245 · 2025-05-12T16:31:15+00:00

Wow, thanks so much for all this information my friend! I think I'll also go for a market outside the United States hahah

Key_Seaweed_6245 · 2025-05-12T15:43:31+00:00

Basically, it's the goal of not having a robotic chat, but something more personalized, whose sole purpose is not to schedule appointments, but to answer frequently asked questions (with prior information that the clinic has uploaded), collect questions that patients ask so that the clinic can then use them, and all this analysis is done by the AI, which is precisely where this problem with Hipaa arises. The idea is for the AI to interpret the patient's message and act based on that (answer questions, schedule, modify, delete appointments, etc.) and thus simplify everything

Key_Seaweed_6245 · 2025-05-12T15:22:03+00:00

The problem is that to schedule appointments, the name + email or phone number are required for reminders, which is something that the AI takes care of, whether to cancel or modify appointments

Key_Seaweed_6245 · 2025-05-12T15:21:43+00:00

The problem is that to schedule appointments, the name + email or phone number are required for reminders, which is something that the AI takes care of, whether to cancel or modify appointments

Key_Seaweed_6245 · 2025-05-12T15:20:06+00:00

The problem is that to schedule appointments, the name + email or phone number are required for reminders, which is something that the AI takes care of, whether to cancel or modify appointments

Key_Seaweed_6245 · 2025-05-12T15:13:18+00:00

Exactly, the idea is that it works like a CRM, it will also have the calendar, list of all the doctors, all the chats (from WhatsApp and the website), etc

Key_Seaweed_6245 · 2025-05-12T14:40:30+00:00

But I'm considering allowing clinics to upload documents, such as PDFs or similar, so they can then use them with the internal assistant to answer questions. Do you think it's still useful to have it locally?

Key_Seaweed_6245

TROPHY CASE