Google Sheets find rows has a limit of 10 - ideas? Suggestions?
Hi everyone,
As the subject says I need to loop through more than 10 rows; any ideas? The source could be anything, doesn’t ave to be Google Sheets. I just need some feedback on what’s the best work around here? The size of this data isn’t terrible - 300 or so rows of simple CSV compliant line items, with few columns, That’s it, Airtable “Find or Create Record(s) (With Line Item Support)” also has a limit of 10?
Thank you! Boyan
PS. I am ready to accept that Google Sheets is a lost cause as all triggers are limited to 10 or 20 so what would you suggest?
Page 1 / 1
Hey there, @bubba198! Thanks for reaching out!
Hmm, I think you’re right, Google Sheets may be a lost cause here. I’ve heard a lot of great things about Airtable so I while I don’t have an exact solution readily available I imagine you’ll have better luck on that platform.
My hunch is to get around the 10 row limit we’ll likely be working within their API but I could be wrong. I did find this thread in the Airtable community though unsure how relatable it is to your specific use case.
Either way, I’m curious to see what the community surfaces for you!
To second what @christina.d , I would definitely use Airtable with webhooks in Zapier to perform that.
I have used Airtable extensively and the FETCH function gives me 1000s of records without a problem
Thank you both. I’m a huge Zapier fan so this is a sad they when I could solve this in just few minutes but using another competitive platform. The ability to just paste the raw static CSV into a step (module, etc) is something that I didn’t expect to find at make.com and Zapier should totally consider it as a feature in a future release:
You could email the file to a gmail account or maybe even use Email by Zapier, which will then return 1000 records :)
The reason I personally didn't recommend that in the first place is because this has some manual work (which is actually downloading the CSV file from your source, instead of having the data already somewhere and fetching through all the available data which can be updated at anytime).
Hope this helps :)
@MohSwellam Ah the Formatter by Zapier utility - great suggestion; I’ve actually used the formatter, just never dug into it within the CSV context. Thank you! I will give this a try just to prove a point and you’re right - my use case is non-conforming as I simply want to paste bunch of static text rather than harvest this automatically from the source...
Please try it and let me know (if you dont mind), I haven't used it myself but Id be very curious to know how it turned out, might come in handy someday :)
