Google Sheet integration breaks if GS gets further than...

UUlrich

I need to send more than 30 answers / information from Typebot to GS, and when i created the new row AA (after Z), the sheet disapeared from my list. So i cannot add new answers past Z, and all previous connexions got disconneted and i cannot add this sheet again: it disapeard from the list of available sheets.
Is this a Google limitation or something you can adjust on your side ?
When i remove the additionnal row after Z, the sheet becomes available again

Update: after removing rows after Z, i cannot edit the google sheet integration anymore, see https://www.dropbox.com/scl/fi/vg71lslmin2wk1n68iw0x/Typebot-savonette.mov?rlkey=6tbyw39oi3di58wzqzadsxt93&dl=0

Thanks @Baptiste for your help !

Attachment

18 comments

BBaptiste

You are trying to edit a bot in the Results page, you shouldn't be able to. Make sure to navigate to the "Flow" tab first

BBaptiste

I'm confused though because you shouldn't even be able to open the Google Sheets settings in the Analytics graph

UUlrich

Ah yes, my bad, so that explain this closing of the setting. So this is soved. But what about the limitation beyond Z ? Is there a way to add more rows without disconnecting the sheet from the integration ?

BBaptiste

I'll try to reproduce now

BBaptiste

Managed to reproduce. Checking how I can fix it.

BBaptiste

Actually that was because I had 2 columns with the same header.

BBaptiste

Are you sure it's not the same issue case with your spreadsheet?

BBaptiste

Can you provide a copy of your spreadsheet so that I try to reproduce?

UUlrich

Thank you Baptiste ! Here is the link to the GS https://docs.google.com/spreadsheets/d/1TSARtp5FO6vYRpnIjy4GRCLHiJ64jJ-n7VNuo0P0dhQ/edit?usp=sharing

UUlrich

Just for you to know: i use https://frontly.ai/ to create a teacher portal, with the data gathered through GS

UUlrich

So there are 2 apps that are interacting with that GS

UUlrich

On inputing (Typebot) the other reading, but with relation to other related sheets in that GS file

BBaptiste

So I duplicated the spreadsheet to my Google Drive

BBaptiste

I've added a column (AA) to the "Ingest Typebot" sheet, I named it "test"

BBaptiste

And it works!

BBaptiste

Your sheet named "Ingest Typebot redux" though is not displayed because you have 2 columns with the same name "Slogan Polyvia"

UUlrich

Thanks Baptiste. I reworked through all the mechanics, and what appeared is the somehow there is a memory for a column name in GS, because even if a name that was existing is not there anymore (deleted column or erased name), if you retype it exactly, it breaks everything. The only workaround (simple) is to use another name for a new column. But you have to know that... So it's a little trick to know when using GS: never use the same column name, even if the column with that name is not there anymore...

MMario Barretta

true.
Happened also to me.
Happen also for variables that, for some reason, remain in memory so we need ever to create new filed's name.

Add a reply

Share feedback, ideas and get community help

Google Sheet integration breaks if GS gets further than Z row