Connect Google BigQuery and Playbook Creative

Both apps 34Google BigQuery 14Playbook Creative 20

• 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
  Asset Added

  Triggers when a new asset is added to the chosen Playbook board. Returns the asset, the board and the organization it belongs to.

• Trigger
  Asset Updated in Board

  Triggers when an asset on a chosen Playbook board is updated, returning the asset and what changed.

• Action
  Create Asset

  Creates an asset in a Playbook workspace, either from a file URL (fetched by Playbook or saved as a link) or as a text note, optionally placing it on a board.

• Action
  Create Board

  Creates a new board in a Playbook workspace, optionally nested under an existing board as a sub-board.

• Action
  Create Organization

  Creates a new Playbook organization (workspace) with the given name and returns its id and slug.

• Action
  Delete asset

  Deletes an asset from a Playbook workspace.

• Action
  Delete board

  Deletes a board from a Playbook workspace.

• Action
  Find Asset

  Searches a Playbook workspace for assets matching the words you enter, best match first, with optional filters for media type, boards, tags, statuses, uploader and more.

• Action
  Find Board

  Returns the boards in a Playbook workspace whose title matches the text you search for.

• Action
  Get asset

  Returns one asset from a Playbook workspace, including its title, media type, tags, status, custom field values and preview URLs.

• Action
  Get board

  Returns one Playbook board, including its title, description, asset count, published-page state and preview assets.

• Action
  List assets

  Returns the assets in a Playbook workspace, optionally limited to one board, one uploader, or assets uploaded after a given time.

• Action
  List boards

  Returns the boards in a Playbook workspace, optionally filtered by title and sorted by title or creation date.

• Action
  List organizations

  Returns every Playbook organization (workspace) the connected user belongs to, with each one's name, slug, plan and usage limits.

• Action
  List users

  Returns the members of a Playbook workspace, optionally narrowed to those whose name or email matches a search.

• Action
  Move Asset

  Moves one or more assets into a different board in a Playbook workspace.

• Action
  Update Asset

  Updates an existing Playbook asset's title, board placement, status, tags or custom field values, and can save a new version of it.

• Action
  Update Asset Status

  Sets the status of an asset in a Playbook workspace and returns the updated asset.

• Action
  Update asset tags

  Adds and/or removes tags on a Playbook asset, leaving its other tags untouched, and returns the updated asset.

• Action
  Update board

  Updates a board's title, description, or parent board in a Playbook workspace and returns the updated board.

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