Connect Timesheet and Google Sheets

Both apps 122Timesheet 60Google Sheets 62

• Trigger
  New Absence

  Triggered when a new absence is requested or recorded in the chosen Timesheet organization.

• Trigger
  New Project

  Triggered when a new project is created in Timesheet.

• Trigger
  New Rate

  Triggered when a new pay rate is created in Timesheet.

• Trigger
  New Tag

  Triggered when a new tag is created in Timesheet.

• Trigger
  New Task

  Triggered when a new tracked time entry is recorded in Timesheet.

• Trigger
  New Team

  Triggered when a new team is created in Timesheet.

• Trigger
  New Todo

  Triggered when a new to-do is created in Timesheet.

• Action
  Approve Absence

  Approves a pending absence request in a Timesheet organization. Returns the updated absence, including its new status and who approved it.

• Action
  Create Expense

  Creates an expense on a Timesheet task, with an amount, date and optional receipt. Returns the new expense with its ID.

• Action
  Create Note

  Creates a note on a Timesheet task, with text and an optional attachment. Returns the new note with its ID.

• Action
  Create Organization

  Creates a new organization (team workspace) in Timesheet. Returns the new organization with its ID.

• Action
  Create Project

  Creates a new project in Timesheet, optionally with a client, default billing rate and team. Returns the new project with its ID.

• Action
  Create Rate

  Creates a pay rate in Timesheet, such as an overtime multiplier or a bonus amount. Returns the new rate with its ID.

• Action
  Create Reminder

  Creates a reminder in Timesheet on a one-off or recurring schedule. Returns the new reminder with its ID and next fire time.

• Action
  Create Tag

  Creates a tag in Timesheet that can be applied to time entries. Returns the new tag with its ID.

• Action
  Create Task

  Creates a time entry (task) on a Timesheet project, with start and end times and optional tags, rate and mileage. Returns the new entry with its ID and duration.

• Action
  Create Team

  Creates a team inside a Timesheet organization. Returns the new team with its ID.

• Action
  Create Todo

  Creates a to-do on a Timesheet project, with an optional due date, assignees and time estimate. Returns the new to-do with its ID.

• Action
  Delete Expense

  Deletes an expense from Timesheet. Returns confirmation that the expense was removed.

• Action
  Delete Note

  Deletes a note from Timesheet. Returns confirmation that the note was removed.

• Action
  Delete Organization

  Deletes an organization from Timesheet. Returns confirmation that the organization was removed.

• Action
  Delete Project

  Deletes a project from Timesheet. Returns confirmation that the project was removed.

• Action
  Delete Rate

  Deletes a pay rate from Timesheet. Returns confirmation that the rate was removed.

• Action
  Delete Reminder

  Deletes a reminder from Timesheet. Returns confirmation that the reminder was removed.

• Action
  Delete Tag

  Deletes a tag from Timesheet. Returns confirmation that the tag was removed.

• Action
  Delete Task

  Deletes a time entry from Timesheet. Returns confirmation that the entry was removed.

• Action
  Delete Team

  Deletes a team from Timesheet. Returns confirmation that the team was removed.

• Action
  Delete Todo

  Deletes a to-do from Timesheet. Returns confirmation that the to-do was removed.

• Action
  Find Absence

  Searches absences in a Timesheet organization by member, contract, type, status or date range, and returns the first match plus the full list of matches.

• Action
  Find Expense

  Searches Timesheet expenses by text, time entry, organization or date range, and returns the first match plus the full list of matches.

• Action
  Find Note

  Searches Timesheet notes by text, time entry, organization or date range, and returns the first match plus the full list of matches.

• Action
  Find Organization

  Looks up a Timesheet organization by name and returns its ID and details. Timesheet has no organization search endpoint, so this reads your organizations and matches the name, ignoring upper/lower case.

• Action
  Find Project

  Searches Timesheet projects by name, team or status, and returns the first match plus the full list of matches.

• Action
  Find Rate

  Searches Timesheet pay rates by name, team, project or status, and returns the first match plus the full list of matches.

