Lookup Spreadsheet Rows Limitations

[akgshanmuga]

Hi Pabbly team,

I just came across your post that 'Lookup Spreadsheet Rows' has limitation of fetching details only upto 100 rows.

If my Google sheet has larger rows (say 500 rows) how to resole the issue?

Thanks

 

[Pabblymember11]

Hey @akgshanmuga

As of now, we only support 100 rows in the 'Lookup Spreadsheet Rows' response received.

 

[samir samnani]

@Supreme any changes to the above ?

 

[Pabblymember11]

Hey @samir samnani

The Google Sheets: Lookup action event can only bring 100 rows in the response at a time.

 

[samir samnani]

@Supreme So it is advisable to use `GET' row for all available rows in spreadsheet and use iterator ? right

do this GET has any limitation. ?

 

[Pabblymember11]

Hey @samir samnani

The Get Row(s) action step could get the response up to 100k records.

But if you are trying to process it with Iterator action step, then you can process it 500 records at a time.

 

[samir samnani]

Thanks @Supreme

Just for the sake of information, what will happen for the below mention scenario,

there are 40000 rows in google sheet
the customer wants to check each and every row for an condition and if met then send an whats-app message
the condition may be in more than 6 columns

if the customer pulls rows data with 'GET Rows' and then proceed with Iterator how can he search and successfully complete the rest step.

is there any other option to do so. ?

 

[Pabblymember11]

Hey @samir samnani

You can try fetching the rows in a small chunks by creating separate workflow.