Skip to main content
Best answer

Clickfunnels to google sheet zap - Paid amount not in decimals?

  • May 17, 2020
  • 4 replies
  • 1115 views

Hi All, 

Anyone figured out how to make paid amounts shop up with decimals, so I dont have to go into the clickfunnel orders to double check the amount with decimals? 


See attached how orders paid amounts are currently are zapped accross.

Best answer by AndrewJDavison

@Nwoahene 

Click the + button between the two existing steps you have in the zap.

Then you’ll want to search for the “Formatter” app and set it to “Numbers->Format Number”

You then have two dropdowns where you can set up the decimals how you need them:

 

 

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

4 replies

Liz_Roberts
Forum|alt.badge.img+8
  • Zapier Staff
  • May 19, 2020

Hi @Nwoahene ,

Thanks for reaching out- happy to help!

You could use a Formatter step to add a decimal to these amounts. Here’s a quick video with more information!

Let us know if you have any additional questions!


  • Author
  • Beginner
  • May 20, 2020

Hi Team, 

 

Can you help please: 

 

https://www.loom.com/share/1d89208050ae4642aa8a545d82863244


  • Author
  • Beginner
  • May 21, 2020

@Liz_Roberts  See below loom vid of what I am trying to do. 

 

https://www.loom.com/share/1d89208050ae4642aa8a545d82863244


AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • Answer
  • May 22, 2020

@Nwoahene 

Click the + button between the two existing steps you have in the zap.

Then you’ll want to search for the “Formatter” app and set it to “Numbers->Format Number”

You then have two dropdowns where you can set up the decimals how you need them: