Access Smartsheet in Gemini Enterprise Plus

Access your Smartsheet data along with data from your Google apps and more, using the Smartsheet Connector for Gemini Enterprise Plus.

Who can use this?

Plans:

  • Business
  • Enterprise

Using the Smartsheet Connector for Gemini Enterprise Plus, you can bring Smartsheet workflows into Gemini Enterprise to streamline project oversight. Scan for overdue items, find bottlenecks, and generate portfolio reports.

Currently, the Smartsheet Connector for Gemini Enterprise Plus supports only read-only operations on Smartsheet data. Also, the Smartsheet Connector provides access to many of the Smartsheet MCP server tools, but the latest tools are not yet available to Gemini Enterprise Plus.

You can use Gemini's Deep Research Mode to draw key information from sheets, reports, and dashboards in your workspaces and construct comprehensive reports complete with source citations.

The following sections describe the prerequisites for using the Smartsheet Connector and demonstrate how to configure the Smartsheet Connector in Gemini Enterprise Plus.

Prerequisites

AI and MCP server access are enabled for Smartsheet organizations by default. Unless your Smartsheet system admin disabled AI or MCP server access, you're ready to configure the connector.

As a Gemini Enterprise Plus user, the following items are required for you to use the Smartsheet Connector in Gemini Enterprise Plus:

  • Your Google system admin must configure a Gemini Enterprise connector, connected to the Smartsheet MCP Server. Refer your Google system admin to configure the Smartsheet Connector in Gemini Enterprise Plus.
  • Gemini Enterprise Plus license
  • You must have the Discovery Engine User role in the Gemini Enterprise connector's Google Cloud Project.
  • Smartsheet Business, Enterprise, or Advanced Work Management plan
  • AI and MCP server access must not be disabled in Smartsheet for your organization. Note: AI and MCP server access are enabled by default.

Connect to Smartsheet

The following steps demonstrate how to enable the Smartsheet MCP Connector in Gemini Enterprise Plus.

  1. Go to Gemini Enterprise Plus (Google Cloud).
  2. Below the prompt box, select the Connectors icon (a database icon). Then, find the connector that your Google system admin created for the Smartsheet MCP Server. The data store created by your Google system admin appears as a connector in the Gemini Enterprise Plus assistant. 

    If you need the data store name, contact your Google system admin who configured the Smartsheet Connector in Gemini Enterprise Plus.
  3. Select the Authorize link next to the connector name. 
  4. In the authorization window, select Allow when you're ready to access Smartsheet via Gemini Enterprise Plus. After you allow access, Gemini Enterprise Plus returns you to the prompt page.

Gemini Enterprise Plus is connected to the Smartsheet MCP server and is ready for you to interact with Smartsheet using natural language.

What's next?

By integrating your Gemini Enterprise Plus with Smartsheet using the Smartsheet Connector, you can query your Smartsheet data in natural language.

Check out the Smartsheet MCP prompt cookbook. It has over 100 prompts to help you get started using Smartsheet in Gemini Enterprise Plus.