How to Add New Tasks to Google Sheets

Step 1: Sign up to Pabbly Connect

Begin the procedure to add new tasks to Google Sheets automatically by visiting the Pabbly Connect website. Click the ‘Sign-Up Free‘ button available on the home page. Next, either use your existing Gmail credentials or simply make registration via new sign-up.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After successfully logging in, click the ‘Access Now’ button of the software ‘Connect’ amongst all the Pabbly applications.

Step 3: Workflow for Asana and Google Sheets Integration

(a) Start with a New Workflow

Further, start with creating a workflow for Asana to Google Sheets integration & to do this click the ‘Create Workflow’ button available on the dashboard.

(b) Name the Workflow

A window asking for the workflow name will pop up. Now, name the workflow as per the integration or use-case (for instance: Asana To Google Sheets). Lastly, click on the ‘Create’ button.

Step 4: Setting Trigger for Asana to Google Sheets Integration

At first, you’ll need to set up a trigger on the new Asana task entry and then its respective action using Pabbly Connect.

(a) Select Application you want to integrate

After naming your workflow, a page will open up carrying the trigger window settings.

Pick the ‘Asana’ app from the ‘Choose App’ drop-down choices.

(b) Select Event & Connect with Asana

Select the event as ‘New Task in Project’ & then click on ‘Connect with Asana’.

Step 5: Connecting Asana to Pabbly Connect

(a) Authorize Asana Account

To connect Asana with Pabbly connect, click on the ‘Connect with Asana’ button that appears within the window that slides in from the right.

Also, allow for the permissions required to connect your Asana account with Pabbly Connect.

(b) Select a Project & Send Test Request

After the authorization, select the Asana project that you want to connect with Pabbly Connect. And if you haven’t created the project on Asana yet then first, create a project on Asana and then click on the ‘Refresh’ button.

Once you are done selecting a project, click on the ‘Save & Send Test Request’ button.

Check the response of the connection in the API response.

Step 6: Test the Response in Pabbly Connect Dashboard

As we can see, we are done setting up the trigger for the Asana and Google Sheets integration. So, let’s test the Asana trigger by adding a test task.

(a) Capture Webhook Response

The first thing to do is, click on the ‘Capture Webhook Response’ button available in the Pabbly Connect trigger window.

(b) Add a Test Task

Now, go back to your Asana account and create a test task. To create a task, simply click on the ‘Add task’ button within the selected project. Name it and add details like Assignee, Due Date, Description etc.

Check the response for the test task creation, you won’t find any data directly coming into the response.

Step 7: Get Task Details

To get the detailed data for the Asana task, we can map the task id and then get the detailed data. But, if we directly get the data then at the end of this workflow, we’re still not able to get the data in the sheet. So at first, we must add a delay function to resolve this.

(a) Add Delay

To add a delay, simply click the plus button next to your trigger. Then, choose the app as ‘Delay’ and the delay value as ‘1’. Later, click on ‘Save & Send Test Request’.

(b) Get Task Details

Now, integrate asana again as an action to get the task details. Select the app as ‘Asana’ and the event as ‘Get a Task’. Lastly, click on ‘Connect with Asana’.

(c) Map Task ID & Send Test Request

Map the ‘Task ID’ from the trigger response.

Check the response, you can see all the test values in the response fields.

Step 8: Setting Action for Asana to Google Sheets Integration

Now, as we have gathered all the task data from Asana. We can proceed to use this data to perform our action. After that, the data will be added to Google Sheets automatically.

(a) Create a Google Sheet

To save the task entries in a Google Sheet, create a dedicated Google Sheet with the column heads to enter the task details.

(b) Select Application you want to Integrate

Hit the plus button next to your Asana ‘Get a Task’ action window.

Select the app to integrate here as ‘Google Sheets’ and event as ‘Add New Row’.

(c) Authorize Google Account

Next, click on the ‘Connect with Google Sheets’ button in the window that slides in from the right.

(d) Select Spreadsheet & Map Fields

Once the Google account authorization is completed. Select the spreadsheet and sheet. Also, map the spreadsheet fields with the response values.

To map a field value, click on the mapping button (i.e. button with three vertical lines) next to any particular field. Then, select the response value that you want to map with that field.

(e) Send Test Request

After mapping all the fields, click on the ‘Save & Send Test Request’.

Step 9: Check Response in Google Sheets

Also, you can check the task entries on your connected Google Sheets Account.