Google Form Responses to Trello automation sets due date time incorrectly

[Angelica Alzona]

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 · Accepted solution]

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.