Connect Mendato and Zoho Sheet

Both apps 47Mendato 27Zoho Sheet 20

• Trigger
  New Employee

  Triggers when a new employee is added in Mendato. Optional filters limit which employees fire the trigger.

• Trigger
  New Subcontractor

  Triggers when a new subcontractor is added in Mendato.

• Action
  Add employee

  Creates a new employee in Mendato.

• Action
  Add material

  GraphQL mutation createMaterial.

• Action
  Add object

  GraphQL mutation createObject (cleaning object/property).

• Action
  Add order

  Creates a new order (Auftrag) for an object, with the services to perform, and optionally the materials used and the employees or subcontractors assigned.

• Action
  Add prospect

  Creates a new prospect (potential customer) in Mendato, optionally with contact persons and a first prospect object.

• Action
  Add quote

  GraphQL mutation createQuote.

• Action
  Add supplier

  GraphQL mutation createSupplier.

• Action
  Add ticket

  Creates a ticket (a complaint, extra request, material demand or damage report) for an object in Mendato.

• Action
  Add time record

  Creates a time record for an employee in Mendato, with start and end time, optional journey start, break duration and the object (site) worked at.

• Action
  Create Credit Note

  Creates a credit note (Gutschrift) for a subcontractor in Mendato, with its line items, dates and texts.

• Action
  Create Customer

  Creates a new customer (person or company) in Mendato with address, contact and billing details.

• Action
  Create Estimate

  Creates a new estimate

• Action
  Create Invoice

  Creates an invoice for a customer in Mendato, with its line items, dates and texts, optionally completing and sending it right away.

• Action
  Create Subcontractor

  Creates a new subcontractor

• Action
  Find Customer

  Returns up to 100 customers whose number, name, email address or contact person matches the search text.

• Action
  Find employees by criteria

  Returns the employees that match the given criteria, such as name or personnel number, status, city or ZIP, supervisor or driving licence.

• Action
  Find invoices by criteria

  Returns up to 100 invoices that match the search text, statuses, date ranges, payment state, customer, order, service or object you specify.

• Action
  Find Subcontractor

  Returns up to 100 subcontractors whose number, name or other details match the search text.

• Action
  Get customer

  Returns a single customer by id, including contact details, address, email addresses, tax details, note and tags.

• Action
  Get order

  Returns a single order (Auftrag) by its id, including its object, status, dates, staffing requirements and services.

• Action
  Get prospect

  Returns a single prospect (lead) by its id, with address, contact details, outcome and contact persons.

• Action
  Get Quote

  Returns a single quote (Angebot) by its id, including its number, status, dates, customer or prospect, texts and line items.

• Action
  Get Supplier

  Returns a single supplier (Lieferant) by its id, with name, address, contact and tax details.

• Action
  Get time record

  Returns a single time record by its id, including its date, start and end times, breaks, employee and object.

• Action
  Update customer

  Updates an existing customer's name, address, contact details and email addresses. Fields left blank keep their current values.

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