Typebot
Log in

Share feedback, ideas and get community help

Updated 5 months ago

The insert row GSheet always overwrites previous row

At a glance

The post discusses an issue where inserting a new row in Google Sheets overwrites the previous row. Community members have reported similar issues with Typebot, where multiple submissions are not being stored correctly. A community member has proposed a solution by creating a variable resultId and storing it as the first column in the Google Sheet, which could potentially be added to the Typebot documentation. The community members are trying to reproduce the bug and provide more information to help resolve the issue.

Useful resources
ttgdn.
·
The insert new row of Google Sheets overwrites previous row
t
B
10 comments
ttgdn.
Not only that, but results within Typebbot are also overwritten, making it impossible to store multiple results
ttgdn.
I submitted the Typebot 3 times, but only 1 submission in "Results"
ttgdn.
Solved it by creating a variable resultId and storing it as the "ID" in the GSheet as the first column.

This could probably be part of the Docs @Baptiste ?

https://docs.typebot.io/editor/blocks/integrations/google-sheets
ttgdn.
I opened a PR https://github.com/baptisteArno/typebot.io/pull/1413/commits/a0e3d76940c04b98fa8eddb4ed6f8a6e781c50b5
BBaptiste
mmmh
BBaptiste
that should not happen
BBaptiste
Can you provide a reproduction of the bug?
BBaptiste
Insert should insert a row at the bottom
ttgdn.
I left the first column blank, and every row inserted overwrote the previous one.
Could it be the implementation looking for a unique first column before inserting ?
BBaptiste
Nope that’s not how it works, it just adds a row.

Let us know if you have a reproduction example or a video recording of the bug 🙏
Add a reply
Sign up and join the conversation on Discord