Hi,
I have a Config excel where I placed the Worksheet Name of another Google Sheet. So Zapier read the Config excel and dynamically pass the Sheet Name every time. Issue is Zapier is able to read the sheet name correctly but saying could not find the sheet.
Please help to understand where is the issue.
Best answer by Troy Tessalone
Hi
The Worksheet field expects the Worksheet ID.
If you look at the dropdown list of options, the field expects the bottom numerical value for each option.
+1Hello,
Have you changed the google sheet name (at the bottom) at all? Added a space or removed something?
I checked that one. Both are exactly same and no extra spaces. Infact, if I try with different sheet name, it is throwing error for other sheets too.
+1You’ve probably already checked but have you updated the names in the zap as well?
+6Hi
I’m jumping in to see if I can help!
You must select the Worksheet name in the “Worksheet” dropdown field for the Zap to use the Worksheet. Ensure that this Worksheet exists in the account linked to the Google Sheets step.
Additionally, you have the option to input the Worksheet ID as a custom value in the "Worksheet" field.
Hopefully, this helps! 😊
Hi Ken,
I want to send different sheet names every time. So not choosing from the Worksheet drop down.
Instead passing it as a value through Custom. Please find below (Formatted Rows COL A).
Could you please explain more about Worksheet ID. Can we use Worksheet ID when sending sheet names dynamically.
+14Hi
The Worksheet field expects the Worksheet ID.
If you look at the dropdown list of options, the field expects the bottom numerical value for each option.
+14Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
