• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Get Rows related

zest83

Active member
If I do “Get Rows” in google sheets

Do I define the range from Row2
And
Is there a limit to how many rows can be fetched?

My use case is: I wish to MATCH data received WITH data already present in google sheets

If yes, the filter should move ahead for each of the values in the second google sheet

So suppose, vendor A and Vendor B, both match the condition, then both the filters should go ahead
 
P

Pabblymember11

Guest
Hey @zest83

Do I define the range from Row2
Yes, you define the range from row 2nd till the data is present in your Google Sheets.

My use case is: I wish to MATCH data received WITH data already present in google sheets
You can use the Iterator action step with the filter action step to process the workflow with a match.
 
P

Pabblymember11

Guest
There is no limit on fetching the data from the Google Sheets Get Rows action step.
 

zest83

Active member
Are we sure on this!
vLookup has a limitation of 100 rows
So I can get rows with 1000 rows of data?
Coz some use cases, will have a lot of data to crawl to find value
 
P

Pabblymember11

Guest
So I can get rows with 1000 rows of data?
Coz some use cases, will have a lot of data to crawl to find value
Indeed you can fetch that amount of data from the Get Rows action step.
 

zest83

Active member
What if I have to lookup more than 100 rows - in the spreadsheet lookup function
Is there a way to do that?

If I wanted to lookup 150 rows?
 

zest83

Active member
For Get Rows,
Is it important for all the rows to contain data?
What if I'm updating google sheet on a regular basis from a third party source
It would be difficult to define the rows right.. in get row trigger?
So i would ideally choose a bigger range like 100 rows to start with.,. but data might be present in only 2 rows in the beginning

Will this work?
Or some other solution for this?
 
P

Pabbly13

Guest
Hey @zest83 !

Is it important for all the rows to contain data?
No, its not required to have all rows to have data.

What if I'm updating google sheet on a regular basis from a third party source
It would be difficult to define the rows right.. in get row trigger?

No, you can give a range of the data you need to add further-

1703076451722.png


So i would ideally choose a bigger range like 100 rows to start with.,. but data might be present in only 2 rows in the beginning
Will this work?

Sure, this should work for you.

Kindly try it once at your end and let us know about it,
 
Top