Connect Google BigQuery and Qonto

Both apps 42Google BigQuery 14Qonto 28

• 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
  Bank Account Balance Change

  Triggers when the balance or authorized balance of one of your Qonto business accounts changes.

• Trigger
  New Bank Account

  Triggers when a new business bank account is added to the Qonto organization.

• Trigger
  New Transaction

  Triggers when a new transaction is recorded on a Qonto bank account.

• Trigger
  New Transaction (Legacy)

  Triggers when a new transaction is created on the chosen Qonto bank account.

• Trigger
  New Transfer

  Triggers when a new SEPA transfer is created in your Qonto organization.

• Trigger
  Transaction Updated Attachments

  Triggers when the attachments on a transaction change, such as when a receipt is added to it.

• Trigger
  Transaction Updated Labels

  Triggers when the labels on a transaction change, for example when a label is added to a transaction or one of several labels is removed.

• Trigger
  Transaction Updated VAT

  Triggers when a transaction's VAT amount or VAT rate is set or changed on a Qonto bank account.

• Trigger
  Updated Transaction

  Triggers when a transaction on a Qonto bank account is created or updated.

• Action
  Add Attachment

  Uploads a JPEG, PNG or PDF file, such as an invoice or receipt, and attaches it to a transaction. Qonto processes the file in the background, so it may not appear on the transaction immediately.

• Action
  Add client

  Creates a client (a company, individual or freelancer you bill) in your Qonto organization and returns the new client record.

• Action
  Add client invoice

  Creates a client invoice in Qonto for an existing client, as a draft or ready for payment, and returns the new invoice.

• Action
  Add SEPA beneficiary

  Adds a new untrusted SEPA beneficiary to the organization's main bank account and returns it.

• Action
  Create External Transfer

  Creates a SEPA transfer from one of your Qonto bank accounts to a saved or new beneficiary, and returns the transfer with its status.

• Action
  Create Internal Transfer

  Creates an instant transfer between two bank accounts of your Qonto organization.

• Action
  Get bank account

  Returns a Qonto business bank account, including its IBAN, status and current balances.

• Action
  Get organization

  Returns the details of the connected Qonto organization, including its legal information and its list of bank accounts.

• Action
  Get transaction

  Returns a single Qonto transaction by its ID, including its amount, counterparty, status and dates, and optionally its labels, attachments or VAT details.

• Action
  List bank accounts

  Returns all business bank accounts of the connected Qonto organization, with their IBAN, status and balances.

• Action
  List cards

  Returns the cards visible to the connected Qonto member, optionally filtered by holder, status, bank account, card level or text search.

• Action
  List client invoices

  Returns the client invoices of the Qonto organization, optionally filtered by status, creation, update or due dates, and sorted by creation date.

• Action
  List clients

  Returns the clients (customers you invoice) of your Qonto organization, optionally filtered by name, email, VAT or tax number, or last-updated date.

• Action
  List labels

  Returns all the labels of the Qonto organization, including each label's name and parent label.

• Action
  List memberships

  Returns all the memberships of the authenticated Qonto organization, with each member's name, role, status and team.

• Action
  List SEPA beneficiaries

  Returns the SEPA beneficiaries of your Qonto organization, optionally filtered by IBAN, status or trusted flag.

• Action
  List statements

  Returns the monthly bank statements of the Qonto organization, each with its period, bank account and a temporary link to download the file. Can be narrowed to specific bank accounts or a range of months.

• Action
  List supplier invoices

  Returns the organization's supplier invoices and documents awaiting review, optionally filtered by status, dates, supplier, amount or a text search.

• Action
  List transactions

  Returns the transactions of a Qonto bank account, with optional filters by status, date range, direction, operation type and attachments.

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