Google Form Responses to Trello automation sets due date time incorrectly

Question

Hi, I've been trying for days to find a way to have a Google form auto populate a Trello card. To do that I've been using automation.io. Everything works—the title, the description, the day its due—but the time its due is always off in a way I don't understand.

Here's the Google form response:
24-Jan-2022 22:52:00 (10:52pm)

Here's what automate.io is sending to Trello, as given to me by automation.io support:
24-Jan-2022 22:52:00 (10:52pm)

But the Trello card created is:
24-Jan-2022 17:52:00 (5:52 PM)

My Trello board, Google Sheet, Google Form and local computer are all set to EST.

Why is Trello misinterpreting the time? How would I fix this issue?
Gratitude for any help!

Felix_qq95eu · Accepted Answer

Trello's API expects all dates to be passed in UTC.

You'll likely either need to do this conversion in your google form or in automate.io before passing it to Trello.