- 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
How to create a new task in Asana for a new Google Sheet added to a specific folder
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.
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.
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.