GoogleSheets
MCP server with 15 tools available.
Capabilities
15 capabilities
get_sheet_data
Get data from a specific sheet in a Google Spreadsheet. Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet range: Optional cell range in A1 notation (e.g., 'A1:C10'). If not provided, gets all data. Returns: Grid data structure with full metadata from Google Sheets API
Required Params
get_sheet_formulas
Get formulas from a specific sheet in a Google Spreadsheet. Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet range: Optional cell range in A1 notation (e.g., 'A1:C10'). If not provided, gets all formulas from the sheet. Returns: A 2D array of the sheet formulas.
Required Params
update_cells
Update cells in a Google Spreadsheet. Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet range: Cell range in A1 notation (e.g., 'A1:C10') data: 2D array of values to update Returns: Result of the update operation
Required Params
batch_update_cells
Batch update multiple ranges in a Google Spreadsheet. Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet ranges: Dictionary mapping range strings to 2D arrays of values e.g., {'A1:B2': [[1, 2], [3, 4]], 'D1:E2': [['a', 'b'], ['c', 'd']]} Returns: Result of the batch update operation
Required Params
add_rows
Add rows to a sheet in a Google Spreadsheet. Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet count: Number of rows to add start_row: 0-based row index to start adding. If not provided, adds at the end. Returns: Result of the operation
Required Params
Get Started
Click any tool below to instantly start building AI tools that enhance your workflow and productivity
Custom Workflow Builder
Create automated workflows that connect your tools and streamline repetitive tasks with AI assistance.
Data Analyzer
Transform raw data into actionable insights with AI-powered analysis and visualization tools.
Content Assistant
Generate, edit, and optimize content across formats with AI that understands your brand and style.
Task Automation
Automate routine tasks and processes to save time and reduce manual work with intelligent AI tools.
Integration Hub
Connect and sync data across your favorite tools and platforms with seamless AI-powered integrations.
Smart Assistant
Build a personalized AI assistant that helps with daily tasks, answers questions, and provides support.
Related Actions
OpenAlex
openalex
MCP server with 3 tools
Used 73 times on Pickaxe
SemanticScholar
semanticscholar
MCP server with 4 tools
Used 16 times on Pickaxe
OpenAIWebSearch
openaiwebsearch
MCP server with 1 tools
Used 572 times on Pickaxe
SequentialThinking
sequentialthinking
MCP server with 1 tools
Used 64 times on Pickaxe
Excel
excel
Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables
11 uses
Youtube
youtube
YouTube is a video-sharing platform with user-generated content, live streaming, and monetization opportunities, widely used for marketing, education, and entertainment
366 uses
Explore Pickaxe Templates
Get started faster with pre-built templates. Choose from our library of ready-to-use AI tools and customize them for your needs.
Ready to Connect GoogleSheets?
Build your AI tool with this MCP server in the Pickaxe builder.
Build with Pickaxe