Connect Avaza to Microsoft Excel

Both apps 170Avaza 72Microsoft Excel 98

• Trigger
  Company Updated

  Triggers when a company is updated in Avaza, delivering a snapshot of the company.

• Trigger
  Contact Updated

  Triggers when a contact is updated in Avaza.

• Trigger
  Estimate Deleted

  Triggers when an estimate (quote) is deleted in Avaza.

• Trigger
  Estimate Updated

  Triggers when an estimate (quote) is updated in Avaza.

• Trigger
  Expense Deleted

  Triggers when an expense is deleted in Avaza.

• Trigger
  Expense Updated

  Triggers when an expense is updated in Avaza.

• Trigger
  Invoice Sent

  Triggers when an invoice is sent (or marked as sent) in Avaza.

• Trigger
  Invoice Update

  Triggers when an invoice is updated in Avaza.

• Trigger
  New Bill Created

  Triggers when a new supplier bill is created in Avaza.

• Trigger
  New Company

  Triggers when a new company is created in Avaza.

• Trigger
  New Contact

  Triggers when a new contact is created in Avaza.

• Trigger
  New Estimate Created

  Triggers when a new estimate (quote) is created in Avaza.

• Trigger
  New Expense Created

  Triggers when a new expense is created in Avaza.

• Trigger
  New Invoice Created

  Triggers when a new invoice is created in Avaza.

• Trigger
  New Project

  Triggers when a new project is created in Avaza.

• Trigger
  New Schedule Series Created

  Triggers when a schedule series (a project booking or leave) is created in Avaza.

• Trigger
  New Task Created

  Triggers when a new task is created in Avaza.

• Trigger
  New Timesheet Entry

  Triggers when a timesheet entry is created in Avaza.

• Trigger
  Project Updated

  Triggers when a project is updated in Avaza.

• Trigger
  Schedule Series Deleted

  Triggers when a schedule booking or leave series is deleted in Avaza.

• Trigger
  Schedule Series Updated

  Triggers when a schedule series (a project booking or leave) is updated in Avaza.

• Trigger
  Task Deleted

  Triggers when a task is deleted in Avaza.

• Trigger
  Task Updated

  Triggers when a task is updated in Avaza.

• Trigger
  Timesheet Entry Deleted

  Triggers when a timesheet entry is deleted in Avaza.

• Trigger
  Timesheet Entry Updated

  Triggers when a timesheet entry is updated in Avaza.

• Action
  Create Bill

  Creates a new draft supplier bill in Avaza, optionally creating the supplier company and contact if no match is found.

• Action
  Create Bill Payment

  Records a payment made to a supplier, optionally allocating it against one or more bills.

• Action
  Create Company

  Creates a new customer company in Avaza with billing address, contact details and custom field values.

• Action
  Create Contact

  Creates a new contact in Avaza, optionally linked to an existing or new company.

• Action
  Create Estimate / Quote

  Creates a new draft estimate (quote) for a customer, optionally creating the customer company and contact if no match is found.

• Action
  Create Expense

  Creates a new expense entry in Avaza for a user, with a date, amount and expense category, optionally linked to a customer, project or task.

• Action
  Create Invoice

  Creates a new draft invoice for a customer company, with line items. Can create the customer company and contact if no matching company is found.

• Action
  Create Invoice Payment

  Records a customer payment in Avaza, optionally allocating it against one or more invoices.

• Action
  Create Project

  Creates a new project in Avaza under an existing customer company, or under a new company created from the name you give.

• Action
  Create Schedule Booking

  Creates a project work schedule booking for a user over a date range, with hours per day or a total duration.

• Action
  Create Section

  Creates a new section (task group) within an Avaza project.

• Action
  Create Task

  Creates a new task in an Avaza project section, optionally assigning users, dates, priority, effort, tags and custom field values.

• Action
  Create Timesheet Entry

  Creates a timesheet entry in an Avaza project, or starts a timer when no duration is given.

• Action
  Delete Estimate

  Deletes an estimate (quote) in Avaza. Estimates converted to an invoice cannot be deleted.

• Action
  Delete Schedule or Leave Series

  Deletes a schedule booking or leave series, along with all of its daily schedule assignments.

• Action
  Delete Section

  Deletes a section (task group) from a project. Sections that still contain tasks cannot be deleted.

