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
"List all my spreadsheets, then read data from the 'Sales Report' sheet
in the Q1 2026 spreadsheet and show me the totals"
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
"Update cell B2 in the 'Budget' sheet to 50000,
then update the entire row 5 with the new quarterly figures"
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
"Create a new spreadsheet called 'Monthly Sales Report',
add headers in the first row, and populate it with this month's data"
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
"Read the current inventory data from the warehouse sheet,
update the quantities based on today's orders, and write back the new values"
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
"Add 100 new customer records to the end of the Customers sheet,
then format the header row as bold and sort by customer name"
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:
Tool NameDescription
list_spreadsheetsLists all Google Sheets spreadsheets in the user’s Google Drive with metadata including creation and modification times
list_sheetsLists all sheets within a spreadsheet with metadata (sheetId, title, index, row count, column count). Does not include cell data. Use this to discover available sheets before fetching data.

​
Need Help?

Join our Discord community for support in #core-support