Connect Google BigQuery and TimeKeeper

Both apps 31Google BigQuery 14TimeKeeper 17

• Trigger
  New Job Completed

  Triggers when a BigQuery job in the project finishes, whether it succeeded or failed.

• Trigger
  New Row

  Triggers when a new row is added to a table. New rows are detected by a column you name that increases for newer rows, such as a creation time or a sequential ID.

• Trigger
  Query Job Completed (With Row Data)

  Triggers when a SELECT query job in the project finishes successfully, and includes its result rows.

• Trigger
  Updated Row

  Triggers when a row in a table is added or changed, detected by a last-updated timestamp column you name.

• Action
  Create Row

  Creates a new row of data in a table. Note: Does not create a job.

• Action
  Create Rows

  Creates new rows of data in a table (accepts line items). Note: Does not create a job.

• Action
  Delete Rows

  Deletes every row in a table whose match column equals the value you give.

• Action
  Find One Row

  Finds the first row in a table whose column equals the value you give.

• Action
  Get Rows for Job Completed

  Returns the result rows of a finished query job.

• Action
  Import Data

  Imports a JSON, CSV, Avro or Parquet file from Cloud Storage into a table. Waits up to about 40 seconds for the import to finish; larger imports keep running in BigQuery and return state RUNNING.

• Action
  List Datasets

  Returns the datasets in a Google Cloud project.

• Action
  List Tables

  Returns the tables in a BigQuery dataset.

• Action
  Run a Query

  Runs a SQL query against a table in BigQuery.

• Action
  Update Row(s)

  Updates every row in a table whose match column equals the value you give, setting the columns you choose.

• Trigger
  Employee Clock In

  Triggers when an employee clocks in, returning the new time entry with its employee, job, activity and start time.

• Trigger
  Employee Clock Out

  Triggers when an employee clocks out, delivering the completed time entry with its start and end times, duration, job and activity.

• Trigger
  Leave Request Approved

  Triggers when a leave request is approved in TimeKeeper, for leave falling between 30 days ago and 59 days ahead.

• Trigger
  Who's In

  Triggers when an employee appears on the Who's In list, i.e. each time someone clocks in, with their location, last job and clock-in time.

• Action
  Add activity

  Creates a new activity in TimeKeeper that employees can log time against.

• Action
  Add a Job

  Creates a new job in TimeKeeper with a name and optional job number and address.

• Action
  Get employee timesheet

  Returns an employee's timesheet for a date range, including total regular, overtime and leave hours plus each day's time entries and leave.

• Action
  Get job breakdown report

  Generates a breakdown report for one TimeKeeper job over a date range of up to 60 days.

• Action
  List activities

  Returns every activity set up in your TimeKeeper account, with each activity's name and number.

• Action
  List employees

  Returns the employees in your TimeKeeper account, including archived ones, with their contact details, job title, teams and working locations.

• Action
  List jobs

  Returns every job in your TimeKeeper account, with each job's name, job number, completion status and id.

• Action
  List leave entries

  Returns employee leave entries (annual leave and other leave types) within a date range of up to 30 days, optionally for one employee or one leave type. Public holidays are not included.

• Action
  List leave requests

  Returns the leave requests in your TimeKeeper account for a date range of up to 90 days, optionally filtered by status, leave type or employee. Returns open requests unless another status is chosen.

• Action
  List shifts

  Returns the draft, open and published shifts scheduled in a date range of up to 90 days, optionally for one employee. Shift times are in UTC.

• Action
  List time entries

  Returns the time entries recorded in your TimeKeeper account for a date range of up to 90 days, optionally narrowed to one employee, job or activity.

• Action
  Update activity

  Updates the name and activity number of an existing activity in TimeKeeper.

• Action
  Update a Job

  Updates an existing job in TimeKeeper, changing its name, job number, address or address coordinates.

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