• Action
  Find Reminder

  Looks up a Timesheet reminder by name and returns its ID and schedule. Timesheet has no reminder search endpoint, so this reads your reminders and matches the name, ignoring upper/lower case.

• Action
  Find Tag

  Searches Timesheet tags by name, team, project or status, and returns the first match plus the full list of matches.

• Action
  Find Task

  Searches Timesheet time entries by text, project, to-do, team or date range, and returns the first match plus the full list of matches.

• Action
  Find Team

  Searches Timesheet teams by name or organization, and returns the first match plus the full list of matches.

• Action
  Find Todo

  Searches Timesheet to-dos by title, project, status or assignee, and returns the first match plus the full list of matches.

• Action
  Get Current Timer

  Returns the state of your current Timesheet timer — whether it is running, paused or stopped, and the time entry it is tracking.

• Action
  Get Project

  Returns one Timesheet project by ID, including its client, settings and tracked totals.

• Action
  Get Rate

  Returns one Timesheet pay rate by ID, including its multiplier and extra amount.

• Action
  Get Tag

  Returns a single tag by its ID, including its name, colour, archived state, owning team and total tracked time.

• Action
  Get Task

  Returns a single tracked time entry by its ID, including its description, start and end times, duration, billing flags, project, rate, member and tags.

• Action
  Get Team

  Returns a single team by its ID, including its name, description, colour, owning organization, and project and member counts.

• Action
  Pause Timer

  Pauses the running timer, starting a break. Returns the timer with its new paused state.

• Action
  Resume Timer

  Resumes a paused timer, ending the current break. Returns the timer with its new running state.

• Action
  Send Report

  Generates a timesheet report for the chosen period and emails it to the given address.

• Action
  Start Timer

  Starts the timer on a project, creating a running time entry. Returns the timer and the entry it is tracking.

• Action
  Stop Timer

  Stops the running timer and closes out the time entry it was tracking.

• Action
  Update Expense

  Updates an existing expense's description, date, amount, refund status or attached receipt. Fields left blank keep their current values.

• Action
  Update Note

  Updates an existing note's text, date or attachment. Fields left blank keep their current values.

• Action
  Update Organization

  Updates an organization's name, description, image, colour or AI chat setting. Fields left blank keep their current values.

• Action
  Update Project

  Updates an existing project's name, client, office, colour, billing defaults, salary or archived state. Fields left blank keep their current values.

• Action
  Update Rate

  Updates an existing pay rate's name, multiplier, extra amount, enabled or archived state. Fields left blank keep their current values.

• Action
  Update Reminder

  Updates an existing reminder's title, prompt, message template or schedule. Fields left blank keep their current values.

• Action
  Update Tag

  Updates an existing tag's name, colour or archived state. Fields left blank keep their current values.

• Action
  Update Task

  Updates an existing tracked time entry's project, description, times, billing flags, rate or tags. Fields left blank keep their current values.

• Action
  Update Team

  Updates an existing team's name, description, image, colour or salary visibility. Fields left blank keep their current values.

• Action
  Update Todo

  Updates an existing to-do's title, details, status, due date, assignees or time estimate. Fields left blank keep their current values.

• Trigger
  Aggregate Metric Changed

  Fires when an aggregate metric (sum/avg/count/…) over a column changes.

• Trigger
  Cell Range Values Changed

  Fires when the values in a specific cell range change.

• Trigger
  Conditional Format Rule Changed

  Fires when a conditional-format rule changes.

• Trigger
  Data Validation Rule Changed

  Fires when a data-validation rule changes.

• Trigger
  Developer Metadata Changed

  Fires when developer metadata changes.

• Trigger
  Filtered Range Values Changed

  Fires when the values in a filtered range change.

• Trigger
  New Rows

  Fires when new rows are appended to a Google Sheet.

• Trigger
  New Sheet Added

  Fires when a new sheet (tab) is added to a spreadsheet.

• Trigger
  New Spreadsheet Created

  Fires when a new spreadsheet is created in the account.

• Trigger
  Spreadsheet Metadata Changed

  Fires when spreadsheet metadata changes.

• Trigger
  Spreadsheet Properties Changed

  Fires when spreadsheet properties change.

