Flatfile
Data import with collection, validation, transformation, and structured file handling.
Imports a messy spreadsheet, validates the rows against a schema, and reports what failed.
Use Flatfile with Snow
Snow is a personal AI assistant that builds real apps for you, and they can put Flatfile to work.
What Snow can do with Flatfile
These are the Flatfile operations Snow and the apps you build with it can run. Sign in to choose which ones Snow may run without asking.
Reads9
Look at your data without changing it.
- 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.
- 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.
Creates1
Add something new to your account.
- 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 matches that are unambiguous for caller-controlled unique values. Hooks are disabled for this mutation.
Updates1
Change something that is already there.
- 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.
Deletes1
Remove something. This often cannot be undone.
- 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.
Related integrations
Ready to put Flatfile to work?
Sign up free, build an app by chatting, and connect Flatfile in minutes. No credit card required.