tiktok ads and google sheets

[Boris Vilela]

Hello,

I have a problem with one step in automation. When the platform gets the data from TikTok and sends It to google sheets appears one mistake in the phone number. Is there a way I can change the format so it can be shown correctly? I believe, the problem is because of the "+" and the spaces between the numbers.

 

[Pabblymember11]

Hey @Boris Vilela

Kindly share the name of the workflow once in which you have tried passing the cell data. So that we can look into it and can guide you accordingly.

 

[Boris Vilela]

Hello,

This is the information you required.

 

[Boris Vilela]

Also, in the same workflow, I want to collect the information for a specific question which I will indicate below. What I am asking there is "When are you available for a call?" and the leads answer a specific time. So, I want to get that time and put it in the google sheets but it appears that I´m getting the wrong information because the time shown in the google sheets is incorrect. Please, help

 

[PabblyMember4]

Hey @Boris Vilela

Kindly convert the date in the required format that you are looking for using the Date/Time formatter by Pabbly. Generally, we save dates and time in Google Sheets in UTC format.

Please check the below video for the same:-

Thanks
Kunal

 

[Boris Vilela]

Okay, but what about the first issue with the phone number? How can I solve it?

 

[Pabblymember11]

Okay, but what about the first issue with the phone number? How can I solve it?

Kindly validate the phone number column in your Google Sheets as Plain Text or Number.