• Action
  Delete Task

  Deletes a task, along with its subtasks and comments, from an Avaza project.

• Action
  Delete Timesheet

  Deletes a timesheet entry in Avaza by its Timesheet Entry ID.

• Action
  Get Bill

  Returns a single supplier bill by its ID, including line items, supplier and recipient address details, amounts, status and web links.

• Action
  Get Contact

  Returns a single external contact by its Contact ID, including company, contact details, roles and custom field values.

• Action
  Get Estimate

  Returns a single estimate (quote) by its ID, including line items, status, amounts, issuer/recipient details and web links.

• Action
  Get Project

  Returns a project's full details, including its sections, team members, tags and custom field values.

• Action
  Lookup Company

  Finds companies in Avaza whose name matches the search text and returns their IDs and names.

• Action
  Lookup Expense Category

  Finds an expense category in your Avaza account by its name and returns its id and unit price settings.

• Action
  Lookup Project

  Finds active projects by title, project code, or customer company and returns their ids, codes and titles.

• Action
  Lookup Project Timesheet Category

  Looks up the timesheet categories assigned to a project, optionally matching one by name.

• Action
  Lookup Task

  Returns a task by its ID, including project, section, assignees, dates, status, priority, tags, time tracking and custom field values.

• Action
  Lookup User

  Finds Avaza users (team members and customer contacts) by email address, with optional filters for role, tag and company. Returns the first match and the full list of matches.

• Action
  Mark Invoice as Sent

  Flags a draft invoice as Sent without emailing it to the customer.

• Action
  Reterive Task Comments

  Returns the comments and discussion messages on an Avaza task, including replies, attachments and system messages.

• Action
  Search Expenses

  Returns expense entries matching a search on merchant or category name, with optional filters for date range, user, customer, project, chargeable/invoiced status and approval status.

• Action
  Search Invoice

  Searches invoices by status, customer company, issue date, due date or last-updated date, and returns the matching invoices with their line items.

• Action
  Search Project

  Searches projects by title, company, category, owner, status, billing or budget type, tags and dates, and returns the matching projects.

• Action
  Search Task

  Searches tasks, filtering by project, section parent, status, priority, due date range, assigned user, completion state and last-updated date.

• Action
  Search Timesheets

  Searches timesheet entries, filtered by date range, user, project, customer, task, category, billable/invoiced and approval status.

• Action
  Stop Timer

  Stops the running timer on an existing timesheet entry, adding the elapsed time to its duration.

• Action
  Update Company

  Updates an existing Avaza company. Only the fields named in Fields To Update are changed.

• Action
  Update Contact

  Updates an existing customer contact in Avaza — name, email, phone, mobile, position title, time zone, portal roles and custom field values. Only the fields you fill in are changed.

• Action
  Update Estimate

  Updates an existing draft or sent estimate (quote) in Avaza, changing only the fields you list. Accepted, converted or void estimates cannot be updated.

• Action
  Update Expense

  Updates an existing Avaza expense entry. Only the fields you list in Fields To Update are changed.

• Action
  Update Invoice

  Updates an existing draft invoice in Avaza. Only the fields you list in Fields To Update are changed.

• Action
  Update Project

  Updates an existing Avaza project. Only the fields named in Fields To Update are changed.

• Action
  Update Project Member

  Updates a project member's rates, budget, or permissions on an Avaza project. Only the fields named in Fields To Update are changed.

• Action
  Update Project Timesheet Category

  Updates a timesheet category's settings on a project, such as billable status, hourly rate, cost rate and budget hours.

• Action
  Update Schedule Booking

  Updates an existing project work schedule booking in Avaza, such as its user, project, dates or hours.

• Action
  Update Task

  Updates an existing Avaza task. Only the fields you fill in are changed; blank fields keep their current values.

• Action
  Update Timesheet Entry

  Updates an existing timesheet entry in Avaza, changing only the fields you list as fields to update.

• Action
  Add Chart

  Add a chart to a worksheet using microsoft graph api.

• Action
  Add Named Item

  Add Named Item

• Action
  Add Sharepoint Worksheet

  Add a new worksheet to a sharepoint excel workbook using microsoft graph sites api.

• Action
  Add Table

  Create a table over a range in an Excel workbook.

• Action
  Add Table Column

  Add a column to a table using microsoft graph api.

