list_files
List Files
List files and folders in your Gigasheet library. Can list files at the root level, within a specific folder, shared files, or search the library by name.
Supported Tools
manage_file
Manage File
Perform file management operations on a Gigasheet file or folder. Supports renaming, copying, moving, deleting, and combining files.
modify_rows
Modify Rows
Add, update, or delete rows in a Gigasheet sheet. Supports appending new rows, inserting blank rows, updating individual cells, upserting rows, deleting specific rows, or deleting rows matching/not matching a filter.
export_sheet
Export Sheet
Create an export of a Gigasheet sheet, optionally with filters and groupings applied. The export is asynchronous — this tool returns the export handle which can be used to check status and download the result.
find_and_replace
Find and Replace
Search for values in a sheet and replace them with new values. Optionally scope the operation to a specific column and control matching behavior.
share_file
Share File
Share a Gigasheet file with other users via email, or create a live share link that produces CSV data. Supports setting permissions and managing live shares.
manage_columns
Manage Columns
Perform column operations on a Gigasheet sheet. Supports renaming, deleting, combining, splitting, changing data types, changing string case, trimming whitespace, extracting domains from URLs, and exploding JSON or delimited columns.
create_sheet
Create Sheet
Create a new sheet in Gigasheet. You can create a blank sheet with optional column headers, upload data from a URL, or upload raw data directly. Also supports creating folders for organization.
filter_data
Filter Data
Query and filter data in a Gigasheet sheet. Supports filtering with complex filter models (AND/OR conditions, regex, wildcards), sorting, pagination, grouping, and aggregations. You can also use a saved filter by its handle.
get_sheet
Get Sheet Details
Retrieve detailed information about a Gigasheet sheet including its metadata, columns, and structure. Useful for understanding a sheet before performing data operations.
run_formula
Run Formula
Execute a formula on a Gigasheet sheet to create a new calculated column. Supports validating and previewing formulas before execution. Use the AI formula builder to help construct complex formulas from natural language.
download_export
Download Export
Get the download URL for a completed export. Returns a pre-signed S3 URL that can be used to download the exported file (ZIP containing CSV). Also supports checking operation status before downloading.
get_activity
Get Activity History
Retrieve the audit and activity history for a Gigasheet sheet. Shows actions performed on the dataset, with support for searching through activity logs.
deduplicate_rows
Deduplicate Rows
Detect and remove duplicate rows from a Gigasheet sheet. You can first count duplicates before deleting, and optionally scope duplication detection to specific columns.
manage_saved_filters
Manage Saved Filters
List, create, update, or delete saved filters in Gigasheet. Saved filters store reusable filter logic that can be applied to any sheet.
cross_file_lookup
Cross-File Lookup
Perform a VLOOKUP-style operation across two sheets. Joins data from a lookup sheet into the target sheet based on matching column values. Columns from the lookup sheet are added to the target sheet where matches are found.
manage_views
Manage Views
Create, list, update, delete, or convert named views on a Gigasheet sheet. Views save specific filter, sort, grouping, and aggregation configurations that can be reapplied. Views can also be converted to linked sheets.
manage_comments
Manage Comments
Add, retrieve, or delete comments on a Gigasheet sheet. Supports both column-level and cell-level comments.
enrich_data
Enrich Data
Enrich sheet data using built-in or custom enrichment providers. Built-in providers include email validation and geolocation. Custom HTTP enrichments allow calling external APIs to enrich data. Enrichments consume credits.
ai_assistant
AI Assistant
Chat with Gigasheet's AI assistant about a sheet's data. The assistant can answer questions about the data, provide insights, and help with analysis. Also supports retrieving and clearing chat history.
More integrations teams use with Gigasheet
GitHub
Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.
Sharepoint
Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Subscribe to webhooks for list and library change notifications. Retrieve site properties and search for sites across Microsoft 365.
Salesforce
Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Subscribe to real-time change events via Change Data Capture and Platform Events. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.
Airtable
Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.
Confluence
Create, read, update, and delete pages, blog posts, comments, and attachments in Confluence spaces. Manage spaces, permissions, labels, and content restrictions. Search content using Confluence Query Language (CQL). Upload and download file attachments with versioning. Manage users, groups, and group memberships. Create and manage whiteboards, databases, folders, and templates. View and update inline tasks. Access audit logs. Listen for webhooks on page, blog, comment, attachment, space, label, and user events.
Bitbucket
Manage Git repositories, pull requests, and CI/CD pipelines on Bitbucket Cloud. Create, fork, and configure repositories within workspaces and projects. Create, review, approve, merge, and decline pull requests with inline code comments. Browse source code, list commits, and manage branches and tags. Track issues with the built-in issue tracker. Trigger, monitor, and manage Bitbucket Pipelines. List workspace members, configure repository default reviewers and branch restrictions, create and manage repository webhooks, and search code across repositories.
Technical notes for Gigasheet
Upload, manage, and manipulate large-scale spreadsheet datasets (CSV, JSON, log files) in the cloud. Create, copy, rename, move, and delete sheets and folders. Modify data at cell, row, and column levels including formulas, column splitting, type changes, and find-and-replace. Build complex filters with AND/OR logic, regex, and wildcards. Aggregate and group data like pivot tables. Create and manage named views. Export datasets with optional filters applied and download via pre-signed URLs. Share files with configurable permissions and create live shareable links. Enrich data using built-in providers (email validation, geolocation) or custom HTTP enrichments. Detect and delete duplicate rows. Perform cross-file lookups (VLOOKUP-style joins). Connect to external databases and data warehouses for import/export. Interact with data via an AI chat assistant and AI formula builder. Add and manage comments on cells and columns. Retrieve audit and activity history for datasets. Manage users, teams, and API keys.
Frequently asked questions
Common questions about connecting Gigasheet to AI agents with Metorial.
Can Metorial connect Gigasheet to AI agents?
Yes. Metorial connects AI agents to Gigasheet through a governed integration layer, so teams can use the provider while keeping access controlled and observable.Does the Gigasheet integration work with MCP?
Metorial is MCP compatible and lets teams expose approved provider tools to MCP-capable agents and clients through a controlled access layer.How does Metorial control access to Gigasheet?
Metorial applies policies across users, groups, providers, agents, and individual tools, then records the context around every agent interaction.Can teams trace Gigasheet activity from agents?
Yes. Metorial records provider activity so teams can inspect tool calls, troubleshoot integrations, and give security teams the visibility they need.