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:
Apply Tags
Place the task in a specific Project
Create Task Name, Due Date, Asignee, based on data within the spreadsheet.
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.
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.
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 How to Remove Duplicates in Google Sheets in 2023 | 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.
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.
I just saw this forum and would like to ask a question.
Does anyone know if it is possible to create a task on Asana based on Google Sheets, only when a column has a certain value? I have a spreadsheet of tasks, and I only want to transfer to Asana if it is a certain category.
I have a Zapier account, so would love to do it on Zapier.