Database concern
Hi everyone. I'm a new typebot user and I'm having fun with it so far. I'm amazed with what it can do as well.
I have a question as I cannot seem to find it here. Can I make use of the typebot and have it retrieve data from google spreadsheet or any free database?
My goal is to do the following:
1. User enters his/her details (name, occupation, etc.)
2. If the user uses the chatbot again, the details he/she previously entered will be saved. Maybe in google sheets or a database. (Not just on the same session).
Now, the chatbot will ask the user if he/she has tried the typebot before. If he/she says yes, the typebot will try and search for his/her data so that the chatbot knows who he/she is talking to. This way, the user doesn't need to enter his/her details repetitively every time.
So, I can create a block, and if I can verify that the user exists in my data, I can immediately "jump" to a different block.
Thank you for your help!
I also have an additional question. I was trying to link the google sheets but it shows that typebot may access all my google sheets information. Does that mean it can access other data even if it's not linked to typebot?
2 Replies
Someone will reply to you shortly. In the meantime, this might help:
-# This post was marked as solved by Anthony. View answer.
Hello R,
To answer your question: yes it is definitely possible to proceed CRUD (Create, Read, Update, Delete) operations on a Google Sheets file, a NocoDB database (which is free), or any other database of your choice.
To perform a Google Sheets authentication, here's a step-by-step tutorial + flow screenshot of how I implemented it for an email/name authentication:
https://discord.com/channels/1155799591220953138/1334380304332361729/1334468978399117312
Let me know if you have questions on how it works!
Regarding your last question, allowing Typebot to "access" Google Sheets only allows it to show you the file selection window within Typebot where you can pick which Google Sheet file you want to perform actions on. It is by no means used to do any other actions on your behalf, other than the Google Sheets blocks executed on your bot
