Connect Geekbot and Google BigQuery

Both apps 32Geekbot 18Google BigQuery 14

• Trigger
  New Report

  Triggers when a new standup report is submitted in Geekbot.

• Action
  Add out-of-office period

  Schedules an out-of-office period for you or, if you are an admin, for another team member, covering whole days from the start date to the end date.

• Action
  Add poll

  Creates a one-shot Geekbot poll that posts a question with answer choices to a channel.

• Action
  Add standup

  Creates a new Geekbot standup with its questions, schedule and broadcast channel.

• Action
  Delete report

  Deletes a standup report you authored, removing its broadcast message if one was posted.

• Action
  Delete standup

  Deletes a standup and returns the details of the standup that was removed. You must have permission to edit the standup.

• Action
  Get current user

  Returns the user who owns the connected API key, along with the team they belong to.

• Action
  Get poll

  Returns one poll you created, including its schedule, channel, members and optionally its questions.

• Action
  Get report

  Returns one submitted standup report, including who posted it, when, and the answer to each question.

• Action
  Get standup

  Returns one standup by id, including its schedule, members, broadcast settings and optionally its questions.

• Action
  List out-of-office periods

  Returns out-of-office periods for the team members you can view, ordered by start date, optionally narrowed by users, standups or a date window.

• Action
  List polls

  Returns the active and paused polls you created in Geekbot, optionally filtered by state, channel, anonymity or creation date.

• Action
  List poll votes

  Returns the vote results for a poll, grouped by broadcast and question. Without a date range it covers only the latest broadcast.

• Action
  List reports

  Returns submitted Geekbot standup reports within a time window, optionally filtered by standup or user.

• Action
  List standups

  Returns the active and paused standups visible to the connected user, with optional filters for state, anonymity, channel and creation date.

• Action
  List teams

  Returns the Geekbot team tied to the connected API key, including its users who take part in at least one standup visible to the connected user.

• Action
  Start Report

  Starts a standup immediately so its report questions go out, either to all of its participants or only to the users or emails you name. Returns the vendor's confirmation that the standup was queued.

• Action
  Update standup

  Updates a standup's name, schedule, questions, channel and participants. Returns the updated standup.

• 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.

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