• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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

Status
Not open for further replies.

Anishek

Member
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
 

Attachments

  • Screenshot (1065a1.png
    Screenshot (1065a1.png
    222 KB · Views: 70

ArshilAhmad

Moderator
Staff member
Hi @Anishek,

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




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


 
Status
Not open for further replies.
Top