Share feedback, ideas and get community help

Updated 3 weeks ago

google sheet

Help with integrating Google sheets - linked as per the video, made sheet public - dont know what else I have done wrong or need to do to fix. No place to see errors, feedback says that chatbot is creating a row successfully but information not pulling through.
B
N
M
18 comments
Could you maybe record a video to show the issue? Or provide a clear reproduction
Results tab is not working now too
Chat now can also not annitiate.
Hi there, the entire chat is no longer working?
@Mario Barretta any idea?
In order to properly work, your spreadsheet must have its first row as a header row. And all header name should be unique.
Hi @Baptiste Sorry for the delay but I'm not very well .

@Nadia can you share the bot and sheet so to can verify inside it?

Your video has not a good resolution so i 've not seen well all the structure but i've seen that you use title very long for first row so i'd suggest to try to reduce them (just an idea)
Hi there, apologies for the late reply - Africatech has been keeping me busy. Sheet does have all this - you can see the sheet here https://docs.google.com/spreadsheets/d/1Vfjybnjnf-6HnMw44UzWL-e0UHUkXeEugOV52ZgYjFE/edit?usp=sharing
Hi,
Sorry but i asked you the shared bot so to can investigate in your flow and test it inside (with the public link i can not do nothing except to insert data without to see and control nothing)

Thought.. giving a look to your sheet i think that you have chosen a not correct way to titulate the columns.

Please try to temove the question mark (?) from "Do you have an RA?" and "Has Budget?" and restart your flow
The share bot is called Wealth IQ, what do you need and where can I find what you need to share it with you where you will have full access?
https://docs.typebot.io/editor/share#share

in the meantime have you tried to change the title's columns?
Excel updates
Excel has been updated
I see that you have not connected a spreadsheet (firs screenshot) but it can be because is a copy
I suggest to better develop your bot because the flow is really disordered and is very hard to analyze and understand the correct flow.
I've tried to give a new order (all in an horizontal flow) how you in third screenshot (bettter way for me) and i also suggets to give a nem to the block to can better identify them (actually the numbers are so anonymous and no good ot can take one in a next step)
i see that there is a big confusion and also some blocks with same id how you see in the fourth screenshot
I also see that variables has stiil the ?
on you sheet block some fileds have bnot the variable (look for example emplyement status) or {{Saving RA?}} that has the variable but not the column etc etc
I see also that your sheet blok is not set to be activated for ever flow so to can test it and verify if work are neeeded specific actions (this is not a good solution being that i think that you evere need datas for your google sheet and not only in a specific case)
I'd can continue to analyze and show you a lot of others points but, seeing that i've seen, I'm fairly sure that problem is on your flow that's too disordered so i suggest you to reorganize it so to can be sure about identification and testing it and correct correspondence variables and sheet.
You have some work to do but i'm sure that google sheet block work properly and problem is on the order of your bot that you need to reorganize and better verify
Attachments
image.png
image.png
image.png
image.png
Have you found the problem?
Add a reply
Sign up and join the conversation on Discord