Troubleshooting Google Sheets Script Error with Row Limitations

I'm testing the Google Sheet script. It works fine for the first 10 rows then I get this message "Error: TypeError: Cannot read properties of undefined (reading 'content')". Any idea why?

16 comments

Alban
·
·
Hi, unfortunately that's going to be very specific for you to debug - there might be something missing in one of your cells ?
Victoire Dumont
·
·
No nothing missing. I've tried to change the order of the content and again it's the first 10 rows are ok but not the rest. It doesn't seem to be related to the content of the cell but the order. Is there any limitation in the number of rows we can process?
Greyg Sinigaglia de Malibran
·
·
Victoire Dumont are you alone on your Dust workspace ?
Greyg Sinigaglia de Malibran
·
·
If yes (to be confirmed by Alban) but this is just the rate limit: https://docs.dust.tt/reference/rate-limits Because using the App Script in G-Sheet is using Dust API Each cell generated create a “message” / Dust discussion and you are facing the limit of messages /minutes
💡1
Greyg Sinigaglia de Malibran
·
·
100 * number of users in the workspace messages per day
10 * number of users in the workspace messages per minute
👀1
Alban
·
·
If you only have 1 user it might definitely be that yes ! And I'd need to modify that script to pop a better error
Victoire Dumont
·
·
Ok thanks, must be it! I've invited a colleague but she might have not join yet
Victoire Dumont
·
·
does generating a table with like 100 rows with a prompt made within dust would count as 100 or as 1 ?
Alban
·
·
Not sure what you mean by generating a table
Alban
·
·
But if it's the model answering with a table then it's one message
Victoire Dumont
·
·
Yes that was it, thanks !
Victoire Dumont
·
·
Unfortunately this limit makes the google sheet integration unusable. Will this be updated?
Alban
·
·
Hi, what do you mean?
Victoire Dumont
·
·
I was wondering if the rate limit 10 * number of users in the workspace messages per minute with the spreadsheet intergation will change
Alban
·
·
Unfortunately not planned soon at least! To upgrade your rate limit you would need to add users to your workspace
Victoire Dumont
·
·
ok thanks

Troubleshooting Google Sheets Script Error with Row Limitations | Dust Community