weekly asana task to google sheets

[nirmehta]

Can it be possible to create a workflow from asana project and all task created in asana is simultaneously automated in google sheets every week. With One workflow. Please share details

 

[Pabblymember11]

Hey @nirmehta

We are currently looking into the possibility of your concerning use case.

 

[Pabblymember11]

Hey @nirmehta

Please check the following workflow as per your use case, please check this out -

Test Workflow -https://connect.pabbly.com/workflow/share/CkJQYlQTCCBVHAJWUz4NJA8aUVIBSwBWVDMGFA##

Here is the Google Sheet where we have tested your use case -
https://docs.google.com/spreadsheets/d/1nbl8tEldyzZOyhrhJkVcCAjzN7M_4KTpPjaALeHCgQ8/edit?usp=sharing

 

[nirmehta]

Dear Supreme, Thank you i have tried and I have a made a workflow could you please check and let me know whether it correctly works. Another can i get status of task whether completed or incompleted. And due date i have add by adding from asana to get a task.
and As next week , do i get the whole list in my google sheets or only one task will appear.

 

[Pabblymember11]

Hey @nirmehta

We looked into your workflow and in the 7th step, you need to first map a sample row to get a response of the Google Sheets "Lookup Value".

Once done with the above step, then map the row index value which will give you the ID which you have to map in the second field of the Filter condition.

Google Sheets -

Workflow Step -

Please check again the above workflow's action step -