# Flatfile MCP

Vendor: Flatfile  
Category: developer-tools  
Auth: API_KEY  
Composio slug: `flatfile`

Flatfile is a data exchange platform for collecting, validating, transforming, and managing structured data across collaborative workflows.

## Tools

- **Delete Records** — Permanently delete one to 100 explicitly identified records from one Flatfile sheet. This action never performs an unfiltered delete. Flatfile hooks are disabled, so these deletions do not trigger hook-driven workflows.
- **Get Job** — Get detailed status, outcome, result, and diagnostic information for one Flatfile asynchronous job.
- **Get Sheet** — Get one sheet's field configuration and record counts before reading or writing records.
- **Get Space** — Get safe metadata for one Flatfile space without exposing transient access credentials or token-bearing guest links.
- **Insert Records** — Insert one or more rows into a Flatfile sheet using simple field-key to value objects. Returns Flatfile's success receipt and commit ID, not created record IDs. Use List Records separately when later work requires IDs; only attribute matche
- **List Environments** — List Flatfile environments visible to the connected environment secret key and return the IDs needed to find spaces.
- **List Files** — Discover import or export files and their processing status, optionally within a Flatfile space.
- **List Jobs** — Find asynchronous Flatfile jobs by environment, space, workbook, file, or parent job and inspect progress at a glance.
- **List Records** — Read one page of records from a Flatfile sheet, optionally filtering by validity, field, record ID, search value, or FFQL expression.
- **List Spaces** — Find Flatfile spaces by environment, text, namespace, archive state, or template status.
- **List Workbooks** — List workbooks, optionally within a space, with their nested sheets so an agent can continue to sheet and record tasks.
- **Update Records** — Update one or more existing Flatfile records by ID using simple field-key to value objects. Flatfile hooks are disabled, so these updates do not trigger hook-driven workflows.

## Setup

1. Create or open a Switchy Project.
2. Open Integrations and connect Flatfile.
3. Authorise through api_key.
4. Teammates can now @-mention Flatfile tools in chat.

---
Last verified: 2026-09-04T02:00:56.012Z  
Canonical URL: https://switchy.build/directory/mcps/flatfile