Skip to main content
Best answer

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

  • 1 February 2023
  • 5 replies
  • 189 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.

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
Userlevel 7
Badge +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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
V
Userlevel 2

Hello Troy,

 

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

Screenshots i will send you later.

Peter

nicksimard
Userlevel 7
Badge +11

 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

V
Userlevel 2

Hi @nicksimard !

 

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

 

christina.d
Userlevel 7
Badge +9

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

Happy Zapping! 🧡

Terms & Conditions