Get Rows related

[zest83]

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

 

[Pabblymember11]

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.

 

[zest83]

Is there a limit to how many rows can be fetched?

 

[Pabblymember11]

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

 

[zest83]

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

 

[Pabblymember11]

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]

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?

 

[Pabblymember11]

If I wanted to lookup 150 rows?

Currently, our support for the 'Lookup Spreadsheet Rows' response is limited to a maximum of 100 rows.

 

[zest83]

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?

 

[Pabbly13]

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-

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,

 

[zest83]

thanks
will try