X
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

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:

  1. Switch the worksheet selection from "Custom" to "Worksheet" then select the Google Sheet you most recently created from the list:
Google Sheets in Zapier
  1. With a worksheet selected, the fields below will reappear so you can map/fill them accordingly.
Google Sheets in Zapier
  1. 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 more help? Check out our video guide

Need an automation expert?
Tell us what you need and we'll get to work.
Hire Us
Filter by Category

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.
Thank you! Please keep an eye on your inbox.
Oops! Something went wrong while submitting the form.