Skip to main content
Question

How to fix time zone issues in a Zap between Facebook and Google Sheets?

  • February 6, 2025
  • 1 reply
  • 15 views

Forum|alt.badge.img

I have a zap which takes data from facebook lead form and sends to google sheets.

the time is in UTC and I am in IST time zone.

now, zapier is sending this data to google sheet which is parsing this time in IST which is causing a serious issue for us.

It was not an issue in the google sheet legacy zap.. but we are facing it only in the New Google sheet zap.
time zone in my facebook account is IST.
time zone in my zapier account as well as the zap is in IST.

 

how to handle this issue..?

There is a formatter option.. can I try it? Will it count as an extra task?
right now I am running about 20,000 tasks per month.. If I add formatter in each zap, will it become 40,000 tasks..?

what other option do I have..?

Did this topic help you find an answer to your question?

1 reply

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6301 replies
  • February 7, 2025

Hi there ​@aajneeti,

You can use Formatter by Zapier to format the timezone. Since January 2024 the use of Formatter, Filter, and Paths doesn’t use tasks. You can learn more about that here: https://help.zapier.com/hc/en-us/articles/22923011763853-We-re-making-some-big-improvements-to-Zapier-plans#h_01HKAW4B8NZNDF30V6F08KE8KY

Hopefully, this helps.