So you're looking for help with automation? Leave us your details below and we'll get back to you shortly to discuss.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
How to map dynamically created Google Sheets in Zapier
February 12, 2021
If you've ever tried to map a dynamic Google Sheet ID in Zapier and got an error, this is how to fix it.
Due to a quirk in the Google Sheets API, Zapier will make it seem like no Google Sheet columns can be found.
To fix this, you need to:
Switch the worksheet selection from "Custom" to "Worksheet" then select the Google Sheet you most recently created from the list:
With a worksheet selected, the fields below will reappear so you can map/fill them accordingly.
Once done, simple set the Worksheet field back to "Custom". Zapier will warn you about missign fields - but this can be safely ignored. When you switch the zap on and it runs live, all the fields will be correctly mapped.