Connect Google BigQuery to Kommo

Both apps 22Google BigQuery 14Kommo 8

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

• Action
  Find Contact

  Returns the Kommo contacts that match a search term (searched across contact names, phones, emails and other field values) or the given filters such as contact ID, name or responsible user.

• Action
  Find Lead

  Returns the leads that match a search phrase or the filters you set, such as name, ID, pipeline, stage, responsible user or date ranges.

• Action
  Find Linked Data

  Returns the contacts, companies, leads and list items linked to a lead, contact or company, optionally narrowed to one linked record or list.

• Action
  Find Task

  Returns up to 250 tasks that match the criteria you give, such as the task ID, the lead, contact or company it is linked to, its responsible user, type or completion status.

• Action
  Update Contact

  Updates an existing Kommo contact's name, responsible user, tags and custom fields. Fields left blank keep their current values.

• Action
  Update Lead

  Updates an existing Kommo lead — its name, sale value, pipeline stage, responsible user, tags and custom fields. Fields left blank keep their current values.

• Action
  Update Note

  Updates the text, type or properties of an existing note on a Kommo lead, contact or company.

• Action
  Update Task

  Updates an existing Kommo task — its text, due date, type, responsible user, linked record, completion status or result.

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