Facebook leads to Google sheet (Mobile no without +91 in sheet)
Status: Closed · Asked by Anishek Kumar on · 0 views
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
Attachments
Hi @Anishek,
You can use 'Text Formatter: Replace Text' to remove the +91 from the phone number.
youtube.com/watch?v=oFvzL6iaDAI
You can use a Date/Time Formatter to change the format of your date.
Thanks a lot, Arshil. Your response and timely support was wonderful. It resolved all my doubts.
Thank you for the update. We are glad we were able to clear up your doubts.