• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

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