Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,673
Community Members
 
Community Events
176
Community Groups

google sheet information is not converting in to new card

Edited

I have attached a short Loom video of my screen of the problem I am having.

Short video of issue of google information not getting transferred into card in Trello 

I have set up the zap and selected the info I would like added to the new card but the information I have selected doesn't appear on the card. 

Look forward to your help.

 

Laura

2 answers

0 votes
milynnus Rising Star Jan 18, 2022

@Laura 

You will have to insert the variables using the results from an earlier zap step as illustrated by Michael. 

0 votes

The Loom was super helpful thanks.

You definitely have to click on the Sheet fields to fill them in like this:

Screen Shot 2022-01-18 at 8.02.23 PM.png

But other than that, I'm not sure what's going on.  That worked fine for me from scratch when I set it up.

Added a new row with some different info:

Screen Shot 2022-01-18 at 8.03.26 PM.png

And card showed up correctly

Steve  Test 1.png

When a zap runs, Zapier will show you all the details about the run in the history of the run too.  You have to switch to their history tab to see it.

Thanks still have another question what you said helped but still have and issue Video for next help ? 

milynnus Rising Star Jan 18, 2022

@Laura 

If the data is not there, the placeholder will be empty.

One way you can go about it is to write a simple piece of code to insert between the zap steps to put in some text if the test condition returns an empty string for the set of potentially null fields.

In Zapier, you can use Code by Zapier and choose the python...there are some useful examples.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events