Connect Zoho Sheet to Modern Treasury

Both apps 34Zoho Sheet 20Modern Treasury 14

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

• Action
  Add counterparty

  Creates a counterparty — a person or business you send payments to or receive payments from — optionally with its bank accounts and legal entity.

• Action
  Add expected payment

  Creates an expected payment in Modern Treasury so an incoming or outgoing payment can be reconciled automatically when it arrives.

• Action
  Add external account

  Creates an external bank account for a counterparty in Modern Treasury, with its account numbers, routing details and owner information.

• Action
  Add invoice

  Creates an invoice for a counterparty, payable to one of your internal accounts.

• Action
  Add ledger transaction

  Creates a ledger transaction made of balanced debit and credit entries against your ledger accounts.

• Action
  Add payment order

  Creates a payment order that moves money between one of your internal accounts and a counterparty's or another internal account.

• Action
  Delete counterparty

  Deletes a counterparty from your Modern Treasury organization.

• Action
  Get counterparty

  Returns a single counterparty, including its accounts, contact details and metadata.

• Action
  Get invoice

  Returns a single invoice by its ID, including its amounts, status, counterparty and line-item details.

• Action
  Get ledger transaction

  Returns one ledger transaction, including its ledger entries, status and metadata.

• Action
  Get payment order

  Returns the details of a single payment order, including its amount, status, direction and accounts.

• Action
  List internal accounts

  Returns the organization's internal (bank) accounts, optionally filtered by counterparty, legal entity, currency, status or payment capability.

• Action
  Update counterparty

  Updates an existing counterparty's name, email, external ID, legal entity, metadata, remittance-advice setting or taxpayer identifier. Returns the updated counterparty.

• Action
  Update payment order

  Updates an existing payment order, for example changing its amount, description, metadata or status (such as cancelling or approving it). Returns the updated payment order.

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