Google Sheets

Google Sheets is Google's online spreadsheet app, part of Google Workspace. Teams use it to collect, calculate, and analyze data together, with formulas, charts, pivot tables, and real-time collaboration.

With the Google Sheets integration, you can ask about the totals, trends, or outliers in a spreadsheet, then fill in cells, adjust formulas, add a chart, or reorganize sheets from Omnifact without opening the spreadsheet yourself. Users sign in with their own Google account and only see and change spreadsheets they have access to in Google Sheets.

Google offers this integration as a preview. It may change, and your organization may need to enroll with Google before using it.

Provided by
Google
Access
Users sign in with their own Google Sheets account and only see resources they have access to.
Connects to
https://sheetsmcp.googleapis.com/mcp/v1
Product website
workspace.google.com

What you can do

  • Ask about your data

    Read the sheets and values of a spreadsheet and ask about totals, trends, or outliers.

  • Update values and formulas

    Fill in cells, write or adjust formulas, and find and replace text across a sheet.

  • Organize sheets

    Add, duplicate, rename, or remove sheets and insert or move rows and columns.

  • Add charts

    Create a chart from a range of data or update an existing chart.

  • Format cells

    Apply text styles, colors, borders, and conditional formatting, and adjust row heights and column widths.

What to know before
using Google Sheets with Omnifact

Use cases, setup, and permissions when your team connects Google Sheets to Omnifact.

What can Omnifact do with Google Sheets?

Omnifact reads a spreadsheet, answers questions about its numbers, and updates it in the same conversation. Finance gets monthly totals per cost center, operations has duplicate rows cleaned out of an export, and a sales manager gets a weekly summary from the pipeline sheet. Omnifact works with the spreadsheet live, so you never paste data into the chat.

Can I ask questions about the numbers in a Google Sheets spreadsheet?

Yes. Ask for totals, trends, or outliers, for example which cost center is over budget, which month had the most returns, or how two tabs compare. Omnifact reads the sheets and answers in plain language. Because it fetches the data when you ask, the answer always reflects the current state of the spreadsheet.

Can Omnifact write and fix formulas in Google Sheets?

Yes. Describe what you need, such as a running total, a lookup across two tabs, or a sum per category, and Omnifact writes the formula into the right cell. It can also fix a formula that returns the wrong result or fill a whole column. Anyone who knows what the sheet should show, but not the exact formula, gets there in one request.

Which Google Sheets spreadsheets can Omnifact see?

Exactly the spreadsheets you can already open in Google Sheets, including ones shared with you. Everyone signs in with their own Google account, so Omnifact works with each person's own permissions and never through a shared admin account. You can disconnect your Google account from Omnifact at any time.

Does Omnifact ask before changing a Google Sheets spreadsheet?

Yes. By default, updating cells, writing formulas, or removing a sheet waits for your confirmation in the chat, so you review every change before it lands in a spreadsheet your team relies on. Reading and analyzing run right away. Admins decide which actions are allowed or need confirmation.

How does Omnifact handle Google Sheets data?

Your Google Sheets content stays in Google Sheets under your agreement with Google. Omnifact reads spreadsheets live when a request needs them, instead of copying or indexing your spreadsheets in advance, and what it reads becomes part of that conversation. Omnifact is operated in Germany, business data is not used to train the connected AI models, and admins can limit Omnifact to European or Europe-hosted models.

How do I connect Google Sheets to Omnifact?

Your IT team first sets up a one-time connection in Google. Google currently offers this through an early access program that your organization joins. An Omnifact admin then adds Google Sheets once for the whole organization, and everyone signs in with their own Google account.

Ready to automate work across your tools with Omnifact?

Connect Google Sheets and the other tools your team already uses, and let Omnifact look up information and take care of everyday tasks.

GDPR Compliant
ISO 27001 Certified
Hosted in Germany