How to map dynamically created Google Sheets in Zapier

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:

1. Switch the worksheet selection from "Custom" to "Worksheet" then select the Google Sheet you most recently created from the list:

2. With a worksheet selected, the fields below will reappear so you can map/fill them accordingly.

3. 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.

‍