In this how-to guide

How to create new Asana tasks from new Google Sheet rows
1. Set the Google Sheets trigger as "Row added"
2. Add the "Create task" in Asana automation
3. Activate your Relay.app playbook
Learn more about integrating with Google Sheets and Asana
Related blog posts
More how-to guides featuring Google Sheets and Asana

Integrationsarrow_forwardAsana Integrationsarrow_forwardAsana + Google Sheets Integrationsarrow_forward

How to create new Asana tasks from new Google Sheet rows

How to create new Asana tasks from new Google Sheet rows

Relay.app is an automation tool that lets you automate actions across Google Sheets, Asana, and many other apps. In this guide, we'll show you how to automatically run the “create task” action in Asana for each row added in Google Sheets using Relay.app.

Try it in Relay.app

Google Sheets > Asana

Trigger

Last triggered

Row added

Create task

1

Set the Google Sheets trigger as "Row added"

Every playbook starts with a trigger. The trigger detects changes in your connected apps and initiates your playbook's actions.

Click "Add trigger" and select "Row added" under Google Sheets automation. Then, select the specific sheet. This will allow your playbook to automatically detect new rows added in Google Sheets and initiate necessary actions.

If this is your first time using a Google Sheets integration in Relay.app, a prompt will guide you through the connection process.

2

Add the "Create task" in Asana automation

Integrate the Asana automation into your playbook to ensure the prompt addition of a new task for each new row added in Google Sheets.

Click the "Add step" button, then locate the "Create task" automation for Asana and input the mandatory and relevant details.

If your Asana account isn't already connected to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to sync with your Asana account.

3

Activate your Relay.app playbook

Activating your playbook is the final step to automate the creation of a new task in Asana. Once turned on, it will respond to a new row added in Google Sheets by creating a new task in Asana without manual intervention.

To enable your playbook, click the toggle button located in the header. It is advisable to perform a test run of your playbook beforehand to ensure all steps work seamlessly together and reminders are being sent correctly.

Learn more about

See all appsarrow_forward

See all blog posts ➔

How to run a mail merge with Google Sheets and Gmail

This tutorial helps you set up a mail merge process using Gmail and Google Sheets, in just a few minutes.

Thijs van As

The best form automation software in 2024

Looking to streamline your workflow and reduce your workload? Form automation software transforms tedious manual processes into streamlined, automatic workflows, saving time and reducing errors

Whitney Hazard

Automation Ideas

10 great Asana automations to simplify task tracking

Unlock the full potential of Asana with Relay.app, seamlessly integrating and automating your project management workflows.

Jacob Bank

Automation Ideas

14 automations to maximise your Google Sheets productivity

An automated Google Sheet can often replace multiple business processes and tools. Here's a guide—and a bunch of examples—to show that sometimes a simple spreadsheet is all you need.

Jacob Bank

Automation Ideas

How to build a custom CRM in Google Sheets

Avoid complex solutions and build your own simple, automated CRM in Google Sheets.

Jacob Bank

More how-to guides featuring Google Sheets and Asana

See all how-to guides ➔

Create a new task in Asana for a new Google Sheet added to a specific folder

Struggling to manage tasks in Asana when new Google Sheets are added to a folder? Our integration automates the task effortlessly. Whenever a new Google Sheets file is added to a folder, Relay.app promptly creates a corresponding task in Asana, ensuring your task management stays organized and effic

Share a Google Sheets spreadsheet for a completed task in Asana

Learn how to set up a Relay.app playbook to automatically share a Google Sheets spreadsheet for every completed task in Asana. By configuring this playbook, you ensure that whenever a task is completed in Asana, the corresponding Google Sheets spreadsheet is automatically shared with specified colla

Copy and update a Google Sheets spreadsheet for a completed task in Asana

Learn how to set up a Relay.app playbook to automatically copy and update a Google Sheets spreadsheet for every completed task in Asana. By configuring this playbook, you ensure that whenever a task is completed in Asana, the corresponding Google Sheets spreadsheet is duplicated and updated with the

Automatically create a new project in Asana for each new row in Google Sheets

With Relay.app's integration between Google Sheets and Asana, you can automatically create new projects in Asana for every newly added row in Google Sheets, ensuring seamless project tracking and management. In this guide, we'll walk you through setting up Relay.app to effortlessly synchronize your

Automatically update a Google Sheets row when a new project is added in Asana

Are you tired of grappling with manual data entry tasks and delays in data synchronization when managing projects with Asana and organizing project data with Google Sheets? It's time to say goodbye to these challenges and embrace a more streamlined and efficient project management and data synchroniz

Automatically add rows in Google Sheets whenever new tasks are added in Asana

Are you tired of grappling with scattered data and manual data entry tasks while managing your team's projects? Well, let me introduce you to Relay.app - an innovative solution that can streamline your workflow and simplify project management. Imagine having a centralized system automatically syncs a

Automatically update a Google Sheets row each time an Asana task is completed

Are you tired of manual data entry tasks and outdated information in your project management system? Imagine having a streamlined system that automatically updates your data every time a task is completed! Picture your team relying on Asana to manage tasks and projects while Google Sheets is your cen

Automatically add rows in Google Sheets whenever new projects are added in Asana

Are you tired of grappling with manual data entry tasks and scattered project information? In the fast-paced world of project management, staying on top of new projects and capturing every detail is crucial for ensuring smooth project execution and generating insightful reports. But, without an effic

Automatically add a new row in Google Sheets for a completed task in Asana

Learn how to set up a Relay.app playbook to automatically add new rows in Google Sheets for every completed task in Asana. By configuring this playbook, you ensure that whenever a task is completed in Asana, a corresponding row is automatically added to your specified Google Sheets spreadsheet. Thi

Automatically update a Google Sheets row whenever a new task is added in Asana

Are you tired of juggling tasks across multiple platforms while keeping your team organized and productive? We hear you! Managing tasks and data can be daunting, especially when you have to switch between Asana and Google Sheets to keep everything up-to-date. The good news is that there's a solution

What will you automate?

Sign up and get started with your first Relay.app workflow today.

Try Relay.app for free

Background image

Background image