How can Lookup Spreadsheet Rows V3 if Google sheets have over 300 rows?

Status: Closed · Asked by Ton Won on · 0 views

Ton Won — Question ·
How can Lookup Spreadsheet Rows V3 if have over 300 rows?

I found it has just return 100 search results only. Any solutions for this?

Pls advise!

Thank you!
Pabbly Support — Reply ·

Hello,

Thank you for reaching out!

Regarding your query about the Google Sheets “Lookup Spreadsheet Rows V3” action, please note that the lookup action returns results based on the specified lookup criteria and filter values. We also found that, instead of the number of rows you mentioned (100), only 4 rows were fetched in the last task execution, as reflected in the Task History.

To investigate the issue further and identify the exact root cause, could you please provide us with the following:

  1. Editor access to the Google Sheet connected to this action step.

  2. The direct link to the Google Sheet.

  3. Details of the specific use case or any error encountered, so that we can understand the expected behavior and investigate the issue effectively.

Once we receive these details, our team will review the setup from our end and assist you accordingly.

Thanks & Regards,

Shekh Dilshekh

Customer Support Specialist

🌐 Pabbly.com

👉 Rate your support


Pabbly Support — Reply ·

Hello,

This is a quick follow-up regarding the issue with the Google Sheets “Lookup Spreadsheet Rows V3” action. As mentioned earlier, we found in the Task History that only 4 rows were fetched, instead of the expected 100 rows.

To investigate the issue further, we are awaiting the following details:

  1. Editor access to the connected Google Sheet.

  2. The direct link to the Google Sheet.

  3. Details of your specific use case or any error encountered, if applicable.

Kindly share the requested information so that our team can review the setup, identify the cause of the issue, and assist you with an appropriate resolution.

We look forward to your response.

Thanks & Regards,

Shekh Dilshekh

Customer Support Specialist

🌐 Pabbly.com

🎉Black Friday Early Access
Signature image

Pabbly Support — Reply ·

Hello,

We are following up regarding the issue with the Google Sheets “Lookup Spreadsheet Rows V3” action. As mentioned earlier, the Task History shows that only 4 rows were fetched, whereas you expected approximately 100 rows.

To investigate this further and understand the cause, we are still awaiting the following details:

  1. Editor access to the connected Google Sheet.

  2. Direct link to the Google Sheet.

  3. Details of the expected behavior and your specific use case, along with any error message or unexpected behavior you are encountering, if applicable.

Kindly share the above details so that our team can review the sheet configuration and workflow setup and assist you with the appropriate resolution.

For now, since we haven't received any response from your end, we are closing this ticket. If the issue still persists, you can reach out to us or reply to the same email.

Thanks & Regards,

Shekh Dilshekh

Customer Support Specialist

🌐 Pabbly.com

🎉Black Friday Early Access
Signature image

Back to all forum threads · Log in to reply