Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

Google Sheets - We're having trouble loading 'Trigger Column' data.

  • December 2, 2022
  • 3 replies
  • 101 views
A
Forum|alt.badge.img+1

I cannot create a trigger in Google sheets because google cannot load the column header names. Can I hand-write in a column name instead? Clearly the connection magic is failing, but I know what column I want. This is a google sheet automation that worked until I went to edit the trigger to change the column of trigger. Once I did that it was now unable to see any columns in the sheet. 

It is a Google DRive file. I have tried both (team drive) and not (team drive) variants.

Best answer by Akrause

OK, seems to be fixed and working now. I just had to… turn if off and then back on again! Classic.

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

3 replies

A
Forum|alt.badge.img+1
  • AkrauseBeginner
  • Author
  • Beginner
  • 17 replies
  • December 2, 2022

I tried to manually type in COL$E but it still does not work: 

 

 

A
Forum|alt.badge.img+1
  • AkrauseBeginner
  • Author
  • Beginner
  • 17 replies
  • Answer
  • December 2, 2022

OK, seems to be fixed and working now. I just had to… turn if off and then back on again! Classic.

rachael.silvano
Forum|alt.badge.img+7
  • rachael.silvanoZapier Staff
  • Zapier Staff
  • 386 replies
  • December 5, 2022

Hi there @Akrause - thanks for letting us know the classic tech advice worked this time 😅

 

Please feel free to make a new thread with any other questions you may have and hopefully the connection magic keeps working! 

 

Best,

Rachael

Terms & ConditionsAccessibility statement