• Action
  Add Table Row

  Add a row to a table using microsoft graph api.

• Action
  Add Workbook Permission

  Tool to grant access to a workbook via invite. use when you need to share a specific workbook file with designated recipients and roles.

• Action
  Add Worksheet

  Add a new worksheet to an excel workbook using microsoft graph api.

• Action
  Apply Table Filter

  Apply a filter to a table column using microsoft graph api.

• Action
  Apply Table Sort

  Apply a sort to a table using microsoft graph api.

• Action
  Autofit Range

  Autofit columns or rows intersecting a workbook range.

• Action
  Calculate Function

  Run one allowlisted Microsoft Graph v1.0 workbook function.

• Action
  Calculate Workbook

  Calculate Excel Workbook

• Action
  Clear Range

  Tool to clear values, formats, or contents in a specified worksheet range. use when you need to reset cells before adding new data.

• Action
  Clear Table Filter

  Clear a filter from a table column using microsoft graph api.

• Action
  Clear Table Filters

  Clear All Table Filters

• Action
  Clear Table Sort

  Clear Table Sort

• Action
  Close Session

  Tool to close an existing excel workbook session. use when you need to explicitly end a persistent session to release workbook locks.

• Action
  Convert Table To Range

  Convert a table to a range using microsoft graph api.

• Action
  Copy Drive Item

  Create a non-destructive asynchronous copy of a file or folder. Metadata and permissions are not copied; the new item inherits destination-folder permissions. Version history is copied only when explicitly requested.

• Action
  Create Folder

  Create a folder under a parent Microsoft Graph drive item.

• Action
  Create Workbook

  Create an .xlsx workbook in the user's OneDrive, from a file URL or blank.

• Action
  Delete Named Item

  Permanently delete a workbook-scoped named item; this cannot be undone.

• Action
  Delete Range

  Delete worksheet cells and shift the remaining cells up or left.

• Action
  Delete Table

  Permanently delete an Excel table by its ID or name.

• Action
  Delete Table Column

  Delete a column from a table using microsoft graph api.

• Action
  Delete Table Row

  Delete a row from a table using microsoft graph api.

• Action
  Delete Worksheet

  Tool to delete a worksheet from the workbook. use when cleaning up unused or temporary sheets after verifying no dependencies exist. example: "delete 'sheet2' after review."

• Action
  Export Workbook To Pdf

  Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion. Use when you need a PDF version of an Excel file for sending, storing, or attaching.

• Action
  Get Application

  Get Excel Application

• Action
  Get Chart

  Get chart

• Action
  Get Chart Axis

  Tool to retrieve a specific axis from a chart. use when you need properties like min, max, interval, and formatting of the chart axis.

• Action
  Get Chart Component

  Get chart component

• Action
  Get Chart Data Labels

  Tool to retrieve the data labels object of a chart. use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.

• Action
  Get Chart Image

  Get chart image

• Action
  Get Chart Legend

  Tool to retrieve the legend object of a chart. use after creating or updating a chart when you need to inspect legend visibility and formatting.

• Action
  Get Chart Point

  Get chart point

• Action
  Get Chart Series

  Get chart series

• Action
  Get Derived Range

  Return a range derived from another range by navigation or geometry.

• Action
  Get Named Item

  Retrieve a workbook-scoped named item by exact name.

• Action
  Get Named Item Range

  Get Named Item Range

• Action
  Get Range

  Get a range from a worksheet using microsoft graph api.

• Action
  Get Range Format

  Read one formatting component from a workbook range.

• Action
  Get Session

  Create a session for an excel workbook using microsoft graph api.

• Action
  Get Sharepoint Range

  Get a range from a worksheet in sharepoint using microsoft graph sites api.

• Action
  Get Sharepoint Worksheet

  Get a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api.

• Action
  Get Table

  Retrieve one workbook- or worksheet-addressed table by ID or exact name.

• Action
  Get Table Column

  Tool to retrieve a specific column from a workbook table. use when you need to fetch column properties and data by its id or name.

• Action
  Get Table Column Range

  Get Table Column Range

• Action
  Get Table Range

  Get Table Range

• Action
  Get Table Row

  Get Table Row

• Action
  Get Table Row Range

  Get Table Row Range

• Action
  Get Table Sort

  Get Table Sort

