DOCUMENT OPS
Signed PDF Signature Ledger With Postgres Audit Trail
On each signed PDF in Google Drive, it extracts signer, date, and cert details and writes a normalized verification record to a Postgres audit ledger.
How it runs
The automated pipeline, trigger to output.
- TriggerNew signed PDF in Google Drive folderGoogle Drive
- ActionDownload file and extract signature fieldsShell
- LogicCompute per-field validation status
- ActionInsert verification record into Postgres ledgerPostgres
- OutputWrite flagged audit row for any failed fieldPostgres
What it does
Turns every incoming signed PDF into a queryable audit record. It extracts the signer identity, signing timestamp, and certificate issuer/expiry, normalizes them, and inserts a row into a Postgres ledger table with a pass/fail status per field so you have a permanent, searchable trail.
When to use it
Use it when auditors or regulators require proof of when each document was signed and by whom, and you need that history in a database rather than scattered across files. Ideal for finance and compliance archives.
How it works
- 1A new file in the Google Drive signed folder triggers the run.
- 2The file content is downloaded and a shell step extracts signer, date, issuer, and expiry.
- 3A logic step computes per-field pass/fail (signer present, date sane, cert unexpired).
- 4An insert writes the document id, fields, statuses, and run timestamp to the Postgres ledger.
- 5If any field failed, a flagged row plus reason is written so it surfaces in audit queries.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect ShellRun sandboxed commands inside the workspace.
- 3Connect PostgresAny Postgres URL — query, write, migrate.
- 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.