• 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 Lead Ads with Date and Time Formatter to Google Sheets

StyxMedia

Member
So I'm currently using pabbly connect with a lead gen ad of mine.
I've done the connection and tested it.

I needed the Date and Time of when the lead is created, so I used the "Created Date" from the "Res3" Option (Which I can't understand what it is and can't find anything about it on Google - Res1, Res2, Res3)

But since the Res3 format is gibberish to the sales rep and client, I used the Date and Time formatter

Using that, I was able to Change it (At least in the test results)

Then when the ACTUAL lead is generated, it comes as some random gibberish number (which I'm assuming is some format of a timestamp or something) which I have to keep formatting again and again in excel... eg. "45225.8638888889"

Then I became advanced and found out that if I change the account settings in Pabbly and use the {{pc_local_human_now}} code then it would give me exactly what I need.

And it made life a lot simpler... However, this too results in: "45225.8638888889"

PLEASE HELP!!

Secondly, on this new subsheet, the leads that are generated are being generated in row 2 instead of the bottom of the sheet... Can't understand why...
Context: The other columns on the rows of the empty cells have dropdown options (with nothing selected)

So when the new row is created at the top (Row 2) its a completely clean new row, how can I avoid this?
 
P

Pabblymember11

Guest
Hey @StyxMedia

Using that, I was able to Change it (At least in the test results)

Then when the ACTUAL lead is generated, it comes as some random gibberish number (which I'm assuming is some format of a timestamp or something) which I have to keep formatting again and again in excel... eg. "45225.8638888889"

Then I became advanced and found out that if I change the account settings in Pabbly and use the {{pc_local_human_now}} code then it would give me exactly what I need.

Could you kindly provide the URL of the workflow in which you attempted to convert the date and time?
Additionally, ensure that you set the format of the date and time as "Text" in your MS Excel sheet.

1698402492747.png

Secondly, on this new subsheet, the leads that are generated are being generated in row 2 instead of the bottom of the sheet... Can't understand why...
Context: The other columns on the rows of the empty cells have dropdown options (with nothing selected)
Could you kindly verify if there is any space between the header row and the data rows and provide a screenshot as well, please? If yes then please remove the extra spaced row and then try again.
 
Top