Facebook leads to Google sheet (Mobile no without +91 in sheet)

[Anishek]

Your Task History ID

IjU3NmQwNTZlMDYzMDA0M2M1MjZiNTUzYzUxMzA1MTY1NTQzMCI_3D_pc

Hi, Pabbly support,
I can send Facebook leads ad data to Google sheet properly, but now my clients want two alterations:
1) Mobile number data in sheet without +91 country code, as he wants to use a CRM for auto-dialing. Do you know how I can do it?
2) Facebook leads submission date and time field - How can the date and time format be changed to Indian format?
Please reply asap and suggest some support doc files and video links as well.
Regards Anishek

 

[ArshilAhmad]

Hi @Anishek,

You can use 'Text Formatter: Replace Text' to remove the +91 from the phone number.

You can use a Date/Time Formatter to change the format of your date.

 

[Anishek]

Thanks a lot, Arshil. Your response and timely support was wonderful. It resolved all my doubts.

 

[ArshilAhmad]

Thank you for the update. We are glad we were able to clear up your doubts.