Build your first automation in under 5 minutes. Sign up for free.
NodestNodest

Connect awork with Google Sheets

Build automations that connect awork with Google Sheets. When something happens in awork, Nodest passes the data along and runs the actions you set up in Google Sheets or the other way around — no coding required.

Get started for freeBrowse templates

Automations

Popular awork and Google Sheets workflows

Pick a ready-made workflow that connects awork with Google Sheets, customise it to fit your needs, and go live in minutes.

aworkGoogle Sheets

Create rows in Google Sheets for new companies in awork

When “Company created” fires in awork, Nodest will create a row in Google Sheets.

Try it
aworkGoogle Sheets

Update rows in Google Sheets for project status changes in awork

When “Project status changed” fires in awork, Nodest will update matching rows in Google Sheets.

Try it
aworkGoogle Sheets

Create rows in Google Sheets for new projects in awork

When “Project created” fires in awork, Nodest will create a row in Google Sheets.

Try it
aworkGoogle Sheets

Update rows in Google Sheets for task status changes in awork

When “Task status changed” fires in awork, Nodest will update matching rows in Google Sheets.

Try it
aworkGoogle Sheets

Create rows in Google Sheets for new tasks in awork

When “Task created” fires in awork, Nodest will create a row in Google Sheets.

Try it
aworkGoogle Sheets

Update rows in Google Sheets for deleted time entries in awork

When “Time entry deleted” fires in awork, Nodest will update matching rows in Google Sheets.

Try it
aworkGoogle Sheets

Update rows in Google Sheets for time entry updates in awork

When “Time entry updated” fires in awork, Nodest will update matching rows in Google Sheets.

Try it
aworkGoogle Sheets

Create rows in Google Sheets for new time entries in awork

When “Time entry created” fires in awork, Nodest will create a row in Google Sheets.

Try it

Triggers and actions

Available triggers and actions for awork and Google Sheets

Combine the triggers and actions of awork and Google Sheets to build your automation. Triggers start the automation, and actions are the steps that follow.

Task comment addedTrigger

Task comment added

Fires when someone comments on a task in awork.

Time entry deletedTrigger

Time entry deleted

Fires when a time entry is deleted in awork.

Time entry updatedTrigger

Time entry updated

Fires when a time entry is updated in awork.

Time entry createdTrigger

Time entry created

Fires when a time entry is logged in awork.

Company updatedTrigger

Company updated

Fires when a company is updated in awork.

Company createdTrigger

Company created

Fires when a company is created in awork.

Task deletedTrigger

Task deleted

Fires when a task is deleted in awork.

Task status changedTrigger

Task status changed

Fires when a task's status changes in awork.

Task updatedTrigger

Task updated

Fires when a task is updated in an awork project.

Task createdTrigger

Task created

Fires when a task is created in an awork project.

Project deletedTrigger

Project deleted

Fires when a project is deleted in awork.

Project status changedTrigger

Project status changed

Fires when a project's status changes in awork.

Project updatedTrigger

Project updated

Fires when a project is updated in awork.

Project createdTrigger

Project created

Fires when a project is created in awork.

Delete a projectAction

Delete a project

Delete a project from awork.

Add a member to a projectAction

Add a member to a project

Add a member to an awork project.

Remove tags from a projectAction

Remove tags from a project

Remove tags from an awork project.

Find project templatesAction

Find project templates

List project templates in your awork workspace.

Find usersAction

Find users

List users in your awork workspace.

Retrieve a userAction

Retrieve a user

Retrieve a user from your awork workspace by ID.

Find user tagsAction

Find user tags

List user tags in your awork workspace.

Find companiesAction

Find companies

List companies in your awork workspace.

Retrieve a companyAction

Retrieve a company

Retrieve an awork company by ID.

Find project typesAction

Find project types

List project types in your awork workspace.

Retrieve a project typeAction

Retrieve a project type

Retrieve an awork project type by ID.

Find teamsAction

Find teams

List teams in your awork workspace.

Retrieve a teamAction

Retrieve a team

Retrieve an awork team by ID.

Delete a milestoneAction

Delete a milestone

Delete a milestone from an awork project.

Retrieve a project templateAction

Retrieve a project template

Retrieve an awork project template by ID.

Retrieve a type of workAction

Retrieve a type of work

Retrieve an awork type of work by ID.

Find project rolesAction

Find project roles

List project roles in your awork workspace.

Retrieve a project roleAction

Retrieve a project role

Retrieve an awork project role by ID.

Find project tagsAction

Find project tags

