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.