In this how-to guide

How to create a new task in Asana for a new Google Sheet added to a specific folder
1. Set the Google Sheets trigger as “Spreadsheet added to folder”
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_forwardGoogle Sheets Integrationsarrow_forwardGoogle Sheets + Asana Integrationsarrow_forward

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

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

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 use Relay.app to automatically run the Asana “Create task” action for each Google Sheets “Spreadsheet added to folder” event.

Try it in Relay.app

Google Sheets > Asana

Trigger

Last triggered

Spreadsheet added to folder

Create task

1

Set the Google Sheets trigger as “Spreadsheet added to folder”

Add the Google Sheets trigger to initiate your playbook's actions when a new spreadsheet is added to a folder.

To do this, click "Add trigger" in your playbook. Select the "Spreadsheet added to folder" trigger option from the dropdown menu under Google Sheets. It will enable your playbook to automatically identify newly added spreadsheets and trigger necessary actions.

If you still need to connect your Google Sheets account to 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 creation of a new task for new Google Sheets spreadsheets added to a folder.

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 spreadsheet is added to a specific folder by creating a new corresponding 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 ➔

Start multiple Playbook runs at once with Batch Triggers

Batch riggers in Relay.app let you start multiple runs at once for the same Playbook. For example, you may use batch triggers to set off mail merge campaigns, or kick off a playbook on a weekly periodic schedule that checks in with the Account Executives for all stale Deals in sales pipeline in HubSpot.

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

10 Ways to Automate Asana

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

Jacob Bank

14 Ways to Automate Google Sheets

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

How to Use Zapier with Google Sheets

Wondering how to connect your Google Sheet with Zapier? You've come to the right place.

Jacob Bank

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 new Asana tasks from new Google Sheet rows

Looking to simplify your task management between Google Sheets and Asana? This integration offers a seamless solution. Whenever a new row is added to your Google Sheets spreadsheet, the Relay.app automatically creates a new task in Asana. It's a straightforward way to ensure that your tasks are promptly organized and managed in Asana, saving you time and keeping your workflow efficient.

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 collaborators or team members. This integration enhances transparency and ensures that relevant stakeholders have access to updated information.

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 latest task details. This integration enhances data organization and ensures that your Google Sheets spreadsheet reflects the most recent task completions from Asana.

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 centralized hub for tracking task progress and organizing data. We know that each completed task in Asana represents a milestone towards project completion, and having a streamlined system for updating task status in Google Sheets is crucial for maintaining workflow efficiency. That's where Relay.app comes in! It's a revolutionary solution designed to streamline your workflow by automatically updating Google Sheets rows each time an Asana task is completed, ensuring that task progress is promptly reflected in your Google Sheets document. With Relay.app, you can have a centralized platform for task tracking and data management, empowering your team to focus on task execution while ensuring that task status and data are synchronized seamlessly for enhanced workflow efficiency. In this guide, we’ll show you how to set up this integration. Get ready to revolutionize your workflow!

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. This integration enhances data tracking and ensures that your Google Sheets spreadsheet remains up-to-date with completed tasks from Asana.

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 that bridges the gap between task management and data organization called Relay.app! With Relay.app, you can streamline your workflow by automating the updating of rows in Google Sheets whenever a new task is added to Asana. No more manual data entry or scattered information across platforms. Relay.app empowers your team to focus on task execution while ensuring that task information is synchronized across platforms for better organizational efficiency. In this guide, we’ll show you how to set up this integration. Let's get started with Relay.app!

What will you automate?

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

Try Relay.app for free

Background image