Ragic
DatabaseRagic is a no-code database builder where every sheet's own URL is its API endpoint. Agents list, create, update and delete records on any sheet, upload files, add comments, lock and approve records in bulk, run action buttons and download record documents.
What This Integration Enables
Ragic has no endpoint catalog, and that is the most useful thing about it. Every sheet's own browser URL is its API endpoint, so the address someone pastes into a message is the address a FlowRunner agent calls. There is no parallel object model to keep in sync and no integration-only view of the data. A team that reorganizes its sheets has reorganized the API, and a flow built on Get Table style discovery keeps working because it was reading the same structure the users were.
The consequence for automation is that a write has to be deliberate. Ragic stores exactly what you send: formulas do not recalculate, default values do not fill in, link-and-load does not resolve, and workflow scripts do not fire unless the call asks for each of them. Notifications are the exception and default to on, which means a careless bulk load can mail an entire team. FlowRunner's connectors expose all of these as explicit choices rather than hiding them behind a sensible-looking default, because on this API the difference between a record that behaves like a typed one and a record that only looks like one is invisible after the fact.
Without FlowRunner
With FlowRunner
Use Case Scenarios
-
Receiving that reconciles itself
A delivery note arrives by email or from a carrier feed. The agent extracts quantities and lot numbers, calls List Records against the purchase order sheet with a filter on the order number, and finds the open line. Create Record writes the receipt with Recalculate Formulas and Run Workflow switched on so the sheet's own logic runs, and Upload File To Record attaches the note to the receipt. Where the received quantity differs from the ordered one, Add Comment posts the variance into the record's own thread, and the ERP posting to Acumatica waits until a supervisor has looked at it.
-
A document a customer can actually read
Ragic renders a record as a document by appending a suffix to the record's own URL. So once a quote reaches its final state, the agent calls Download Record Document, receives the rendered file, and sends it out through Gmail or into a signature request in DocuSign. Nothing has to reproduce the layout, because the layout already exists in Ragic and the document is what the sheet says it is.
-
Bulk work that runs at the right end of the wire
Loading several thousand rows through single writes is slow and burns rate budget. Ragic's own recommendation for that case is Import From URL, which triggers the sheet's configured periodic import immediately. The agent stages the file, calls Import From URL, and then re-reads the sheet to confirm what landed. When the change is an update rather than a load, Mass Update Records applies one set of values to a filter match in a single asynchronous task, and a summary of what the filter matched posts to Slack.
Human-in-Loop Highlight
Ragic's mass operations answer with a task id and nothing else. There is no route for reading that task's outcome, so a flow that wants to know what happened has to re-read the records and infer it. Mass Approve Records is the one where that matters most: approval is a person's signature applied at the scale of a filter, and with neither a filter nor a record list Ragic acts on the entire sheet, which this connector refuses outright rather than letting a blank parameter become a whole-sheet approval. So the agent does the work up to the signature and then stops. It runs List Records with the intended filter, counts the match, and posts: "This filter matches 218 expense records over the review threshold, totaling the amount shown. Mass Approve Records will approve all 218 in one asynchronous task, and Ragic will not report back what it did. Approve this filter, or narrow it?" The finance lead approves the criterion, not a spinner. That distinction is the whole point: with no outcome to read afterward, the only moment a human can meaningfully intervene is before the call, so that is where FlowRunner puts them.
Agent Capabilities
18 actionsRecords
5- List Records Reads records from a sheet with filtering, full-text search, a saved shared view, ordering, and paging. Ragic returns an object keyed by record index rather than an array, and at most 1,000 records unless Limit says otherwise.
- Get Record Reads one record by its Ragic record id, with the same optional extras as List Records.
- Create Record Adds a record to a sheet, with values keyed by field id and dates in Ragic's own format. Formulas, default values, link-and-load, and workflow scripts each have to be requested, otherwise the record is stored exactly as sent.
- Update Record Changes the named fields on one record and leaves the rest untouched. Editing a subtable row needs that row's existing id, which only a read will tell you.
- Delete Record Permanently removes one record.
Files and Comments
2- Upload File To Record Uploads a file into a file or image field on a record, reading it from FlowRunner file storage or from a URL. Ragic has no upload-by-link route, so the bytes are fetched and posted on.
- Add Comment Adds a comment to a record's comment thread, optionally with a file attached. The way an agent puts its findings where the next reader will already be looking.
Record Locking
2- Lock Record Locks a record so it can no longer be edited, under the same permissions as locking through the interface.
- Unlock Record Unlocks a previously locked record so it can be edited again.
Action Buttons
2- List Action Buttons Lists the action buttons configured on a sheet, with the identifier the execute operations need.
- Execute Action Button Runs one of a sheet's action buttons against a single record, the same as a user clicking it. The key's user needs permission both to run the button and to view the record.
Mass Operations
4- Mass Update Records Sets the same field values on every record matching a filter, or on a named list of records. Asynchronous: the response is a task id, and confirming the change means re-reading the records.
- Mass Lock Records Locks or unlocks every record matching a filter, or a named list, in one asynchronous task.
- Mass Approve Records Approves or rejects every record matching a filter, or a named list, in one asynchronous task. The operation this page's human gate exists for.
- Mass Execute Action Button Runs one action button against every record matching a filter, or a named list, in one asynchronous task.
Import and Documents
2- Import From URL Triggers the sheet's configured periodic import immediately. Ragic recommends this over many single writes when creating or updating a large amount of data at once.
- Download Record Document Renders one record as a document and returns it encoded. Ragic builds these by appending a suffix to the record's own URL rather than through a separate endpoint.
Webhooks
1- Get Webhook Signature Public Key Returns the RSA public key Ragic signs its webhook deliveries with, so a receiving flow can verify them. Ragic signs only webhooks configured to send the full content of a changed record.
Frequently Asked Questions
What can FlowRunner do with Ragic?
FlowRunner agents can run List Records, Get Record, and Create Record in Ragic, plus 15 more actions.
Does connecting Ragic to FlowRunner require OAuth?
No. Ragic connects to FlowRunner with an API key, no OAuth flow required.
Can Ragic trigger a FlowRunner workflow automatically?
Ragic doesn't currently expose triggers in FlowRunner. It connects as an action step inside workflows started by another trigger.
Other Database integrations
Start building with Ragic
Free plan, no card required. Connect in minutes.