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.
Flatfile is a data exchange platform for collecting, validating, transforming, and managing structured data across collaborative workflows.
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 detailed status, outcome, result, and diagnostic information for one Flatfile asynchronous job.
Get one sheet's field configuration and record counts before reading or writing records.
Get safe metadata for one Flatfile space without exposing transient access credentials or token-bearing guest links.
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.
List Flatfile environments visible to the connected environment secret key and return the IDs needed to find spaces.
Discover import or export files and their processing status, optionally within a Flatfile space.
Find asynchronous Flatfile jobs by environment, space, workbook, file, or parent job and inspect progress at a glance.
Read one page of records from a Flatfile sheet, optionally filtering by validity, field, record ID, search value, or FFQL expression.
Find Flatfile spaces by environment, text, namespace, archive state, or template status.
List workbooks, optionally within a space, with their nested sheets so an agent can continue to sheet and record tasks.
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.
The Flatfile integration connects your Dench AI CRM directly to Flatfile, so agents can read and act on your Flatfile data as part of everyday work — answering questions in chat, keeping your CRM in sync, and running automations without anyone copying data between tools.
12 actions are available for agents to invoke on your behalf. Every call runs through Flatfile's own authorization, scoped to the account you connect.
Sign in to your Dench workspace and open Integrations.
Find Flatfile and click Connect — you'll authorize access through Flatfile's own sign-in flow. No API keys or code required.
Ask an agent to use Flatfile in chat, or call it from an automation.
Manage or disconnect the connection any time from workspace settings.
The Dench Flatfile integration connects your AI CRM to Flatfile, so AI agents can work with your Flatfile data as part of chats, automations, and CRM workflows. You connect your account once, and every agent in your workspace can use it — governed by your workspace permissions.
The Flatfile integration currently exposes 12 actions, including Delete Records, Get Job, Get Sheet, Get Space, Insert Records, and List Environments. Agents invoke them on your behalf from chat or from automations.
No. You connect Flatfile from your Dench workspace using Flatfile's own sign-in and authorization flow — no API keys to copy, no glue code to maintain.
Connections are authorized through Flatfile's own authentication flow, and Dench stores only the authorization needed to act on your behalf. You can review and disconnect the Flatfile connection from your workspace settings at any time.