Connect Claude to Sheets and Notion via MCP for read/write access to your spreadsheets and docs.

Your Spreadsheets and Docs Inside Claude

GA4 and BigQuery are where your raw data lives. But Google Sheets and Notion are where your team actually works — tracking campaigns, logging decisions, maintaining content calendars, and building reports. If Claude can't read and write to these tools, you're still the copy-paste middleman.

In this lesson, we'll connect Claude to both Google Sheets and Notion so it can read your existing data, update cells, create new pages, and keep your team's documentation in sync — all from a single conversation.

Manual Workflow

Export analytics data, open Google Sheets, paste and format the data, switch to Notion, manually update the campaign log, notify the team — 30 minutes of copy-paste every reporting cycle.

With AI

Ask Claude: 'Update the weekly metrics sheet with this week's GA4 data and add a summary to our Notion campaign log.' Claude reads, writes, and updates both tools directly.

Time saved: 30 minutes per cycle

Setting Up Google Sheets MCP

Add the Google Sheets MCP server to your Claude Desktop configuration. This uses the same service account you created for GA4, so if you followed the previous lesson, you already have the credentials.

claude_desktop_config.json (add to mcpServers)json

{
  "google-sheets": {
    "command": "npx",
    "args": ["-y", "@anthropic/mcp-google-sheets"],
    "env": {
      "GOOGLE_APPLICATION_CREDENTIALS": "/path/to/service-account.json"
    }
  },
  "notion": {
    "command": "npx",
    "args": ["-y", "@anthropic/mcp-notion"],
    "env": {
      "NOTION_API_KEY": "ntn_your_integration_token"
    }
  }
}

Share with Service Account

For Google Sheets, you need to share each spreadsheet with your service account email (it looks like mcp-reader@your-project.iam.gserviceaccount.com). Open the spreadsheet, click Share, and add the service account email with Editor access if you want Claude to write, or Viewer if read-only is sufficient.

Notion: Create an Integration

Go to notion.so/my-integrations and create a new internal integration. Give it a descriptive name like 'Claude MCP' and copy the API token. Then, in each Notion page or database you want Claude to access, click the three-dot menu and select 'Connect to' your integration. Claude can only see pages you explicitly share.

Pro Tip

Only share specific pages and databases with your Notion integration — not your entire workspace. This gives you granular control over what Claude can see and prevents accidental access to sensitive documents.

Prompt Example

claude

Claude reads your spreadsheet data, analyzes it, and formats the results — all without you opening Sheets.

Read the 'Weekly Metrics' Google Sheet and tell me which campaigns had a CPA above $50 last week. Highlight those rows in red.

Prompt Example

claude

Claude queries your Notion database directly, filtering and presenting the results in a clean summary.

Check our Notion content calendar for any blog posts scheduled this week that don't have a status of 'Ready'. List them with their current status and assigned author.

Combining MCPs

The real power emerges when you combine MCPs. Claude can pull data from GA4, write it to a Google Sheet, and create a summary in Notion — all in a single conversation. This is where you stop being a data relay and start being a strategist.

Pro Tip

Start with read-only access when connecting new tools. Once you're comfortable with how Claude interacts with your data, you can upgrade to write access. This gives you a safety net while you learn the workflow.

You now have four MCPs connected: GA4, BigQuery, Google Sheets, and Notion. In the next lesson, we'll add the most powerful connector of all — direct database access.

Connecting Claude to Google Sheets & Notion