Connect Qonto and Zoho Sheet

Both apps 48Qonto 28Zoho Sheet 20

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

• Trigger
  New or Updated Row (WorkDrive)

  Triggers when a new row is added or an existing row is modified in a specified worksheet.

• Trigger
  New Row (WorkDrive)

  Triggers when a new row is created in a specified worksheet.

• Trigger
  New Workbook

  Triggered when a new workbook is created in Zoho Sheet.

• Trigger
  Updated Column

  Fires when a cell inside the chosen column(s) of a Zoho Sheet worksheet is changed.

• Trigger
  Updated Column (WorkDrive)

  Triggers when the value of a particular column is set on both new and updated rows. The corresponding row data is returned along with this trigger.

• Action
  Create Row

  Adds one or more rows to a worksheet in a Zoho Sheet workbook, matching values to columns by the header row.

• Action
  Create Row (WorkDrive)

  Adds one or more rows to a worksheet in a Zoho Sheet workbook (including workbooks stored in Zoho WorkDrive), matching values to the table's header columns.

• Action
  Create Worksheet

  Adds a new worksheet (tab) to a Zoho Sheet workbook.

• Action
  Create Worksheet (WorkDrive)

  Creates a new worksheet in the specified workbook.

• Action
  Delete Row

  Deletes a particular row based on its index.

• Action
  Delete Row (WorkDrive)

  Deletes a particular row based on its index.

• Action
  List Worksheets

  Lists the worksheets (tabs) in a workbook via worksheet.list.

• Action
  Search and Delete Row

  Deletes the row(s) in a Zoho Sheet worksheet that match a search criteria, removing them so the rows below move up.

• Action
  Search and Delete Row (WorkDrive)

  Finds the rows in a worksheet of a WorkDrive-stored Zoho Sheet workbook that match a search criteria and deletes them.

• Action
  Search and Update Row

  Searches and then updates a row based on some criteria.

• Action
  Search and Update Row (WorkDrive)

  Finds the rows in a Zoho Sheet worksheet (stored in WorkDrive) that match a criteria and updates them with new column values.

• Action
  Search Row

  Returns the rows of a Zoho Sheet worksheet that match the specified criteria.

• Action
  Search Row - Workdrive Users

  Returns the rows of a Zoho Sheet worksheet (stored in WorkDrive) that match the specified criteria.

• Action
  Update Row

  Updates one row of a Zoho Sheet worksheet, identified by its row number, with new values keyed by column header.

• Action
  Update Row (WorkDrive)

  Updates one row of a worksheet in a Zoho Sheet workbook stored in WorkDrive, identified by its row number, with new values keyed by column header.

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