awork + Google Sheets

Find and update Google Sheets rows for updated time entries in awork

When this happens
Step 1: Updated Time Entry
Then do this
Step 2: Lookup Spreadsheet Row
Then do this
Step 3: Update Spreadsheet Row

Sometimes you need to make changes to your time entries in awork and these changes need to be reflected in your spreadsheet to keep all external reports up-to-date. Instead of manually copying every change, use this awork-Google Sheets integration to automatically find and update time entries in your Google Sheet.

Note: - This Zapier integration doesn't update time entries that were changed before its activation, only new changes after you've set it up will be reflected in your Google Sheet.

How this awork - Google Sheets integration works

A time entry is updated in awork
Zapier finds a row in your Google Sheet to match your search. If a matching row isn't found, a new one will be created.
Zapier updates your Google Sheet row to reflect the changes made in awork

Apps involved

awork
Google Sheets

Try this template

Supported triggers and actions

What does this mean?

New Task
Triggers when a new task is created. The trigger only fires for tasks with a project assigned, not for private tasks.
Trigger
Instant
New Time Entry
Triggers when a new time entry is created.
Trigger
Instant
Updated Time Entry
Triggers when a time entry is updated.
Trigger
Instant
Create Client
Creates a new client.
Action
Scheduled

Create Project
Creates a new project.
Action
Scheduled
Create Project Task
Creates a new project task.
Action
Scheduled

Search Projects
Finds a project by name
Action
Scheduled

awork
Finds a user by email
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action