Connect Google BigQuery and Intervals

Both apps 58Google BigQuery 14Intervals 44

• 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
  New client

  Polling trigger: fires when a new client is created in Intervals.

• Trigger
  New invoice

  Polling trigger: fires when a new invoice is created in Intervals.

• Trigger
  New milestone

  Polling trigger: fires when a new milestone is created in Intervals.

• Trigger
  New person

  Polling trigger: fires when a new person is added in Intervals.

• Trigger
  New project

  Polling trigger: fires when a new project is created in Intervals.

• Trigger
  New task

  Polling trigger: fires when a new task is created in Intervals.

• Action
  Add client

  Create a new client.

• Action
  Add expense

  Create a new expense.

• Action
  Add invoice

  Create a new invoice.

• Action
  Add milestone

  Create a new milestone.

• Action
  Add person

  Create a new person (team member).

• Action
  Add project

  Create a new project.

• Action
  Add task

  Create a new task.

• Action
  Add time entry

  Log a new time entry against a task.

• Action
  Add timer

  Start a new timer for a task.

• Action
  Delete client

  Delete a client.

• Action
  Delete expense

  Delete an expense.

• Action
  Delete invoice

  Delete an invoice.

• Action
  Delete milestone

  Delete a milestone.

• Action
  Delete person

  Delete a person.

• Action
  Delete project

  Delete a project.

• Action
  Delete task

  Delete a task.

• Action
  Delete time entry

  Delete a logged time entry.

• Action
  Delete timer

  Delete a timer.

• Action
  Get client

  Retrieve a single client by id.

• Action
  Get expense

  Retrieve a single expense by id.

• Action
  Get invoice

  Retrieve a single invoice by id.

• Action
  Get milestone

  Retrieve a single milestone by id.

• Action
  Get person

  Retrieve a single person by id.

• Action
  Get project

  Retrieve a single project by id.

• Action
  Get task

  Retrieve a single task by id.

• Action
  Get time entry

  Retrieve a single logged time entry by id.

• Action
  Get timer

  Retrieve a single timer by id.

• Action
  List milestones

  Retrieve all milestones in the Intervals account.

• Action
  List tasks

  Retrieve all tasks in the Intervals account.

• Action
  Update client

  Update an existing client's details.

• Action
  Update expense

  Update an existing expense.

• Action
  Update invoice

  Update an existing invoice.

• Action
  Update milestone

  Update an existing milestone.

• Action
  Update person

  Update an existing person's details.

• Action
  Update project

  Update an existing project's details.

• Action
  Update task

  Update an existing task's details.

• Action
  Update time entry

  Update an existing logged time entry.

• Action
  Update timer

  Update a timer (e.g. stop or adjust it).

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