Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Google Sheets find rows has a limit of 10 - ideas? Suggestions?

  • October 6, 2022
  • 6 replies
  • 262 views
bubba198
Forum|alt.badge.img+1

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?

 

Best answer by bubba198

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:

 

 

Boyan
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

christina.d
Forum|alt.badge.img+9
  • christina.dZapier Staff
  • Zapier Staff
  • October 6, 2022

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.

https://community.airtable.com/t/how-to-query-multiple-records/24208

Either way, I’m curious to see what the community surfaces for you! 👀

    MohSwellam
    Zapier Orchestrator & Solution Partner
    Forum|alt.badge.img+8
    • MohSwellamZapier Orchestrator & Solution Partner
    • Zapier Orchestrator & Solution Partner
    • October 7, 2022

    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 

    Founder of GeekyAir.com
      bubba198
      Forum|alt.badge.img+1
      • bubba198Tinkerer
      • Author
      • Tinkerer
      • Answer
      • October 7, 2022

      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:

       

       

      Boyan
      MohSwellam
      Zapier Orchestrator & Solution Partner
      Forum|alt.badge.img+8
      • MohSwellamZapier Orchestrator & Solution Partner
      • Zapier Orchestrator & Solution Partner
      • October 7, 2022

      Hi @bubba198 

       

      It is actually available in Zapier, Import CSV files into Zaps 

       

      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 :) 

      Founder of GeekyAir.com
        bubba198
        Forum|alt.badge.img+1
        • bubba198Tinkerer
        • Author
        • Tinkerer
        • October 7, 2022

        @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...

        Boyan
          MohSwellam
          Zapier Orchestrator & Solution Partner
          Forum|alt.badge.img+8
          • MohSwellamZapier Orchestrator & Solution Partner
          • Zapier Orchestrator & Solution Partner
          • October 7, 2022

          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 :) 

          Founder of GeekyAir.com
          Terms & ConditionsAccessibility statement