Connect Gemini CLI to the Smartsheet MCP server

With Gemini CLI connected to the Smartsheet MCP server, you can interact with your Smartsheet data using natural language.

Required plan: Business, Enterprise, or Advanced Work Management

Connection steps

With Gemini CLI, you can configure an MCP server connection for a local project or your user.

For options on configuring MCP server connections (including connection scope), please refer to the Gemini CLI documentation.

This is the simplest way to connect for a session.

Execute the following command, with your values:
```
gemini mcp add \
  -t http \
  -H "Authorization:Bearer ${SMARTSHEET_API_TOKEN}" \
  smartsheet-mcp https://mcp.smartsheet.com
```
Replace:
- ${SMARTSHEET_API_TOKEN} with the environment variable for your Smartsheet API token.
- smartsheet-mcp with a name you're using for the connection.
- The URL with your region's URL, if you're using a regional server outside the US.
Verify your server connection:
```
gemini mcp list 
```
The Smartsheet MCP server appears in the list, and its status is Connected or Running.
Test the MCP server connection with a prompt.
```
List the Smartsheet MCP server tools.
```
The response includes Smartsheet tools such as get_sheet_summary and more.

You've connected Gemini CLI to the Smartsheet MCP server for your project.

The connection persists within the folder where you've invoked it. The hidden folder ./gemini/ contains your configuration.

Here's how to configure the MCP server for use anywhere on your machine.

Edit ~/.gemini/settings.json and add an mcpServers section like the one below:
```
{
  "mcpServers": {
    "smartsheet-mcp": {
      "httpUrl": "https://mcp.smartsheet.com",
      "headers": {
        "Authorization": "Bearer ${SMARTSHEET_API_TOKEN}"
      }
    }
  }
}
```
Replace:
- smartsheet-mcp with a name you're using for the connection.
- ${SMARTSHEET_API_TOKEN} with the environment variable for your Smartsheet API token.
- httpUrl value with your region's URL
Verify your server connection:
```
gemini mcp list 
```
The Smartsheet MCP server appears in the list, and its status is Connected or Running.
Test the MCP server connection with a prompt.
```
List the Smartsheet MCP server tools.
```
The response includes Smartsheet tools such as get_sheet_summary and more.

You've connected Gemini CLI to the Smartsheet MCP server for your user.

Now that you've connected to the Smartsheet MCP server, you can interact with your Smartsheet data in a conversational way.

Check out the example prompts in Smartsheet MCP prompt cookbook.

Want to learn more about the MCP server's capabilities? Visit Smartsheet MCP server tools.