Best answer

Error in Google Sheet When Sending Phone Number from Calendly

  • 9 September 2020
  • 4 replies
  • 619 views

Userlevel 4
Badge

Hey, y’all!

I have a Zap set up like so:

  1. Trigger: Invitee Created in Calendly
  2. Then: Create Row in Google Sheet (which sends the client’s info from the Calendly booking to a new row)

One of the Calendly questions is an ability for the user to get text alerts send to their phone for the event, and Calendly automatically places an international calling code in front of the number (ex from the U.S.: +1 800 555-5555).

Problem is, when that field is sent to my Google Sheet, it thinks it’s a formula (since it starts with +). So, it displays “!ERROR” in the field, instead of their phone number.

Anyone know a way I can do a work-around, so that the phone number displays and not an error?

Thank ya!

icon

Best answer by sardamit 9 September 2020, 22:42

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.

4 replies

Userlevel 7
Badge +14

Formatter Replace: https://zapier.com/help/doc/how-use-formatter-functions#using-replace

Userlevel 4
Badge

Ack! I don’t know why, @nicksimard, et. al., but I JUST got notified that these replies happened via an email notification. My sincere apologies—I no longer needed this zap as of a while back and I also hadn’t seen the Formatter tool from Zapier as a step. I’m certain that would have worked. Thanks for your help, everyone!

Userlevel 1
Badge

Use formatter to take the phone number and spit it out in only the number format. 

Userlevel 7
Badge +11

Hi @Brandi!

You should be able to try the suggestions by @Troy Tessalone and @sardamit to get what you need :) If you end up giving those a shot and it works for you, we’d love to hear which way you ended up going!