Loading

awork + Google Sheets

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

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.

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.

  1. When this happens...
    aworkawork
    Updated Time Entry

    Triggers when a time entry is updated.

    TriggerInstant
  2. automatically do this...
    Google SheetsGoogle Sheets
    Lookup Spreadsheet Row

    Finds a row by a column and value. Returns the entire row if one is found.

    ActionSearch
  3. then do this!
    Google SheetsGoogle Sheets
    Update Spreadsheet Row

    Update a row in a specific spreadsheet.

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
  • awork triggers, actions, and search

    New Project

    Triggers when a new project is created.

    Trigger
    Instant
    Try It
  • awork triggers, actions, and search

    New Time Entry

    Triggers when a new time entry is created.

    Trigger
    Instant
    Try It
  • awork triggers, actions, and search

    Updated Time Entry

    Triggers when a time entry is updated.

    Trigger
    Instant
    Try It
    • NameRequired

    • Description

    • Company

    • Project Type

    • Project Template

    • Project StatusRequired

    • Start Date

    • Due Date

    • Time Budget In Hours

    • Project Tags

    Action
    Write
  • awork triggers, actions, and search

    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
    Try It
  • awork triggers, actions, and search

    Updated Task

    Triggers when a task is updated. The trigger only fires for tasks with a project assigned, not for private tasks.

    Trigger
    Instant
    Try It
    • NameRequired

    • Industry

    • Phone

    • Email

    • Tags

    Action
    Write
    • NameRequired

    • Description

    • ProjectRequired

    • Type Of WorkRequired

    • Task StatusRequired

    • Assignee

    • Due On

    • Start On

    • Is Priority

    • Planned Duration In Hours

    • Remaining Duration In Hours

    • Task List

    • Checklist Items

    Action
    Write
awork logo

About awork

Intelligent projects, tasks and time tracking for your project business.

Related categories

  • Team Collaboration
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Related categories

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets