Flatfile
Flatfile is a data exchange platform for collecting, validating, transforming, and managing structured data across collaborative workflows.
Integration
- Vendor
- Flatfile
- Category
- developer-tools
- Auth
- API_KEY
- Tools
- 12
- Composio slug
flatfile
Tools
- Delete Recordsdestructive
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
- Create or open a Switchy Project.
- Open Integrations and connect Flatfile.
- Authorise through api_key. Switchy stores the connection against your org.
- Everyone in the Project can now @-mention the Flatfile tools in chat.
What teammates see: by default, memories from Flatfile are scoped to the Project (PROJECT visibility) - you can mark any memory PRIVATE or share it ORG-wide.
Works well with
Top models
Compatibility data appears once enough Projects have used this MCP together with a given model.