Connect Google BigQuery to Kiflo PRM

Both apps 36Google BigQuery 14Kiflo PRM 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.

• Action
  Accept Deal

  Accepts a deal in Kiflo and sets its status to Accepted, optionally adding a note.

• Action
  Accept Lead

  Accepts a lead in Kiflo and sets its status to Accepted, optionally adding a note.

• Action
  Associate Customer to Deal

  Links a customer to an existing deal — either an existing customer by ID, or a new customer created from the details you supply.

• Action
  Convert Lead to Customer

  Converts a lead into a customer and marks the lead as Converted, returning the updated lead.

• Action
  Convert Lead to Deal

  Converts a lead into a deal and sets the lead's status to Converted. Returns the updated lead, including the id of the new deal.

• Action
  Create Attachment

  Downloads a file from a URL and attaches it to a Kiflo partner, deal, lead, note, payout, customer or collaboration.

• Action
  Create Channel Conflict

  Records a channel conflict detected in an external source, such as your CRM, and makes it visible in Kiflo. Returns the created channel conflict.

• Action
  Create Customer

  Creates a new customer in Kiflo, with your customer properties, and optionally associates it with a partner.

• Action
  Create Deal

  Creates a new deal in Kiflo, optionally linking a contact, partners and custom deal properties.

• Action
  Create Lead

  Creates a lead in Kiflo, optionally assigning it to a partner or recording the partner who sourced it.

• Action
  Create Note

  Creates a note on an existing partner, lead, deal, customer or payout in Kiflo.

• Action
  Create Partner

  Creates a new partner in Kiflo, optionally with its main contact, group, program level, onboarding stage and payout details.

• Action
  Create Transaction

  Creates a transaction in Kiflo for an existing customer, optionally linked to a partner and a deal, and returns the new transaction.

• Action
  Find a Certification

  Returns the certifications defined in your Kiflo account whose name contains the text you specify.

• Action
  Find a Contact

  Returns the contacts whose chosen property exactly matches the value you specify.

• Action
  Find a Partner Application

  Returns the partner applications that match a partner name, team member email, status or partner.

• Action
  Find a Partner Team Member

  Returns the partner team members that match an email address, a partner, or both.

• Action
  Pay Payout

  Marks a validated payout as paid in Kiflo and returns the updated payout. This records the payment and does not move any money.

• Action
  Refuse Deal

  Refuses a deal in Kiflo and sets its status to Refused, optionally adding a note. Returns the refused deal.

• Action
  Refuse Lead

  Refuses a lead in Kiflo and sets its status to Refused, optionally adding a note. Returns the updated lead.

• Action
  Reject a Partner Application

  Rejects a partner application that is still pending, so the applicant does not become a partner. Returns the rejected application.

• Action
  Update Lead

  Updates an existing lead's deadline, currency, assigned partner contact, owner and properties, and returns the updated lead.

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