Skip to main content
Book a demo

Connect Google Sheets to Microsoft 365 Copilot

Give Microsoft 365 Copilot governed access to Google Sheets’s 21 tools through Runlayer, with identity, policy, scanning, and audit on every call.

Book a demo Microsoft 365 Copilot setup guide

Set up

Add Google Sheets to Microsoft 365 Copilot in four steps

Admins approve the server once. Everyone in Microsoft 365 Copilot then gets it through the same governed connection.

  1. 1

    Approve Google Sheets in Runlayer

    Add Google Sheets from the catalog and choose who can use it and which of its tools are allowed.

  2. 2

    Connect Microsoft 365 Copilot to Runlayer

    Users add the Runlayer Plugin to Microsoft 365 Copilot by following Runlayer’s setup guide. Microsoft 365 Copilot reaches Google Sheets’s 21 tools through the Runlayer Plugin’s search and execute tools instead of listing each one.

    Microsoft 365 Copilot setup guide
  3. 3

    Sign in to Google Sheets

    Sign in the way Google Sheets requires. Runlayer holds the credentials so they stay out of the client’s configuration.

  4. 4

    Use Google Sheets from Microsoft 365 Copilot

    Google Sheets’s approved tools appear in Microsoft 365 Copilot. Every call is checked against policy and recorded.

Tools

21 Google Sheets tools in Microsoft 365 Copilot

Runlayer policy decides which of these Microsoft 365 Copilot users can call. 4 read data only and 4 can change or delete data.

  • Add sheet

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

  • Append

    Append data to a spreadsheet.

  • Autofill

    Extend a formula or detected series from a source range into a larger destination range (like dragging the fill handle).

  • Clear

    Clear the values in a range while leaving the rows, columns, and formatting in place.

  • Clear filter

    Remove a sheet's filter, restoring any rows it was hiding.

  • Create

    Create a new spreadsheet.

  • Create filter

    Turn on filtering over a range of a sheet (the funnel button in the Sheets UI), so rows can be sorted and filtered by column.

  • Delete rows

    Delete rows from a sheet, shifting the rows below them up.

See all 21 Google Sheets tools

Control

What Runlayer can see and stop in Microsoft 365 Copilot

Some controls apply to every client at the gateway. Others depend on what Microsoft 365 Copilot exposes to Runlayer.

  • Gateway policy (available)

    Every Google Sheets call from Microsoft 365 Copilot passes through Runlayer, where your policies can allow, alert, mask, or block it.

  • Audit trail (available)

    Each call is recorded with the user, Microsoft 365 Copilot as the client, the tool, and the policy and scanner decisions.

  • Managed browser extension (available)

    Managed Chrome, Edge, and Firefox deployments can monitor supported web-chat activity and apply prompt-time controls where the surface permits it.

  • Native enforcement adapter (not available)

    Runlayer has no device-side adapter for Microsoft 365 Copilot yet, so control happens at the gateway.

Frequently asked questions

Connect more

Find another combination