ERROR - Tiktok Ads (leads) into Google Sheets

[whoisadrirs]

Pabbly is getting the information correctly, but when it comes to my Google Sheets it shows "error".

As you can see at the top, the telephone "comes fine", because it has numbers and those sttuf but I have no way to change the format of the cell.

Any solutions? Thanks in advance.

 

[Preeti Paryani]

Hello @whoisadrirs

Please provide us with the workflow URL with which you're having this issue so we can better look into the issue.

 

[whoisadrirs]

Here you have: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTY1MDYzNjA0MzM1MjY0NTUzMDUxMzci_pc

@Preeti Paryani

 

[Preeti Paryani]

Hello @whoisadrirs

The workflow appears to be functioning correctly. To investigate further, we would require access to your Google Sheets. Kindly provide us with access so we can analyze and address the issue more effectively. Thank you!

Email address - [email protected]

 

[whoisadrirs]

Done @Preeti Paryani

 

[Preeti Paryani]

Hello @whoisadrirs

The #ERROR occurs because Google Sheets interprets the + as a formula. To fix it:

• Keep the + Sign: Add an apostrophe (') before the number (e.g., ' +34 606 13 47 24).

• Remove the + Sign: Use Pabbly Connect's Number Formatter to format the phone number before adding it to Google Sheets.