• Trigger
  Spreadsheet Row Changed

  Fires when a row matching a query changes.

• Trigger
  Spreadsheet Search Match

  Fires when a spreadsheet matching search criteria is found.

• Trigger
  Table Query Result Changed

  Fires when the result of a SQL-style table query changes.

• Trigger
  Table Schema Changed

  Fires when a table's column schema changes.

• Trigger
  Worksheet Names Changed

  Fires when worksheet (tab) names change.

• Action
  Add Row

  Append a row to a Google Sheet

• Action
  Aggregate Column Data

  Read a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).

• Action
  Auto-Resize Rows or Columns

  Auto-fit row heights or column widths over an index range via autoResizeDimensions.

• Action
  Change Sheet Properties

  Update a worksheet's grid properties (row/column count) using an explicit field mask.

• Action
  Clear Basic Filter

  Remove the basic filter from a sheet via clearBasicFilter.

• Action
  Clear Spreadsheet Row(s)

  Clear the values in a range (formatting preserved).

• Action
  Copy Range

  Copy a source cell range to a destination range within the spreadsheet.

• Action
  Copy Worksheet

  Copy a worksheet into a destination spreadsheet.

• Action
  Create Chart

  Add a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.

• Action
  Create Conditional Formatting Rule

  Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.

• Action
  Create Multiple Spreadsheet Rows

  Append many rows in one call.

• Action
  Create Spreadsheet

  Create a new Google Sheets spreadsheet with the given title.

• Action
  Create Spreadsheet Column

  Insert a blank column at a given index.

• Action
  Create Spreadsheet Row

  Append a single row of values to a sheet range.

• Action
  Create Spreadsheet Row at Top

  Insert a blank row just below the header (row 2), then write the given values into it in one operation.

• Action
  Create Worksheet

  Add a new worksheet (tab) to an existing spreadsheet.

• Action
  Delete Chart

  Delete an embedded chart via deleteEmbeddedObject.

• Action
  Delete Sheet

  Delete a worksheet from a spreadsheet by sheetId (gid).

• Action
  Delete Spreadsheet Row(s)

  Delete a contiguous block of rows by index.

• Action
  Find and Replace

  Find and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).

• Action
  Find Spreadsheet

  Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).

• Action
  Find Worksheet

  Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.

• Action
  Format Cell Range

  Apply background color and bold formatting to a cell range via repeatCell.

• Action
  Format Spreadsheet Row

  Apply a background color across an entire row via repeatCell over a row range.

• Action
  Get Conditional Format Rules

  List all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).

• Action
  Get Data Range

  Read all values in one or more ranges via batchGet.

• Action
  Get Data Validation Rules

  Read the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).

• Action
  Get Many Spreadsheet Rows (Advanced)

  Read multiple ranges at once via batchGet.

• Action
  Get Row by ID

  Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.

• Action
  Get Sheet Names

  Return the titles of all sheets (tabs) in the spreadsheet.

• Action
  Get Spreadsheet by ID

  Fetch spreadsheet metadata (title, sheets, gids, grid properties).

• Action
  List Charts

  List all embedded charts (chartId + title) across every sheet in the spreadsheet.

• Action
  Lookup Spreadsheet Row

  Read a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Lookup Spreadsheet Rows (Advanced)

  Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Move Chart

  Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.

• Action
  Rename Sheet

  Rename a worksheet's title.

• Action
  Search Spreadsheets

  Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.

• Action
  Set Basic Filter

  Apply a basic filter to a range on a sheet via setBasicFilter.

• Action
  Set Data Validation

  Apply a ONE_OF_LIST dropdown data-validation rule to a cell range.

• Action
  Sort Range

  Sort a cell range by one column in ascending or descending order.

• Action
  Update Chart

  Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.

• Action
  Update Conditional Format Rules

  Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.

• Action
  Update Data Validation Rule

  Overwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).

• Action
  Update Spreadsheet Row

  Overwrite the values at a specific range.

• Action
  Update Spreadsheet Row(s)

  Update one or more disjoint ranges in a single batch.

• Action
  Upsert Row

  Read a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.