Automating the creation of Tasks using Google Sheets?

I’m looking for a way of creating a task in Asana by using information taken directly from a Google Sheets Spreadsheet. This could be by exporting something from Sheets and uploading to Asana, or even better, something even more automated that I basically “trigger” from within the Google Sheets doc to create the Asana task.

The backstory here— I have a Google Sheets document that is an order template that my clients use for ordering product. Currently, for each order, I have to manually create an Asana task for each (complete with Task Name, Asignee, due date, etc). The chances for human error are quite high and potentially costly.

I am especially needing to be able to do the following by creating/importing the task from Google Sheets:

  1. Apply Tags
  2. Place the task in a specific Project
  3. Create Task Name, Due Date, Asignee, based on data within the spreadsheet.
  4. Post in the Description information drawn from several data cells.

Any suggestions? I’d love to get as close to this being automated and triggered from within the Google Sheets document as possible. Such as, the moment the document is shared with me, the task is created in Asana. Or perhaps “as soon as the ‘job-name’ cell contains data”, the task is created in Asana.

Is this possible? What are my options?

Hi @Matt5, welcome to the Asana Community Forum!

This is something you can achieve with Zapier, please find more details in the link below:

I hope this helps!

5 Likes

I forgot about Zapier, thanks!

1 Like

Hi @Matt5, this is definitely possible using 3rd-party tools. If you’d like assistance, please feel free to reach out: https://projectmanagementpros.com/consulting/

I am trying to get this to work and I can get that first “test” zap to work (task created).

However I cannot get the zap to create further tasks when the trigger column is edited, and when I re-run the test (with the trigger column values changed to a different value), the zap works but it uses the previous (old) value rather than the updated value.

In other words----- My trigger is the “Task Name” column in Google Sheets. Column B is the column where “Task Name” will be entered. Every time a “Task Name” is edited, I want the zap to trigger a new task with the updated “Task Name”.

So far I can make the first test-zap work, but editing the “Task Name” does not create a new Asana task. If I re-run the test-zap (even after reloading the document) it still creates a task with the older “task name”, not the updated one.

Hopefully this makes sense to someone and can help me find out why I can’t get the zap to work.

And yes, I definitely have the Zap turned on.

Great points over there, and I’m sure the sheets geeks will get on working on such options sooner or later as demand creates supply. All the points you stressed have logic for sure but for me simpler tasks like removing duplicates was a real struggle most of the time.I used to work for a data processing company that had huge databases full of double entries. Imagine my first days at work. Just deleting useless rows all day lol! At last, I found Guide to Remove Duplicates in Google Sheets | Coupler.io Blog and their article made me understand how easy my life could be all this time.

Hey Matt - I’m having a similar issue. I can get the Zap to work and create a new task when I test it. I turn the Zap on. But, when I try to submit another response in the form, it doesn’t show up in my Asana board.

Hey there, maybe try another service like Integromat? Zapier ease of use is great, but other platforms might be more powerful in certain contexts.

Also this is a great article:

Thanks for the info, @Mmaattee. That article is fantastic!

Hey guys, Michaela from Integromat here :wave:

I see that you’ve already referenced the awesome Asana automation bible by Bastien, that’s great. I was thinking I might as well jump in with a few more helpful links. For more detailed understanding of the Asana integration on Integromat, you can, of course, check out the documentation. Since we’re talking Google Sheets here, let me also share the list of Google Sheets actions and triggers currently available on Integromat.

Have a good day, everyone!