• 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.

Search option in Google Sheets

Akiladevi

Member
Hi Pabbly team,
The pabbly accont connected to this question is [email protected] and the link to the workflow is https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTY1MDYzMjA0MzY1MjZkNTUzMTUxMzIi_pc The name of the workflow is Calendly D(SYM-3) - M1 & L1. In the 8th step, "8. Find Client Number and Language Code", Pabbly has to take the client email from the trigger response and go to our Google sheet and search in which row the email matches and take the data from that particular row. Then further things proceed. But Pabbly says that the data will be searched in the first 100 rows only. How to solve this ?
1720829949312.png
 

ArshilAhmad

Moderator
Staff member
The "Lookup Spreadsheet Rows V2" action steps can currently search 100 rows. I am afraid there is no workaround for this at the moment.
 

Fagun Shah

Well-known member
Hi Pabbly team,
The pabbly accont connected to this question is [email protected] and the link to the workflow is https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTY1MDYzMjA0MzY1MjZkNTUzMTUxMzIi_pc The name of the workflow is Calendly D(SYM-3) - M1 & L1. In the 8th step, "8. Find Client Number and Language Code", Pabbly has to take the client email from the trigger response and go to our Google sheet and search in which row the email matches and take the data from that particular row. Then further things proceed. But Pabbly says that the data will be searched in the first 100 rows only. How to solve this ?View attachment 44771
It means it will return results with Maximum of 100 rows, it doesn't mean that it will only search first 100 rows.

@ArshilAhmad @Nivesh @Supreme please make this help text better.

The response will return maximum of 100 searched results from the Google Sheet.
 
P

Pabblymember11

Guest
We have updated the help text in the Google Sheets: Lookup Spreadsheet Rows V2 action step, you may check that out.
 
Top