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.
Want more automation resources sent to your inbox? Join our newsletter.
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.
Need the help of an automation expert? Contact us now.
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.
Want to get our business automation newsletter?
You'll get a welcome series plus a twice monthly round up of automations tips, updates and resources for Zapier, Integromat and n8n.
Thank you! Please keep an eye on your inbox.
Oops! Something went wrong while submitting the form.
