Back
Asana New task in a project. Coda Create a row.

Append new Coda rows to Google Sheets

Connect

How this automation works

Append new Coda rows to Google Sheets to keep an automatic, searchable log. This Applet runs when a new row is added in a Coda table and adds that row to a specified Google Sheets spreadsheet. It's ideal for backups, reporting, and sharing Coda data with colleagues who use Google Sheets.

If
Asana icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new task in the project you specify.
CreatedAt ProjectName TaskName TaskNotes DueOn Assignee Workspace Tags TaskURL
Then
Coda icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new row in a Coda table.
doc_table column_data

Services used in this Applet

Create your own Coda and Asana workflow

Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.

16 triggers, queries, and actions

New project

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new project added in a workspace.

New task assigned to you in a project

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new task assigned to you in the specified project on Asana.

New task completed in a project

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new completed task in a project.

New task in a project

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new task in the project you specify.

Row created

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a Coda table.

Row updated

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when an existing row is updated in a Coda table.

Tag added to task

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a tag is added to a task in a project.

Get row by ID

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the column values for a specific row in a Coda table.

History of project

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time there was a new project added in a workspace.

History of task assigned to you in a project

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time there was a new task assigned to you in the specified project on Asana.

History of task completed in a project

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time there was a new completed task in a project.

History of task in a project

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time there was a new task in the project you specified.

Create a row

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new row in a Coda table.

Create project

Pro plus icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new project in the specified workspace.

Create task

Pro plus icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new task for the specified project.

Update a row

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will update column values on an existing row in a Coda table.

Create a row

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new row in a Coda table.

Create project

Pro plus icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new project in the specified workspace.

Create task

Pro plus icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new task for the specified project.

Get row by ID

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the column values for a specific row in a Coda table.

History of project

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time there was a new project added in a workspace.

History of task assigned to you in a project

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time there was a new task assigned to you in the specified project on Asana.

History of task completed in a project

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time there was a new completed task in a project.

History of task in a project

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time there was a new task in the project you specified.

New project

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new project added in a workspace.

New task assigned to you in a project

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new task assigned to you in the specified project on Asana.

New task completed in a project

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new completed task in a project.

New task in a project

Pro plus icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time there is a new task in the project you specify.

Build an automation in seconds!

You can add delays, queries, and more actions in the next step!

More on Coda and Asana

About Coda

Coda is an all-in-one workspace combining docs, spreadsheets, and custom apps into a single collaborative surface. Connect Coda to IFTTT to keep your tables in sync with other tools: log incoming data as new rows, react when rows are added or updated, and push updates from anywhere back into Coda.

Explore Coda

More integrations with Coda

About Asana

Asana is the easiest way for teams to track their work. From tasks and projects to conversations and dashboards, Asana enables teams to move work from start to finish — and get great results.

Explore Asana

More integrations with Asana

IFTTT helps all your apps and devices work better together

Get started for free