Connect Outlook to Google Sheets

Both apps 110Outlook 48Google Sheets 62

• Trigger
  Calendar Event Changes

  Triggered when a new calendar event occurs (created, updated, or deleted) in the Outlook calendar.

• Trigger
  New Calendar Event

  Triggered when a new calendar event is created in the Outlook calendar.

• Trigger
  New Contact Added

  Triggered when a new contact is added in the Outlook contacts.

• Trigger
  New Outlook Message

  Triggered when a new message is received in the Outlook mailbox.

• Trigger
  New Sent Message

  Triggered when a new message is sent from the Outlook mailbox.

• Action
  Add Mail Attachment

  Tool to add an attachment to an email message. use when you have a message id and need to attach a small (<3 mb) file or reference.

• Action
  Create Calendar

  Tool to create a new calendar in the signed-in user's mailbox. use when organizing events into a separate calendar.

• Action
  Create Contact Folder

  Tool to create a new contact folder in the user's mailbox. use when needing to organize contacts into custom folders.

• Action
  Create Email Rule

  Create email rule filter with conditions and actions

• Action
  Create Mail Folder

  Tool to create a new mail folder. use when you need to organize email into a new folder.

• Action
  Create Master Category

  Tool to create a new category in the user's master category list. use after selecting a unique display name.

• Action
  Delete Mail Folder

  Delete a mail folder from the user's mailbox. use when you need to remove an existing mail folder.

• Action
  Download Outlook Attachment

  Downloads a specific file attachment from an email message in a microsoft outlook mailbox; the attachment must contain 'contentbytes' (binary data) and not be a link or embedded item.

• Action
  Get Mailbox Settings

  Tool to retrieve mailbox settings. use when you need to view settings such as automatic replies, time zone, and working hours for the signed-in or specified user.

• Action
  Get Mail Delta

  Tool to retrieve incremental changes (delta) of messages in a mailbox. use when syncing mailbox updates since last checkpoint.

• Action
  Get Mail Tips

  Tool to retrieve mail tips such as automatic replies and mailbox full status. use when you need to check recipient status before sending mail.

• Action
  Get Master Categories

  Tool to retrieve the user's master category list. use when you need to get all categories defined for the user.

• Action
  Get Supported Languages

  Tool to retrieve supported languages in the user's mailbox. use when you need to display or select from available mailbox languages.

• Action
  Get Supported Time Zones

  Tool to retrieve supported time zones in the user's mailbox. use when you need a list of time zones to display or choose from for event scheduling.

• Action
  List Calendars

  Tool to list calendars in the signed-in user's mailbox. use when you need to retrieve calendars with optional odata queries.

• Action
  List Event Attachments

  Tool to list attachments for a specific outlook calendar event. use when you have an event id and need to view its attachments.

• Action
  List Outlook Attachments

  Lists metadata (like name, size, and type, but not `contentbytes`) for all attachments of a specified outlook email message.

• Action
  List Reminders

  Tool to retrieve reminders for events occurring within a specified time range. use when you need to see upcoming reminders between two datetimes.

• Action
  Outlook Add Event Attachment

  Adds an attachment to a specific outlook calendar event. use when you need to attach a file or nested item to an existing event.

• Action
  Outlook Calendar Create Event

  Creates a new outlook calendar event, ensuring `start datetime` is chronologically before `end datetime`.

• Action
  Outlook Create Contact

  Creates a new contact in a microsoft outlook user's contacts folder.

• Action
  Outlook Create Draft

  Creates an outlook email draft with subject, body, recipients, and an optional attachment. supports creating drafts as part of existing conversation threads by specifying a conversationid; attachments require a name, mimetype, and content.

• Action
  Outlook Create Draft Reply

  Creates a draft reply in the specified user's outlook mailbox to an existing message (identified by a valid `message id`), optionally including a `comment` and cc/bcc recipients.

• Action
  Outlook Delete Contact

  Permanently deletes an existing contact, using its `contact id` (obtainable via 'list user contacts' or 'get contact'), from the outlook contacts of the user specified by `user id`.

• Action
  Outlook Delete Event

  Deletes an existing calendar event, identified by its unique `event id`, from a specified user's microsoft outlook calendar, with an option to send cancellation notifications to attendees.

