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.
Is this possible? What are my options?