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

  • Due to Diwali and Bhai Dooj celebrations, our team will have limited availability. While we’ll continue to monitor threads, responses may be slightly delayed. Normal operations will resume on Friday, 24th October 2025.

Best way to lookup multiple Google Sheets?

fisto

Member
I have a Google Sheet that has several sheets/tabs inside it.

I need to look up data, and depending on which sheet/tab the data is in, the automation continues to do different things.

Right now, I have an automation that works as follows:

Search sheet/tab #1 for the data. If data not found, router searches sheet/tab #3 for the data. If data not found, router searches sheet/tab #3 for the data. etc etc

I keep adding more sheets/tabs, and so this automation is getting longer and longer.

Is there a better way to do this? I would like to search all sheets/tabs inside of a google sheet, and depending on which sheet/tab the data is found it continues the automation in its own specific way.
 
P

Pabblymember11

Guest
Hey @fisto

You can use "Google Sheets: List Sheets" to check for the sheets inside the Spreadsheet.


2022-03-31_11h56_08.png
 

fisto

Member
I don't think that helps my solution. What do I do with the list of sheet names?

I would like to search all sheets in a Google Sheet, instead of having a Yes/No router for each sheet.
 
P

Pabbly13

Guest
Hey @fisto !

You cannot lookup over multiple Google Sheets.

As of now, lookup can be used for individual sheets only.

For reference, you can check on the following video tutorial-


Hope, we have mentioned your query.
 
Top