Skip to main content
Best answer

How can I convert a phone number from number format to a text format?

  • February 1, 2023
  • 5 replies
  • 237 views

Hello,

 

i use Google contacts with sendinblue.

 

Now i have the problem, that the phonenumer is in sendinblue a TEXT-Field. In my Zap the phonenumber is a number field. So my question is. How can i change the format from number to TEXT-Field in Zapier?

Thank you.

Best answer by nicksimardBest answer by nicksimard

 Hi@vantage!

If you take a look at the API documentation for Sendinblue, you can see that these are the accepted formats for numbers:

 

Taking a look at our Formatter (find this under Formatter — Numbers — Format Phone Number), I’d say one of the following should work for you, but be sure to do some testing, to confirm. So the first option or the second last, as shown below:

251c3e837a4ddfe9755c24bec1f0570e.gif

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @vantage 

Good question.

Are you encountering an error when trying to map variable across your Zap steps?

Have you tried testing the Zap step after mapping the variables?

Please provide detailed screenshots in order for us to have context, thanks.


  • Author
  • Beginner
  • 9 replies
  • February 1, 2023

Hello Troy,

 

i have the Error 400 and yes, and i have tested the step before.

Screenshots i will send you later.

Peter


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • 2115 replies
  • Answer
  • February 1, 2023

 Hi@vantage!

If you take a look at the API documentation for Sendinblue, you can see that these are the accepted formats for numbers:

 

Taking a look at our Formatter (find this under Formatter — Numbers — Format Phone Number), I’d say one of the following should work for you, but be sure to do some testing, to confirm. So the first option or the second last, as shown below:

251c3e837a4ddfe9755c24bec1f0570e.gif


  • Author
  • Beginner
  • 9 replies
  • February 2, 2023

Hi @nicksimard !

 

Thanks a lot. With the formatter it was possible to do the zap! 😀

 


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • February 3, 2023

Ayy! 🎉 Stoked to hear Nick’s recommendation’s did the trick for ya! 

Happy Zapping! 🧡