Flow is creating multiple copies of one google calendar event in asana and on the wrong date

I have a flow that creates an Asana task for events in my Google calendar, but it doesn’t always put them on the right date, and it creates multile copies of the same event.

A friend who has the exact same setup also has the same problem so we tested. Initially it created one copy of the test event, but on the wrong day (she is two hours ahead of me, but the event she set up aws this evening - it shows on the correct date in her Asana, but in mine it shows tomorrow.)

Then when I asked her to modify the event it created three new copies of the same event, also all on tomorrow’s date.

My flow is super simple, and when I test it only one copy of the event I use to test gets created, but in real life use, it doesn’t seem to work correctly.
Does anyone have any suggestions?

Hi @nikkiyoung323,

It seems like a timezone conversion issue. To confirm, could you please go to the “Runs” section and open one of the runs?

Click on the Asana step. You should find the due_on field in the input on the left side. This field usually contains a date and time, formatted like this: 2024-12-12T12:30:00-04:00.

This means that, in UTC timezone, it would be 16:30.

Could you please let us know what value is in the due_on field and the time you see on Asana?

The test event we used is in my google calendar at 5:30-6:30 MST on Dec 12, 2024.

In the run information of the Asana step, is just shows “2024-12-13” - the wrong date with no time.

Can you try using the “Ask AI” feature in the Piece Selector and ask the AI the following:
“Convert 2024-12-12T12:30:00-04:00 to UTC format.”

image

Click on “Use the code,” then:

  1. Change this to Google Calendar:
    image
  2. Use the output of the code in your Asana step:
    image

Let me know if that works.

Thanks for this.

I’m not sure what you mean in step 1 after clicking on use code though.

You say change this to Google Calendar, but I’m not sure what I’m supposed to change to that?

I tried changing the first row in the code to Google Calendar, as it looks like that might be highlighted in your screenshot, then I hit the test button, but it threw an error.

I think I must be missing something.

Thanks

Nikki

Hi, I just wanted to check in as I didn’t receive an answer to my last post. I’m hoping you can clarify what I’m supposed to be changing…

Thanks so much!
Nikki

1 Like

Hi there @nikkiyoung323.

Could you check this flow template and tell us if it works ?

https://cloud.activepieces.com/templates/fA2SB6s9B0uu7aZWfQBjV

It should work fine, regardless of timezones, since the date Google Calendar gives is in UTC.

Let us know if you have any further questions.