Looking up more than 10 lines in google sheets

Question

Hi,

I am trying to figure out a workaround about this issue.

I have a table with a column which boolean types of data (TRUE or FALSE).

I would like to lookup for the rows with TRUE value and create rows with their value in another table.

Any suggestions on how I could lookup and create more than 10 rows?

Thanks in advance.

AndrewJDavison_Luhhu · Accepted Answer

Hi @IkgonzalYou can’t do a lookup of more than 10 rows directly, but there is a long-winded workaround to loop all rows:https://www.luhhu.com/blog/video-creating-a-looping-zapier-automation-using-webhooks

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded