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

Question

Manually mapping fields from Google Sheets

  • 13 January 2021
  • 3 replies
  • 562 views
P

Hi there,

I took over a Zapier account from my predecessor when I started at a new company a couple of months ago, and the only Zap that he set up is now failing, as the Google Sheets columns don’t all map to the correct places.

Currently, many of the variables used within the Description field that used to pull through correctly from respective cells in the Google sheet now show as “no data” (please see screenshot attached)

Is there any way I can manually map the data to the correct variables, so that they will populate the Trello card?

Apologies if I’ve missed anything off — please give me a nudge if that is the case

Thanks in advance,
Paul

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

P

 

Troy Tessalone
Userlevel 7
Badge +14

You’ll need to pull a new sample record from the GSheets trigger step to use to map the data points to this action step.

 

Check these help articles about Zap basics...

https://zapier.com/help/create/basics/set-up-your-zap-trigger

https://zapier.com/help/create/basics/set-up-your-zap-action

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
andywingrave
Userlevel 7
Badge +9

Hey there @Paulo_dev - Hope you were able to get this solved. As Troy suggested, if you click “Test Trigger” you’ll get sample data that populate the data, which should then help steer you towards knowing if your mapping works, but I would also consider ensuring that you are logging into the correct account - If your employee left, they may have inadvertently severed the link between Zapier and Google sheets - So a re-authentication might be in order. 

 

Let us know how you got on, or if there’s anything else you need help with. 

Terms & Conditions