• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Dynamic Sheet Name Mapping in Google Sheets Action Causes Error

Your Task History ID
IjU3NjUwNTY5MDYzNjA0MzE1MjZlNTUzNDUxMzc1MTYxNTQzNTBmMzIi_pc
Hi Pabbly Team,

I'm facing an issue with dynamically selecting a tab in the Google Sheets module.

Use Case:
I have multiple tabs (Tab 1, Tab 2, etc.). A lookup in a master tab returns the tab name/number where the full data exists. I want to use this value dynamically in the next action (e.g., Lookup/Update Row).


Problem:
When I manually select a sheet name, it works. But when I map it dynamically from a previous step, Pabbly passes the Sheet ID or a wrong value—causing a 400/internal error. The mapped value doesn't match the actual tab name.


Question:
How can I dynamically set the "Sheet Name" field using a mapped tab name or number? Is there a way to make sure Pabbly sends the correct visible tab name?


Thanks for the support!
 
Last edited:

Preeti Paryani

Moderator
Staff member
Pro Member
Hello @Aditya Gaikwad,

Thank you for sharing the details.

Upon checking your workflow, we noticed that you are mapping the sheet name in the Lookup action. Please note that when using dynamic mapping for the sheet selection, Pabbly requires the Sheet ID, not the visible sheet name.

To resolve this:
  • In your master sheet, along with the other details (like the tab name/number), also store the Sheet ID of the respective tab.
  • You can then dynamically map the Sheet ID in the action step instead of the tab name.
1745927272317.png


This approach ensures the correct sheet is selected dynamically and should prevent the 400/internal error you're encountering.
 
Top