TIME PROBLEM

Hello,

I have a problem with a connection, when I connect Facebook Leads to Google sheets, the time it shows in my google sheets is +0000 and in Lima, Perú, we are UTC -05:00. What should I do to get my time zone in the google sheets?

Also, is there a posibility that the time can be show as a "hour""min""second" "day" "month" and "year" (in that order)?

Thanks in advance

1651704632634.png
1651704650968.png
 
P

Pabblymember11

Guest
Hey @Boris Vilela

Since most of the applications process their data in UTC timezone and can use changed with the help of the "Date/Time Formatter by Pabbly: Format Date with Time Zone" action step.

Though the Timezone which you have shown above doesn't change the timezone according to the application process, that will only associate with the internal time of your Pabbly account.

2022-05-05_10h16_19.png
 
Top