• Action
  Outlook Get Contact

  Retrieves a specific outlook contact by its `contact id` from the contacts of a specified `user id` (defaults to 'me' for the authenticated user).

• Action
  Outlook Get Contact Folders

  Tool to retrieve a list of contact folders in the signed-in user's mailbox. use after authentication when you need to browse or select among contact folders.

• Action
  Outlook Get Event

  Retrieves the full details of a specific calendar event by its id from a user's outlook calendar, provided the event exists.

• Action
  Outlook Get Message

  Retrieves a specific email message by its id from the specified user's outlook mailbox. use the 'select' parameter to include specific fields like 'internetmessageheaders' for filtering automated emails.

• Action
  Outlook Get Profile

  Retrieves the microsoft outlook profile for a specified user.

• Action
  Outlook Get Schedule

  Retrieves free/busy schedule information for specified email addresses within a defined time window.

• Action
  Outlook List Contacts

  Retrieves a user's microsoft outlook contacts, from the default or a specified contact folder.

• Action
  Outlook List Events

  Retrieves events from a user's outlook calendar via microsoft graph api, supporting pagination, filtering, property selection, sorting, and timezone specification.

• Action
  Outlook List Mail Folders

  Tool to list a user's top-level mail folders. use when you need folders like inbox, drafts, sent items; set include hidden folders=true to include hidden folders.

• Action
  Outlook List Messages

  Retrieves a list of email messages from a specified mail folder in an outlook mailbox, with options for filtering (including by conversationid to get all messages in a thread), pagination, and sorting; ensure 'user id' and 'folder' are valid, and all date/time strings are in iso 8601 format.

• Action
  Outlook Move Message

  Move a message to another folder within the specified user's mailbox. this creates a new copy of the message in the destination folder and removes the original message.

• Action
  Outlook Reply Email

  Sends a plain text reply to an outlook email message, identified by `message id`, allowing optional cc and bcc recipients.

• Action
  Outlook Search Messages

  Searches messages in a microsoft 365 or enterprise outlook account mailbox, supporting filters for sender, subject, attachments, pagination, and sorting by relevance or date.

• Action
  Outlook Send Email

  Sends an email with subject, body, recipients, and an optional attachment via microsoft graph api; attachments require a non-empty file with valid name and mimetype.

• Action
  Outlook Update Calendar Event

  Updates specified fields of an existing outlook calendar event.

• Action
  Outlook Update Contact

  Updates an existing outlook contact, identified by `contact id` for the specified `user id`, requiring at least one other field to be modified.

• Action
  Outlook Update Email

  Updates specified properties of an existing email message; `message id` must identify a valid message within the specified `user id`'s mailbox.

• Action
  Update Mailbox Settings

  Tool to update mailbox settings for the signed-in user. use when you need to configure automatic replies, default time zone, language, or working hours. example: schedule automatic replies for vacation.

• Trigger
  Aggregate Metric Changed

  Fires when an aggregate metric (sum/avg/count/…) over a column changes. Managed by Composio (~15 min floor).

• Trigger
  Cell Range Values Changed

  Fires when the values in a specific cell range change. Managed by Composio (~15 min floor).

• Trigger
  Conditional Format Rule Changed

  Fires when a conditional-format rule changes. Managed by Composio (~15 min floor).

• Trigger
  Data Validation Rule Changed

  Fires when a data-validation rule changes. Managed by Composio (~15 min floor).

• Trigger
  Developer Metadata Changed

  Fires when developer metadata changes. Managed by Composio (~15 min floor).

• Trigger
  Filtered Range Values Changed

  Fires when the values in a filtered range change. Managed by Composio (~15 min floor).

• Trigger
  New Rows

  Fires when new rows are appended to a Google Sheet. Managed by Composio (server-side poll; ~15 min floor).

• Trigger
  New Sheet Added

  Fires when a new sheet (tab) is added to a spreadsheet. Managed by Composio (~15 min floor).

• Trigger
  New Spreadsheet Created

  Fires when a new spreadsheet is created in the account. Managed by Composio (~15 min floor).

• Trigger
  Spreadsheet Metadata Changed

  Fires when spreadsheet metadata changes. Managed by Composio (~15 min floor).

• Trigger
  Spreadsheet Properties Changed

  Fires when spreadsheet properties change. Managed by Composio (~15 min floor).

