Connect Google BigQuery and Relate

Both apps 36Google BigQuery 14Relate 22

• 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
  Contact Created

  Triggers when a new contact is added in Relate.

• Trigger
  Entry Created

  Triggers when a new entry is added to a Relate list or process.

• Trigger
  Entry Updated

  Triggers when an entry in a Relate list or process is added or changed.

• Trigger
  New Recorded Meeting

  Triggers when a new recorded meeting is added in Relate (only meetings with at least one completed recording appear).

• Trigger
  Note Created

  Triggers when a new note is added in Relate.

• Trigger
  Organization Created

  Triggers when a new organization is added in Relate.

• Action
  Create Contact

  Creates a contact in Relate from a first name and/or email address, optionally linked to an organization.

• Action
  Create Note

  Creates a note on an organization in Relate, optionally linked to a deal.

• Action
  Create Organization

  Creates an organization in Relate from a name and/or website domain.

• Action
  Delete Contact

  Deletes a Relate contact.

• Action
  Delete Note

  Deletes a note in Relate.

• Action
  Delete Organization

  Deletes a Relate organization.

• Action
  Find Contact

  Finds a contact in Relate by email address or phone number and returns the first match.

• Action
  Find Entry From Organization Process

  Finds an organization's entry in a Relate process by organization ID.

• Action
  Find Note

  Returns the most recently updated notes in Relate, optionally only those updated after a given time; the first note is also returned on its own.

• Action
  Find Organization

  Returns Relate organizations, most recently updated first, optionally only those updated after a given time. The first organization's fields are also returned on their own.

• Action
  Get Contact

  Returns one Relate contact by its ID.

• Action
  Get Organization

  Returns one Relate organization by its ID.

• Action
  Get Recording

  Returns a meeting recording from Relate with its AI summary, topics, action items and transcript (summary and transcript are empty until processing is done).

• Action
  Update Contact

  Updates a Relate contact's name or email addresses.

• Action
  Update Note

  Updates a note's text or linked deal in Relate.

• Action
  Update Organization

  Updates a Relate organization's name or domains.

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