List project tags in your awork workspace.

Find task tagsAction

Find task tags

List task tags in your awork workspace.

Find company tagsAction

Find company tags

List company tags in your awork workspace.

Retrieve a task statusAction

Retrieve a task status

Retrieve an awork task status by ID.

Retrieve a projectAction

Retrieve a project

Retrieve an awork project by ID.

Find project statusesAction

Find project statuses

List statuses of an awork project.

Retrieve a project statusAction

Retrieve a project status

Retrieve an awork project status by ID.

Find task statusesAction

Find task statuses

List task statuses of an awork project.

Find task listsAction

Find task lists

List task lists of an awork project.

Retrieve a task listAction

Retrieve a task list

Retrieve an awork task list by ID.

Find milestonesAction

Find milestones

List milestones of an awork project.

Retrieve a milestoneAction

Retrieve a milestone

Retrieve an awork milestone by ID.

Retrieve a project commentAction

Retrieve a project comment

Retrieve a comment on an awork project.

Find time entriesAction

Find time entries

List time entries in your awork workspace.

Retrieve a time entryAction

Retrieve a time entry

Retrieve an awork time entry by ID.

Find project commentsAction

Find project comments

List comments on an awork project.

Retrieve a company contact infoAction

Retrieve a company contact info

Retrieve contact info of an awork company.

Find task commentsAction

Find task comments

List comments on an awork task.

Retrieve a task commentAction

Retrieve a task comment

Retrieve a comment on an awork task.

Move a task to another projectAction

Move a task to another project

Move an awork task to another project.

Find types of workAction

Find types of work

List types of work in your awork workspace.

Delete a companyAction

Delete a company

Delete a company from awork.

Update a private taskAction

Update a private task

Update a private task in awork.

Delete a private taskAction

Delete a private task

Delete a private task from awork.

Invite a userAction

Invite a user

Invite a user to your awork workspace.

Add tags to a taskAction

Add tags to a task

Add tags to an awork task.

Update a task commentAction

Update a task comment

Update a comment on an awork task.

Delete a task commentAction

Delete a task comment

Delete a comment on an awork task.

Update a checklist itemAction

Update a checklist item

Update a checklist item of an awork task.

Delete a checklist itemAction

Delete a checklist item

Delete a checklist item from an awork task.

Create a task listAction

Create a task list

Create a task list in an awork project.

Update a task listAction

Update a task list

Rename a task list in an awork project.

Delete a task listAction

Delete a task list

Delete a task list from an awork project.

Create a companyAction

Create a company

Create a company in awork.

Update a companyAction

Update a company

Update a company in awork.

Update company contact infoAction

Update company contact info

Update contact info of an awork company.

Add tags to a companyAction

Add tags to a company

Add tags to an awork company.

Remove tags from a companyAction

Remove tags from a company

Remove tags from an awork company.

Update a time entryAction

Update a time entry

Update a time entry in awork.

Delete a time entryAction

Delete a time entry

Delete a time entry from awork.

Remove tags from a userAction

Remove tags from a user

Remove tags from an awork user.

Stop a timerAction

Stop a timer

Stop the running timer of an awork user.

Find rolesAction

Find roles

List workspace roles in awork.

Retrieve a roleAction

Retrieve a role

Retrieve an awork workspace role by ID.

Add tags to a userAction

Add tags to a user

Add tags to an awork user.

Create an absenceAction

Create an absence

Create an absence in awork.

Update an absenceAction

Update an absence

Update an absence in awork.

Delete an absenceAction

Delete an absence

Delete an absence from awork.

Create a teamAction

Create a team

Create a team in awork.

Update a teamAction

Update a team

Rename a team in awork.

Delete a teamAction

Delete a team

Delete a team from awork.

Update a type of workAction

Update a type of work

Update a type of work in awork.

Delete a type of workAction

Delete a type of work

Delete a type of work from awork.

Assign users to a taskAction

Assign users to a task

Assign users to an awork task.

Add contact info to a companyAction

Add contact info to a company

Add contact info to an awork company.

Create a milestoneAction

Create a milestone

Create a milestone in an awork project.

Change a project's statusAction

Change a project's status

Change the status of an awork project.

Create a time entryAction

Create a time entry

Log a time entry in awork.

Start a timerAction

Start a timer

Start a timer for an awork user.

Create a type of workAction

Create a type of work

Create a type of work in awork.

Find checklist itemsAction

Find checklist items

List checklist items of an awork task.

Retrieve a checklist itemAction

Retrieve a checklist item

