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.
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, 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
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