Skip to main content

​
Overview

Integrate Google Sheets to manage spreadsheets, manipulate data, and automate reporting from CORE. Access 8 essential tools for complete spreadsheet management including data reading, writing, formatting, and batch operations without leaving your workspace.

​
Setup Guide

  • Authentication Type : OAuth 2.0 (Google)

​
How to Connect

  1. Navigate to CORE Dashboard → Integrations
  2. Click on the Google Sheets card
  3. Click Connect to authorize CORE
  4. You’ll be redirected to Google to authorize the application
  5. Grant the required permissions
  6. You’ll be redirected back to CORE once connected

​
Use Cases

When you ask CORE to perform Google Sheets tasks, it uses MCP tools to execute your requests:
Scenario: Extract data from spreadsheets for analysis, reporting, or processing
The agent will:
  1. Use list_spreadsheets to find the spreadsheet
  2. Use list_sheets to discover available sheets
  3. Use read_range to get the data you need
Scenario: Modify spreadsheet data programmatically with single or batch updates
The agent will:
  1. Use write_to_cell for updating single values
  2. Use write_range for updating multiple cells at once
  3. Use batch_update for complex operations with formatting
Scenario: Generate new spreadsheets for reports, exports, or data organization
The agent will:
  1. Use create_spreadsheet with appropriate sheet titles
  2. Use write_range to add headers and initial data
  3. Use append_range to add records as they’re generated
Scenario: Automate repetitive data tasks and keep spreadsheets synchronized
The agent will:
  1. Use read_range to get current data
  2. Process the data with business logic
  3. Use write_range or append_range to update the spreadsheet
Scenario: Handle large volumes of data efficiently with batch append and update operations
The agent will:
  1. Use append_range to add multiple rows of data efficiently
  2. Use batch_update to apply formatting and sorting in one operation

​
Scopes

  • https://www.googleapis.com/auth/spreadsheets - Read and write access to spreadsheets
  • https://www.googleapis.com/auth/drive.readonly - Read-only access to Google Drive for file discovery

​
Available MCP Tools

The Google Sheets integration provides 8 tools for comprehensive spreadsheet management:

​
Need Help?

Join our Discord community for support in #core-support