Support more than 1k rows in Google sheets
S
Sarah Palombo
Hannes: That's correct yes. 'For every method apart from 'Add a Row', the maximum number of rows supported is 1,000.' .....The idea here is to be able to retrieve more than 1000 results when using other methods like list rows, search etc. Thanks for the feedback
J
Jørgen Flo
Hannes: Our sheet file contains 2 sheets/tabs: sheet 1) 4000 rows now, sheet 2) 1300 rows now. We had a break between row 1501 and 1502 for 6 days without data. Then it started working again. We are now moving over to a proper database for better data management.
H
Hannes
Viljami Ketola: I don't think it's a google sheet limitation, since FlowXO highlight the issue here:
"For every method apart from 'Add a Row', the maximum number of rows supported is 1,000. So if you try and use a Flow XO method on a sheet with more than 1,000 rows, you'll instantly get an error: "Your spreadsheet cannot contain more than 1,000 rows"."
So it could potentially work with sheets of size > 1k if one only needed the 'Add a Row' function. But that's not the case for us.
V
Viljami Ketola
Isn't this restrction of Google sheets API's? When you create a new worksheet there's just 1000 rows in there and yiu can add more rows in there manually. And I woule imagine this fixes the problem if you add 'say 1 million rows in there.
I'm not 100% sure but maybe someone from FlowXO team can confirm this?
H
Hannes
Jørgen Flo: Interesting, would love to hear more about this. Would you mind continue this over email? If so, shoot me an email over at hannes.flowxo@gmail.com .
J
Jørgen Flo
Hannes: That is weird, we are on soon 4000 rows. I remember we had a temp stop on around 1000 rows, but it suddenly start to work again (Without any changes).
H
Hannes
Jørgen Flo: That does indeed sound promising. Sarah Palombo, can you maybe shed some light on this? Does FlowXO officially support more than 1k rows in Google sheets?