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?
Best answer by L-RVView original
Never mind! The answer came up as a “related question” just after I hit send!
Here it is: Create a Google Sheets Worksheet AND Create Spreadsheet Row(s)