Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

i run tiktok lead generation and leads (phone number and email) automatically imported to google sheet, unlike facebook lead ads, the phone number from tiktok lead generation always with hyphen, dash and bracket, so i use formatter by zapier try to clearn phone number before zapier send to google sheet. 

the example phone number is: +1 xxx-xxx-xxxx

I tried text to replace with h^0-9+], it failed.

i tried number to format phone number under transform to use E164 format, failed.

i tried to format in google sheet, still, failed.

does anyone have same issue? and how to fix it? it drives me crazy, below are the screenshot, thank you very much.

 

 

 

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

BTW: in the goolge sheet, the phone number column also showed error, check below

 

 

Hi there @Goldenshiny,

Welcome to the Community! 🎉

It looks like Google Sheets is showing that error because of the "+" symbol in the phone number. I think the "+" is causing Google Sheets to treat that value as a formula. And then because the formula can't be calculated, Google Sheets is showing the #ERROR!.

You should be able to fix this by adding an apostrophe character (') before the phone number value, as this will force Google to treat the value as text: https://support.google.com/docs/thread/4057005/is-it-possible-for-a-plus-sign-to-show-as-plain-text-and-not-create-a-formula?hl=en

Here’s a screenshot:

bd5504212a5ec262b039b34316db28c5.png
(view larger)

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Reply


Terms & Conditions