Facebook leads to google sheet date problem
Status: Closed · Asked by mayurgami on · 0 views
Hey
I am facing an issue with the dates; they are not in real-time.
The five leads I received today (1 December 2023) are showing yesterday's date and an incorrect time.
However, in Slack, they appear with the correct date and time.
Workflow is Facebook to slack and google sheet.
Hey @mayurgami !
Facebook Leads provides response in UTC time, which is why you are seeing the difference in the response.
You can follow this thread to add the local time for the received data- https://forum.pabbly.com/threads/date-time-functions-to-fetch-current-date-and-time-in-different-formats.1492/
Hope, this works for you.
Hey @mayurgami !Facebook Leads provides response in UTC time, which is why you are seeing the difference in the response.
You can follow this thread to add the local time for the received data- https://forum.pabbly.com/threads/date-time-functions-to-fetch-current-date-and-time-in-different-formats.1492/
Hope, this works for you.
Thank you for helping, this works!