• Action
  Get Visible Range

  Read cells visible after worksheet filtering.

• Action
  Get Workbook

  Tool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets.

• Action
  Get Worksheet

  Get a worksheet by name or id from an excel workbook using microsoft graph api.

• Action
  Get Worksheet Protection

  Get Worksheet Protection

• Action
  Get Worksheet Used Range

  Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps filter out formatting-only cells.

• Action
  Insert Range

  Tool to insert a new cell range into a worksheet, shifting existing cells down or right. use when you need to create space for new content without overwriting.

• Action
  List Chart Points

  List chart points

• Action
  List Charts

  List charts in a worksheet using microsoft graph api.

• Action
  List Chart Series

  Tool to list all data series in a chart. use when you need to enumerate chart series for further analysis.

• Action
  List Comments

  Tool to list comments in an excel workbook. use when you need to retrieve all workbook comments via microsoft graph api.

• Action
  List Drive Item Children

  Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId. Returns an array of child DriveItems with stable identifiers and pagination support.

• Action
  List Files

  List files and folders in a drive root or specified path.

• Action
  List Named Items

  List named items in a workbook using microsoft graph api.

• Action
  List Sharepoint Tables

  List tables in a sharepoint worksheet using microsoft graph sites api.

• Action
  List Sharepoint Worksheets

  List worksheets in an excel workbook stored in sharepoint using microsoft graph sites api.

• Action
  List Table Columns

  List columns in a table using microsoft graph api.

• Action
  List Table Rows

  List rows in a table using microsoft graph api.

• Action
  List Tables

  List tables in a worksheet using microsoft graph api.

• Action
  List Workbook Permissions

  Tool to list permissions set on the workbook file. use when you need to see which users or links have access to a specific excel file by supplying its drive and item ids. example: "list permissions for workbook with drive id 'b!abc123' and item id '0123456789abcdef'."

• Action
  List Worksheets

  List worksheets in an excel workbook using microsoft graph api.

• Action
  Merge Cells

  Merge cells in a worksheet range using microsoft graph api.

• Action
  Protect Worksheet

  Tool to protect a worksheet using optional protection options. use when you need to prevent editing certain parts of a sheet before sharing. example: "protect 'sheet1' to lock formatting and sorting."

• Action
  Reapply Table Filters

  Reapply All Table Filters

• Action
  Reapply Table Sort

  Reapply Table Sort

• Action
  Refresh Session

  Refresh Excel Session

• Action
  Search Files

  Tool to search OneDrive drive items by query to discover Excel workbook IDs. Use when you need to find Excel files by name before performing workbook operations.

• Action
  Search Microsoft 365 Content

  Search OneDrive and SharePoint content using Microsoft Search.

• Action
  Set Chart Data

  Set chart data

• Action
  Set Chart Position

  Set chart position

• Action
  Sort Range

  Sort a range in a worksheet using microsoft graph api.

• Action
  Unmerge Range

  Split a merged worksheet range back into separate cells.

• Action
  Unprotect Worksheet

  Remove protection from a worksheet so it can be edited again.

• Action
  Update Chart

  Update a chart in a worksheet using microsoft graph api.

• Action
  Update Chart Component

  Update chart component

• Action
  Update Chart Legend

  Tool to update formatting or position of a chart legend. use when adjusting legend settings after confirming chart and worksheet exist.

• Action
  Update Chart Series

  Rename one Excel chart series by ID or zero-based collection position.

• Action
  Update Named Item

  Update a workbook named item's visibility or comment.

• Action
  Update Range

  Update a range in a worksheet using microsoft graph api.

• Action
  Update Range Format

  Update exactly one formatting component on a workbook range.

• Action
  Update Sharepoint Range

  Update a range in a sharepoint worksheet using microsoft graph sites api.

• Action
  Update Table

  Update a table in a workbook using microsoft graph api.

• Action
  Update Table Column

  Update Table Column

• Action
  Update Table Row

  Update Table Row

• Action
  Update Worksheet

  Update worksheet properties (name, position) in an excel workbook using microsoft graph api.

• Action
  Upload Workbook

  Tool to upload an external Excel file from a URL into OneDrive/SharePoint. Downloads the file server-side and uploads it to the specified drive location, returning the driveItem metadata for subsequent Excel operations.

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