Question

Remove spaces from phone number using Zapier?

  • 9 February 2022
  • 2 replies
  • 797 views

Hello,

We use Linkedin Lead Gen Ads and have an automation set up that deposits each entry into a Google Sheet row.  The Google Sheet is used to collect leads from multiple sources (Facebook, Linkedin, Google Ads) and then there is a further automation that deposits the leads into Microsoft Dynamics CRM.

The problem is that the telephone number field doesn’t export correctly into Google Sheets.

The field reports an #ERROR! - Formula parse error. 

The phone number appears correctly in the Google Sheets input bar above, but not in the cell.

The phone number comes across in the format +61 400 000 000, so clearly the spaces (and possibly the + symbol) are causing the issue.

I’ve tried using ‘trim whitespace’ in Google Sheets but that doesn’t seem to work.

Is there a way to trim the spaces using Zapier before the record hits Google Sheets?

Any advice would be greatly appreciated.

Thank you

C


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

2 replies

Userlevel 7
Badge +14

Hi @Clayton_in_Adelaide 

The leading + is the root cause of the GSheet cell error.

Try using a Formatter > Numbers > Format Phone Number step in the Zap.

Check out this help topic:

 

Thanks Troy!