About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Is there a limit to how many columns you can map in a Google Doc template?

  • 8 July 2020
  • 5 replies
  • 424 views
L
Userlevel 1
Badge

I have a template document that has a lot of formatting in it so I need to map hundreds of custom fields to get it all set up as the client wants.

 

I am have got as far as column ANP in Google Sheets (and may need to add more in the future) and the Zap step can’t find any column after ALH.

 

Is there a limit set on the number of columns or custom fields you can have in a “Create Document from Template” step?

 

Thanks for your help.

icon

Best answer by Liz_Roberts 20 August 2020, 14:49

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Danvers
Userlevel 7
Badge +12

Hi there!

 

There isn’t a number of Google Sheet columns that a Zap will find, no. I wasn’t 100% sure on how many columns a Zap will be able to show in the Zap editor so I asked the excellent @JasonZapier to do some testing and he was able to get all the way up to at least column ANP.

 

Have you added more columns to the sheet since you first tested the Zap? If so, try retesting the trigger step to see if that finds the new columns. 

L
Userlevel 1
Badge

I have retested the trigger multiple times with multiple different sheets, I have tried mapping the fields using the hardcoded Sheet instead of the one found by the trigger. all with no luck.

At the last test it was unable to find columns that I had previously successfully mapped. This is a real showstopper for my project, please help!

Liz_Roberts
Userlevel 7
Badge +8

Hi @L-RV ,

I am escalating this to Support so that they can look at your configuration to troubleshoot. 

Sit tight and someone will be in touch just as soon as they can!

N

I am having a similar problem. Was there any suggested resolutions to this? 

Liz_Roberts
Userlevel 7
Badge +8

Hi @Natalie!

If you have added any new columns, were you able to try retesting the trigger step to see if that finds them? If so and you are still running into issues our Support team will need to dig into your configuration to help get you squared away! They can be reached here: Zapier Support Team and will be happy to help!

 

Terms & Conditions