tiktok ads and google sheets

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.

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.

Hello,

This is the information you required.

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

Attachments

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:-

youtube.com/watch?v=NVc9Y1ZCBUI

Thanks
Kunal

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

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