Hiya,
I’m having trouble with a zap that cannot find a Sheet created in the previous step.
If I hard code the Sheet ID directly from Google Drive it works. If I select a specific sheet it works. I can even select the specific sheet that has been created in the previous step from the list of spreadsheets in my Drive. But if I try to reference it dynamically using the ID from the previous step it errors out with “Zapier had trouble retrieving custom fields from Google Sheets.”
What am I doing wrong?
Cheers
Lucy