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:
Google Sheets in Zapier
With a worksheet selected, the fields below will reappear so you can map/fill them accordingly.
Google Sheets in Zapier
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.
Twice a month you'll get general automations tips as well as updates and resources on Zapier & Integromat
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Want to do something like this in your business?
We'd love to talk to you about your business and how automation could transform your business. Just tell us what you need and we'll get back to you within a few hours.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.