Google Sheets and Asana

Google Sheets

Triggers

• New row in a Google SheetRuns when a new row is added to a Google Sheets spreadsheet, with the row's cells by their column headings and the spreadsheet and tab it was added to, for a step that writes back to the row, such as Update cells in row.

Actions

• Add rowAdd a row to the end of a tab.
• Create spreadsheetCreate a new spreadsheet.
• Delete spreadsheetDelete a spreadsheet permanently.
• Overwrite rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update cells in row.
• Update cells in rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from (row.row_number). A column that doesn't exist yet is added to the header row.
• Clear rowEmpty a row's cells without deleting the row.

Asana

Triggers

• New taskRuns for each new task in an Asana project, with its name, description, assignee and due date. Tasks already there when the workflow is turned on don't start it.

Actions

• Get a taskGet the full details of an Asana task by its task ID.
• Find open tasks in a projectList the tasks in an Asana project that are not finished, each with its assignee's name and email, due date and link. Give Due before to get only the overdue ones (today's date finds everything past due), most overdue first. Tasks with no due date are left out then.
• Find my open tasksList your own unfinished Asana tasks across a whole workspace, with each one's due date and link. Give Due before to get only the overdue ones (today's date finds everything past due), most overdue first. Tasks with no due date are left out then.
• Create a taskCreate a new Asana task in a workspace, and optionally in one or more of its projects.
• Update a taskUpdate fields on an existing Asana task, such as its name, description, assignee, due date, or completion status.
• Delete a taskDelete an Asana task by its task ID.