• Trigger
  Spreadsheet Row Changed

  Fires when a row matching a query changes. Managed by Composio (~15 min floor).

• Trigger
  Spreadsheet Search Match

  Fires when a spreadsheet matching search criteria is found. Managed by Composio (~15 min floor).

• Trigger
  Table Query Result Changed

  Fires when the result of a SQL-style table query changes. Managed by Composio (~15 min floor).

• Trigger
  Table Schema Changed

  Fires when a table's column schema changes. Managed by Composio (~15 min floor).

• Trigger
  Worksheet Names Changed

  Fires when worksheet (tab) names change. Managed by Composio (~15 min floor).

• Action
  Add Row

  Append a row to a Google Sheet

• Action
  Aggregate Column Data

  Read a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).

• Action
  Auto-Resize Rows or Columns

  Auto-fit row heights or column widths over an index range via autoResizeDimensions.

• Action
  Change Sheet Properties

  Update a worksheet's grid properties (row/column count) using an explicit field mask.

• Action
  Clear Basic Filter

  Remove the basic filter from a sheet via clearBasicFilter.

• Action
  Clear Spreadsheet Row(s)

  Clear the values in a range (formatting preserved).

• Action
  Copy Range

  Copy a source cell range to a destination range within the spreadsheet.

• Action
  Copy Worksheet

  Copy a worksheet into a destination spreadsheet.

• Action
  Create Chart

  Add a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.

• Action
  Create Conditional Formatting Rule

  Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.

• Action
  Create Multiple Spreadsheet Rows

  Append many rows in one call.

• Action
  Create Spreadsheet

  Create a new Google Sheets spreadsheet with the given title.

• Action
  Create Spreadsheet Column

  Insert a blank column at a given index.

• Action
  Create Spreadsheet Row

  Append a single row of values to a sheet range.

• Action
  Create Spreadsheet Row at Top

  Insert a blank row just below the header (row 2), then write the given values into it in one operation.

• Action
  Create Worksheet

  Add a new worksheet (tab) to an existing spreadsheet.

• Action
  Delete Chart

  Delete an embedded chart via deleteEmbeddedObject.

• Action
  Delete Sheet

  Delete a worksheet from a spreadsheet by sheetId (gid).

• Action
  Delete Spreadsheet Row(s)

  Delete a contiguous block of rows by index.

• Action
  Find and Replace

  Find and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).

• Action
  Find Spreadsheet

  Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).

• Action
  Find Worksheet

  Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.

• Action
  Format Cell Range

  Apply background color and bold formatting to a cell range via repeatCell.

• Action
  Format Spreadsheet Row

  Apply a background color across an entire row via repeatCell over a row range.

• Action
  Get Conditional Format Rules

  List all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).

• Action
  Get Data Range

  Read all values in a range.

• Action
  Get Data Validation Rules

  Read the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).

• Action
  Get Many Spreadsheet Rows (Advanced)

  Read multiple ranges at once via batchGet.

• Action
  Get Row by ID

  Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.

• Action
  Get Sheet Names

  Return the titles of all sheets (tabs) in the spreadsheet.

• Action
  Get Spreadsheet by ID

  Fetch spreadsheet metadata (title, sheets, gids, grid properties).

• Action
  List Charts

  List all embedded charts (chartId + title) across every sheet in the spreadsheet.

• Action
  Lookup Spreadsheet Row

  Read a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Lookup Spreadsheet Rows (Advanced)

  Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Move Chart

  Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.

• Action
  Rename Sheet

  Rename a worksheet's title.

• Action
  Search Spreadsheets

  Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.

• Action
  Set Basic Filter

  Apply a basic filter to a range on a sheet via setBasicFilter.

• Action
  Set Data Validation

  Apply a ONE_OF_LIST dropdown data-validation rule to a cell range.

• Action
  Sort Range

  Sort a cell range by one column in ascending or descending order.

• Action
  Update Chart

  Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.

• Action
  Update Conditional Format Rules

  Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.

• Action
  Update Data Validation Rule

  Overwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).

• Action
  Update Spreadsheet Row

  Overwrite the values at a specific range.

• Action
  Update Spreadsheet Row(s)

  Update one or more disjoint ranges in a single batch.

• Action
  Upsert Row

  Read a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).

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