Retrieve a checklist item of an awork task.

Find company contact infoAction

Find company contact info

List contact info of an awork company.

Find project membersAction

Find project members

List members of an awork project.

Find absencesAction

Find absences

List absences in your awork workspace.

Retrieve an absenceAction

Retrieve an absence

Retrieve an awork absence by ID.

Update a projectAction

Update a project

Update a project in awork.

Change a project's typeAction

Change a project's type

Change the type of an awork project.

Find projectsAction

Find projects

List projects in your awork workspace.

Find workflowsAction

Find workflows

List workflows in your awork workspace.

Retrieve a workflowAction

Retrieve a workflow

Retrieve an awork workflow by ID.

Find workflow project statusesAction

Find workflow project statuses

List project statuses of an awork workflow.

Retrieve a workflow project statusAction

Retrieve a workflow project status

Retrieve a project status of an awork workflow.

Create a projectAction

Create a project

Create a project in awork.

Update a project memberAction

Update a project member

Update a member of an awork project.

Remove a member from a projectAction

Remove a member from a project

Remove a member from an awork project.

Add tags to a projectAction

Add tags to a project

Add tags to an awork project.

Add a comment to a projectAction

Add a comment to a project

Add a comment to an awork project.

Update a project commentAction

Update a project comment

Update a comment on an awork project.

Delete a project commentAction

Delete a project comment

Delete a comment on an awork project.

Update a milestoneAction

Update a milestone

Update a milestone in an awork project.

Find tasksAction

Find tasks

List tasks of an awork project.

Retrieve a taskAction

Retrieve a task

Retrieve an awork task by ID.

Create a taskAction

Create a task

Create a task in an awork project.

Create a private taskAction

Create a private task

Create a private task in awork.

Delete company contact infoAction

Delete company contact info

Delete contact info of an awork company.

Find private tasksAction

Find private tasks

List private tasks of an awork user.

Retrieve a private taskAction

Retrieve a private task

Retrieve a private task of an awork user.

Update a taskAction

Update a task

Update a task in awork.

Change a task's statusAction

Change a task's status

Change the status of an awork task.

Delete a taskAction

Delete a task

Delete a task from awork.

Remove tags from a taskAction

Remove tags from a task

Remove tags from an awork task.

Add a comment to a taskAction

Add a comment to a task

Add a comment to an awork task.

Add a checklist item to a taskAction

Add a checklist item to a task

Add a checklist item to an awork task.

Find spreadsheetsAction

Find spreadsheets

List spreadsheets shared with Nodest.

Find rowsAction

Find rows

List rows in a sheet with column names.

Retrieve a rowAction

Retrieve a row

Get one row from a sheet by number.

Update a rowAction

Update a row

Change the values in an existing row.

Create a spreadsheetAction

Create a spreadsheet

Create a spreadsheet in your Drive.

Update matching rowsAction

Update matching rows

Update every row matching a value.

Find columnsAction

Find columns

List the column headers in a sheet.

Retrieve a spreadsheetAction

Retrieve a spreadsheet

Get a spreadsheet's details and tabs.

Find sheetsAction

Find sheets

List the tabs in a spreadsheet.

Create a rowAction

Create a row

Add a row to the bottom of a sheet.

Clear a rowAction

Clear a row

Clear the values in a row.

Delete a rowAction

Delete a row

Remove a row from a sheet.

Add a sheet to a spreadsheetAction

Add a sheet to a spreadsheet

Add a tab to a spreadsheet.

Delete a sheetAction

Delete a sheet

Remove a tab from a spreadsheet.

Copy a sheet to a spreadsheetAction

Copy a sheet to a spreadsheet

Copy a tab into another spreadsheet.

Retrieve a cellAction

Retrieve a cell

Get the value of one cell.

Lookup a rowAction

Lookup a row

Find a row by a value in one column.

How it works

Connect awork with Google Sheets in three steps

Create automations that move data between awork and Google Sheets. Nodest handles the work in between, so you can focus on what matters.

Connect awork and Google Sheets

Link your awork and Google Sheets accounts to Nodest in a few clicks, so both tools are ready to use in automations.

Pick a trigger

Choose the event that starts your automation, such as a new order, form submission, or updated record in awork or Google Sheets.

Chain actions and go live

Add one or more actions, and combine them with filters, branches, and delays to create a workflow that fits your needs.

Automation tips and tricks for WordPress professionals

Learn how to take control of your time with automation tips and productivity insights - weekly to your inbox.

Illustration showing how Nodest connects WordPress to the tools you already use every day