Google Sheets
Connector
10 free requests
Available Actions
create_spreadsheetget_spreadsheetupdate_spreadsheet_propertiessearch_spreadsheetslist_sheetsadd_sheetdelete_sheetduplicate_sheetrename_sheetupdate_sheet_propertiesget_valuesbatch_get_valuesget_sheet_datasearch_valuesupdate_valuesbatch_update_valuesappend_valuesclear_valuesbatch_clear_valuesformat_cellsset_number_formatmerge_cellsunmerge_cellsset_bordersinsert_rowsinsert_columnsdelete_rowsdelete_columnsresize_dimensionsauto_resize_dimensionssort_rangefind_replacecopy_pastecut_pasteset_basic_filterclear_filterprotect_rangeunprotect_rangeadd_named_rangedelete_named_rangeset_data_validationadd_conditional_formattingbatch_updateshare_spreadsheet
Details
Comprehensive Google Sheets integration tool that enables AI agents to perform all spreadsheet operations through OAuth authentication. This tool provides full access to Google Sheets functionality including creating and managing spreadsheets, reading and writing data with support for formulas and batch operations, managing sheets and tabs with adding deleting and renaming capabilities, applying advanced cell formatting with colors fonts and number formats, inserting and deleting rows and columns with automatic resizing, sorting and filtering data with complex criteria, and executing find and replace operations across entire spreadsheets. The tool supports both single and batch operations for optimal performance, handles all Google Sheets data types including formulas dates and currency, provides granular control over cell formatting and sheet properties, and includes advanced features like merging cells setting filters and protecting ranges. Perfect for data analysis reporting automation spreadsheet generation and collaborative document management workflows.
Use Cases
automated report generation, data import and export, spreadsheet templating, bulk data updates, financial modeling, inventory management, dashboard creation, collaborative data entry, formula automation, batch formatting operations
Workflows Using This Tool
Credentials
Google OAuth *
Connect your Google account.
Manage credentials in your dashboard.
Parameters
actionrequiredstringAction to perform on Google Sheets
spreadsheet_idstringGoogle Sheets ID or full spreadsheet URL. Example: '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms' or 'https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit'
spreadsheet_urlstringAlternative to spreadsheet_id. Full Google Sheets URL.
and 50 more parameters...
About The Developer
Apoth3osis
★15 stars
Joined Agent Payment: August 14, 2025
We build tools that enable AI agents to excel in the mathematical realm.
Our small team develops experimental and unique solutions in the AI arena, with a strong focus on modular computing for agentic applications and custom model deployment. We have handled projects for a variety of applications across many sectors, from algorithmic trading and financial analysis, to molecular simulations and predictions, to habitat and biodiversity monitoring and wildlife conservation.