Google Adwords to Google sheets

[marbellaforsale]

Hi all,

Might be a silly question however having never used a system like Pabbly Connect or any of these things before, I wanted to know if the system would correct transfer the data in a legible format. Currently, exports from Google Adwords CSV have phone numbers of our clients in a scientific format, i.e. 9.89E+11.

Is it possible for the information in the csv to pass through Pabbly Connect and display in our Google Sheet column in the correct number format?
So from 9.89E+11 into a proper telephone number format 0044 123 412 31234

In an attempt to streamline our current process this is an important question we need to know before potentially using Pabbly Connects full package.

 

[Deleted member 15445]

Hey @marbellaforsale

You can surely try out "Format Phone Number" in the Number Formatter module and let us know if it works for you.

Please refer to the tutorial below for the same -

 

[marbellaforsale]

Thank you for your reply and I have watched the video and it is very good. The problem is that we have a CSV import of clients who are from all over the world with different dialing codes. In the example shown in the video it is for a single country. Would I need to number format like this for every different country?

 

[Preeti Paryani]

Hello @marbellaforsale,

This formatting should work for every number, regardless of the country. However, we recommend testing it once on your end to ensure it functions as expected.

If you encounter any issues, please share the workflow URL, and we’ll be happy to assist you further.