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