Google calendar appointments to Asana

[Hareendra]

Thanks. Could the Google sheet automatically update with Task name and ID? I have another question, I've recently been getting this email with following error. But everything looks good in my flow.

This email is to notify you that for the workflow "Google Calendar bookings to Asana" , a recent task was not executed due to following error -​

Task History ID: IjU3NjUwNTY1MDYzZjA0MzE1MjZiNTUzZDUxMzE1MTYwNTQzMjBmMzgi_pc
Step Name: DateTime Formatter (Pabbly) > Format Date with Time Zone
Connection Name: No Auth Connection
Task Error Detail:

{
"status": "error",
"message": "Required field Date missing. Learn more: https://forum.pabbly.com/threads/how-to-fix-required-field-is-missing-errors-in-pabbly-connect.7488/"
}

 

[ArshilAhmad]

Thanks. Could the Google sheet automatically update with Task name and ID?

Yes, we will add it at the end of this workflow so that when a new task is created in Asana, the Task Name and Task ID are automatically added to the spreadsheet. However, for already existing tasks in Asana, you will need to manually add the Task Name and Task ID to your sheet.

Pabbly

connect.pabbly.com

I have another question, I've recently been getting this email with following error. But everything looks good in my flow.

Since the workflow also gets triggered on event updates, it was triggered in this case as well. However, because the StartTime was not available in the trigger step for the update event, you encountered this error. We have added a Filter as step 2 of your workflow, which will prevent this issue.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[Hareendra]

Ok thank you! I really don't need to add the existing tasks as most of them are already completed. I just need to add the new tasks to the google sheet.

 

[ArshilAhmad]

Got it. You can add a Google Sheets: Add New Row action step as the last step of this workflow and map the Task Name and Task ID from the Asana action step. This will allow the Task Name and Task ID to be added to your sheet whenever a new task is created.

Pabbly

connect.pabbly.com

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[Hareendra]

Thanks. Should I map Data Gid and Data Name (from Asana action step) as Task name and ID? Also how do I add the delete task step to the workflow?

 

[ArshilAhmad]

Thanks. Should I map Data Gid and Data Name (from Asana action step) as Task name and ID?

Please let us know the name of the spreadsheet you created where Task Name and Task ID are present as headers. We will set up the Google Sheets: Add New Row action step on your behalf.

Pabbly

connect.pabbly.com

Also how do I add the delete task step to the workflow?

You would need to create a separate workflow with Google Calendar: Event Cancelled as the trigger step. This workflow will trigger when an event is cancelled in Google Calendar, then look up the task name in your sheet to retrieve the Task ID, and finally pass that ID to Asana to delete the task.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[Hareendra]

Thanks. The google spreadsheet name is Asana Tasks. But now non of the appointments pops up in Asana. It used to work fine. In workflow history it says success.

 

[Preeti Paryani]

Hi @Hareendra,

Thanks for reaching out.

Upon checking your workflow, we noticed that the trigger was saved in Advanced response format, which captures the data in JSON format. However, the fields used in your Filter and subsequent action steps were mapped from the Simple response, due to which the required keys were not getting mapped correctly. As a result, the workflow was not executing as expected, even though the task history was showing success.
To fix this, we have:

• Switched the trigger Response Format to Simple
• Saved the trigger again
• Re-executed a previously failed task history (which had failed at the filter step)

After this change, the workflow executed successfully.

Going forward, we recommend monitoring the new task executions to ensure everything is working as expected. For the entries that were already executed earlier and failed at the filter step, you may notice them as 2-step workflows. We recommend re-executing the entire workflow for those task histories so they can process correctly.

Please let us know if you face any further issues.

 

[Hareendra]

Thanks, it seems to be working now but it makes duplicate tasks in Asana. For an example, when I book an appointment, it creates 2 tasks and when I cancel that appointment, it create 2 different tasks.
Also, is there a way to convert the time format to mm/dd/yyyy because here in the US we use that format mostly.

 

[ArshilAhmad]

Thanks, it seems to be working now but it makes duplicate tasks in Asana. For an example, when I book an appointment, it creates 2 tasks and when I cancel that appointment, it create 2 different tasks.

Could you please share the Task History IDs where the workflow was triggered twice for appointment creation and then again triggered twice for appointment cancellation?

Also, is there a way to convert the time format to mm/dd/yyyy because here in the US we use that format mostly.

You can use the Date/Time Formatter to convert it. We have made the necessary changes in your Date/Time Formatter to convert the date into your desired format.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[Hareendra]

Ah I didn't see that format. Thanks! I think it's this one but I already canceled the appointment and deleted it from Asana.
Task History ID -

IjU3NjUwNTY0MDYzNjA0MzA1MjY0NTUzZDUxMzY1MTY2NTQzODBmMzUi_pc​

 

[ArshilAhmad]

Ah I didn't see that format. Thanks!

Glad we were able to help.

I think it's this one but I already canceled the appointment and deleted it from Asana.
Task History ID -

IjU3NjUwNTY0MDYzNjA0MzA1MjY0NTUzZDUxMzY1MTY2NTQzODBmMzUi_pc​

Please create a new appointment in Google Calendar and then share the two task history IDs associated with it, so we can test the issue on our end. Please avoid deleting the duplicate task for this appointment while we are testing the issue.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[Hareendra]

Now it created only one. Weird!
Edit: It created 2 new tasks when I canceled the appointment.

Appointment made
Task History ID -

IjU3NjUwNTY0MDYzNjA0MzE1MjY5NTUzNDUxM2I1MTZhNTQzOTBmMzYi_pc​

Appointment canceled
Task History ID -

IjU3NjUwNTY0MDYzNjA0MzE1MjY5NTUzNTUxMzE1MTZhNTQzOTBmMzMi_pc​

Task History ID -

IjU3NjUwNTY0MDYzNjA0MzE1MjY5NTUzNTUxMzE1MTZhNTQzOTBmMzQi_pc​

 

[ArshilAhmad]

Now it created only one. Weird!
Edit: It created 2 new tasks when I canceled the appointment.

Appointment made
Task History ID -

IjU3NjUwNTY0MDYzNjA0MzE1MjY5NTUzNDUxM2I1MTZhNTQzOTBmMzYi_pc​

Appointment canceled
Task History ID -

IjU3NjUwNTY0MDYzNjA0MzE1MjY5NTUzNTUxMzE1MTZhNTQzOTBmMzMi_pc​

Task History ID -

IjU3NjUwNTY0MDYzNjA0MzE1MjY5NTUzNTUxMzE1MTZhNTQzOTBmMzQi_pc​

Thank you for the confirmation. We have added another filter condition to your workflow, which will prevent duplicate task creation in Asana for canceled events.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[Hareendra]

Thank you! Also would the Asana task get deleted now when the appointment is canceled?

 

[ArshilAhmad]

You would need to create a separate workflow with Google Calendar: Event Cancelled as the trigger step. This workflow will trigger when an event is cancelled in Google Calendar, then look up the task name in your sheet to retrieve the Task ID, and finally pass that ID to Asana to delete the task.

View attachment 64667

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

No, you would need to create a separate workflow that allows you to delete the task in Asana when an event is canceled in Google Calendar.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[Hareendra]

Thanks. I'll let you know how it goes.

 

[ArshilAhmad]

Sure, do let us know how it goes.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support