DOCUMENT OPS
Load only valid CSV rows into Airtable and table-log the rejects
On a new Drive upload, splits the spreadsheet into clean and invalid rows, writes clean rows into Airtable.
How it runs
The automated pipeline, trigger to output.
- TriggerNew CSV uploaded to Drive folderGoogle Drive
- ActionDownload and split into rowsGoogle Drive
- LogicPartition rows into pass and fail
- ActionCreate passing rows in AirtableAirtable
- ActionLog rejected rows to Airtable rejects tableAirtable
- OutputPost load summary to SlackSlack
What it does
This workflow turns a raw CSV upload into a clean Airtable import. It parses the file, validates each row, inserts the rows that pass into your destination Airtable table, and logs each row that fails into a dedicated rejects table with the column, value, and reason it was rejected — so nothing silently disappears.
When to use it
Use it when Airtable is your system of record and you can't afford partial or malformed records polluting it. It keeps the good data flowing while giving you an auditable trail of exactly what got bounced and why.
How it works
- 1A new spreadsheet in the Drive folder triggers the run.
- 2The file is downloaded and split into individual rows.
- 3Each row is validated; rows are partitioned into pass and fail buckets.
- 4Passing rows are batch-created in the destination Airtable table.
- 5Failing rows are written to an Airtable rejects table with reason fields.
- 6A summary count is posted to confirm how many loaded vs. rejected.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect SlackChannels, DMs, threads, mentions.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Document Ops workflows
Narrate new Dropbox PDFs into MP3 audio versions
When a PDF lands in a watched Dropbox folder, extract its text and generate an ElevenLabs voice narration.
On-demand PDF narration via webhook with emailed audio link
Accepts a PDF URL through a webhook, generates an ElevenLabs narration with the requested voice, stores the MP3, and emails the requester a download link.
Triage emailed contract redlines and route by risk
When a counterparty emails a redlined contract, extracts the attachment, diffs clauses against approved templates.
Batch-narrate a Google Drive PDF folder in multiple languages
On a schedule, finds PDFs in a Google Drive folder that lack audio, then generates ElevenLabs narrations in each configured language and files them into per-language subfolders…
Executed Contract Exhibit & Initials Completeness Gate
When a signed contract lands in a Dropbox intake folder, verify every required exhibit, schedule, and initialed page is present.
Draft a negotiation brief from contract clause deviations
An agent reviews a contract against approved templates, researches each deviation.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.