Mixed-up lead dates from Facebook Instant Forms to Google Sheet
Status: Closed · Asked by attemptdigital on · 0 views
Hi Pabbly team. We have created an automation that gets leads from (All) Facebook Instant Forms to (one) Google sheet. Everything seems to be working OK BUT the dates on which the entries appear are mixed-up. Please let me elaborate:
This is an image from the google sheet. The entries are CONSECUTIVE, namely as people fill-out various instant forms that belong to different campaigns (the 3d column is the name if the Instant form or its number) the automation inserts them in the sheet (supposedly) in a timely fashion. BUT as you can see the dates on which the people filled-out the form are all mixed up. So for example entry 294 is a person that filled up a form on the 30th of July 2024 but the NEXT entry in the sheet (entry 295) is a person that filled the form almost 14 days ago!!! - on the 14th of July!! Also the entry date is correct!! Which means that the date on which the entry 295 appeared is 30th of July (which is logical since the previous entry refers to a FB FORM ENTRY of the 30th/7) but this is NOT the date that the respective person filled-out the form (14/July/2024). It is like FB FORM entries are appearing from the past. Today is 2nd of August and an entry might appear that filled-out the form 15 days earlier!!
I hope I have made the case clear. Have you ever encountered something like this before? Looking forward to your comments and solution
Kind Regards
Hey @attemptdigital
Could you please share the URL of the workflow you attempted, so we can investigate it further?
Please let me now if it is OK and/or if you need anything else from me
There is an ongoing missing leads concern from the Facebook Leads end, for which they have resend few data from their end- https://www.facebook.com/photo/?fbi...m.1631205754325707&idorvanity=193632914749672
So it will happen from the Meta's end and will end on its own once they stop it.
You are AMAZING!!! Thank you for solving this. If you have any updates from Facebook regarding this please post them here. Thank you again!