--- title: "SpreadsheetWeb Hub Integration" description: "SpreadsheetWeb Hub by Pagos turns Excel models into web applications and APIs. Agents run calculations against a published workbook, manage applications and their transactions, read and remove stored records, generate documents from print templates, and manage workspace users and share links." url: https://flowrunner.ai/integrations/spreadsheetweb-hub date_modified: 2026-09-04T14:52:04-07:00 --- # SpreadsheetWeb Hub [Productivity](https://flowrunner.ai/integrations/category/project-management-productivity) SpreadsheetWeb Hub by Pagos turns Excel models into web applications and APIs. Agents run calculations against a published workbook, manage applications and their transactions, read and remove stored records, generate documents from print templates, and manage workspace users and share links. [Verified](https://flowrunner.ai/integrations/verified "What does verified mean?") · 73 actions · OAuth · available [SpreadsheetWeb Hub website](https://spreadsheetweb.com/) · [Platform Documentation](https://www.spreadsheetweb.com/) · Capability data verified 2026-08-24 1. The model owner finishes a revision to the pricing workbook and the release flow starts 2. Get Application Status reports whether a published version exists and whether unpublished work is waiting 3. Get Validation Messages returns everything the designer flagged before any of it goes live 4. List Named Ranges confirms which inputs the model now accepts and which outputs it returns 5. Calculate runs the agreed test cases against both the pending version and the published one 6. The owner receives the differences case by case, each labeled with the transaction it came from 7. The owner authorizes Publish Application, and decides separately whether stored records are recalculated ## What This Integration Enables SpreadsheetWeb Hub exists for a specific and very common situation: the calculation that runs the business already works, and it lives in Excel. A pricing model, an insurance rating sheet, a commission plan, a materials estimator. It is correct because the person who owns it maintains it, and rewriting it in application code would move the logic away from the only person who can be trusted to change it. SpreadsheetWeb publishes that workbook as an application and an API instead, and this connector lets FlowRunner agents call it. That framing decides how the connector is shaped. Calculate is the simple form, named inputs in and named outputs back. Calculate Advanced adds goal seek, localization and record loading, including the option to read a stored record's values in before calculating rather than sending them. Around the calculation sit the things a production model needs: applications and their published transactions, the stored records every run leaves behind, document generation from print templates, workspace users and invitations, and public share links. Because a calculation is addressed to a transaction rather than just to an application, an old result can be reproduced exactly by pinning the sequence that produced it, and the workbook behind it can be downloaded. Where a change would rewrite results that people have already acted on, FlowRunner's [human-in-the-loop](https://flowrunner.ai/concepts/human-in-the-loop) design puts the model's owner in the path. ### Without FlowRunner **The model is a file**: The logic lives in a workbook on somebody's drive and reaches other systems by email **Rebuilt in code to be used**: Getting a quote engine into an application means an engineer reimplementing formulas **Old numbers cannot be reproduced**: Nobody can say which version of the model produced a figure quoted three months ago ### With FlowRunner **The model is a callable step**: Agents call the workbook the finance team already maintains, as one step in a flow **The owner keeps the logic**: Changing a rate means editing a spreadsheet, not filing a change request **Results are pinned to a version**: Every result names the published version behind it, and that version can be downloaded ## Use Case Scenarios ### The quote that comes from the company's own model An inbound request arrives from a form or from a deal stage in [HubSpot](https://flowrunner.ai/integrations/hubspot). The agent reads List Named Ranges to know exactly what the application accepts, calls Calculate with the customer's inputs, and gets the named outputs back. Because Transaction Sequence is left empty, it runs against the newest published version, and the response carries which one that was. Generate Document then fills the print template from Get Document Stubs so the customer receives a quote document rather than a set of numbers, and the record of the run is stored in the application's own database where List Records can find it again. Nobody reimplemented a formula, and the quote is defensible because the workbook behind it can be produced on request. ### Batch pricing without a spreadsheet marathon A supplier sends a revised cost list, or a renewal book comes up. The agent loads the rows and calls Calculate Multiple, or Calculate Multiple Async for a batch large enough to need it, polling Get Calculation Progress with the key the call returned and closing the session afterwards. Record Information decides whether each result is stored as a new record and whether existing tags carry over, are replaced, or are merged. The finished set is read back with List Records and Download Records, and the summary posts to [Slack](https://flowrunner.ai/integrations/slack) with the outliers called out. The finance team gets a repriced book in the format they already use, computed by the model they already trust. ### A result shared with an outside party, on purpose Sometimes a single stored record needs to reach somebody who has no login: a broker, a customer, a partner. Create Data Share Link publishes exactly one record to whoever holds the URL, with no sign in at all, and it has two modes. View lets them look. Edit lets an anonymous holder change the record. The connector takes a named mode rather than the raw number, because getting that backwards is easy and the consequence is not symmetric. Flows that use it set an expiration time, since a link left without one does not expire, and Delete Data Share Link is the fastest way to cut access when the engagement ends. ## Human-in-Loop Highlight Publish Application makes a new version of the model live, and Recalculate All Records reruns every stored record against whatever is currently live. Together they can rewrite the numbers behind quotes, policies and commission statements that people have already seen, and Delete All Records, the other bulk operation on this connector, empties an application's database with no restore. SpreadsheetWeb ships the evidence needed to judge it: Get Application Status says whether unpublished work is waiting, Get Validation Messages says what the designer flagged, List Transactions names every published version, and Download Application Workbook produces the actual file behind an old result. So the release flow assembles all of that and stops. It posts to the model owner: "Pricing v14 is ready to publish. Validation is clean. Against the twelve regression cases, ten match the published version and two differ: case 7 moves from 41,200 to 39,850 and case 11 from 8,940 to 8,940 with a changed tax breakdown. There are 3,412 stored records on the current version. Publish only, publish and recalculate all records, or hold?" The owner answers. Publishing forward is a decision about new work. Recalculating is a decision about history, and it is a different decision, which is why the agent asks for both rather than treating one as implied by the other. Agent processes routinely Detects exception requiring judgment Clear match Continues automatically Ambiguous Routes to human via preferred channel Human decides Agent resumes with decision ## Agent Capabilities 73 actions ### Calculations 8 - **Calculate** Runs the model with named inputs and returns named outputs. The simple form, and the one most flows need. - **Calculate Advanced** Adds what the simple form cannot do: goal seek, localization for a different numeric standard, and reading or saving a stored record as part of the same call. - **Calculate Multiple** Runs a set of input rows in one call, with record handling applied to each. - **Calculate Multiple Async** Runs a batch too large to answer inline, returning a key to poll. - **Recalculate All Records** Reruns every stored record against the current model. What a flow wants after publishing a corrected workbook, and the operation this page's human gate exists for. - **Get Calculation Progress** Reports how far an asynchronous run has got, using the key the call returned. - **Close Calculation Session** Ends a calculation session, releasing what it was holding. - **Prepopulate Instance** Seeds an application instance with starting values before anybody interacts with it. ### Applications 13 - **List Applications** Lists the workspace's applications. Its published-with-databases option is a path segment rather than a filter field, and turning it on hides every application without a database or a published version. - **Get Application** Returns one application by identifier. - **Get Application By Slug** Returns one application by its slug, which is the readable identifier a URL carries. - **Get Applications** Returns a set of applications in one call. - **Create Application** Creates an application to publish a workbook through. - **Create Application From Template** Creates an application from an existing template rather than from scratch. - **Update Application** Changes an application's settings. It cannot change the workbook; replacing the model is a designer operation followed by a publish. - **Update Application Slug** Changes the readable identifier an application answers to, which changes the URLs pointing at it. - **Delete Application** Removes an application. - **Delete Applications** Removes several applications in one call. - **Assign Application Tags** Sets the tags on an application. - **Get Application Tag Relationships** Returns which tags are attached to which applications. - **Download Application Workbook** Retrieves the workbook behind a published version. Combined with a pinned transaction sequence, this is how an old result is proved rather than asserted. ### Records 11 - **List Records** Lists the records an application has stored, with sorting and filtering. Also the polling read for flows that need to notice new submissions, since SpreadsheetWeb publishes no webhook. - **Delete Records** Removes named records from an application's database. - **Delete All Records** Empties an application's database entirely, with no restore. - **Download Records** Retrieves named records as a file. - **Download All Records** Retrieves an application's whole record set as a file. - **Download Record Attachment** Retrieves a file attached to a stored record. - **Update Record Tags** Changes the tags on a stored record. - **Unlock Record** Releases a record that is being held, so it can be edited again. - **Mark Record Active** Sets a record active, which is how a soft-retired record is brought back into the working set. - **Get Column Stats** Returns summary statistics for a column across the stored records. - **Get Record Changes** Returns what has changed on a record, which is the audit read behind a disputed figure. ### Designer and Publishing 13 - **Get Designer Application** Returns the designer's view of an application, which is the authoring side rather than the runtime one. - **Get Application Status** Answers whether a published version exists and whether unpublished work is waiting. The first check any release flow should run. - **List Transactions** Lists the published versions of an application. A transaction is a published version of the model, and it is what a calculation is really addressed to. - **Start New Transaction** Opens a new working version so the model can be changed. - **Delete Active Transaction** Throws away the unpublished work in progress. - **Publish Application** Makes the working version live. Everything calculated afterwards uses it unless a flow pins an older sequence. - **Get Validation Messages** Returns what the designer flagged about the working version, which is the evidence a publish decision should rest on. - **Clear Validation Messages** Clears those messages. - **Export Application** Exports an application's definition. - **List Named Ranges** Lists the workbook's named ranges, which are the inputs an application accepts and the outputs it returns. Where a flow discovers a model's interface rather than assuming it. - **List Used Named Ranges** Lists the named ranges actually in use, which is the narrower and usually more useful set. - **List Excel Exports** Lists the Excel exports an application defines. - **Get Excel Export** Retrieves one Excel export. ### Documents 3 - **Get Document Stubs** Lists the placeholders a print template contains, so a flow supplies exactly the right replacements rather than guessing at field names. - **Generate Document** Fills a print template and returns the document. Storing it server side returns a document key, which is what makes merging possible. - **Merge Documents** Joins generated documents into one. Only documents generated with server-side storage can be merged. ### Workspace 13 - **List Tags** Lists the workspace's tags. - **Get Tag** Returns one tag. - **Create Tag** Creates a tag. - **Update Tag** Changes a tag, which changes it everywhere it is applied. - **Delete Tag** Removes a tag. - **List Workspace Users** Lists the people in the workspace. - **Get Workspace User** Returns one workspace user. - **Apply User Template** Applies a user template to a person, which is how a standard set of permissions is granted without setting them one at a time. - **Remove Workspace User** Removes somebody from the workspace. - **List Invites** Lists outstanding invitations. - **Create Invite** Invites somebody into the workspace. - **Resend Invite** Sends an invitation again. It respects only the workspace and the invite identifier, so nothing else in the call changes the invitation. - **Delete Invite** Cancels an invitation. ### Sharing 4 - **List Data Share Links** Lists the public links currently published, which is how a flow audits what is reachable without a sign in. - **Create Data Share Link** Publishes one stored record to anyone holding the URL, with no sign in. The mode decides whether the holder can view the record or change it, and an expiration time is worth setting because a link without one does not expire. - **Update Data Share Link** Changes an existing link, including its mode and expiry. - **Delete Data Share Link** Removes a link, which is the fastest way to cut off access. ### Data Layouts 8 - **List Data Layouts** Lists the saved views of an application's stored records. - **Get Data Layout** Returns one layout. - **Create Data Layout** Creates a saved view. - **Update Data Layout** Changes a saved view. - **Delete Data Layout** Removes a saved view. - **Apply Data Layout** Gives a layout to other people, which is how a view is standardized across a team. - **Select Data Layout** Sets the caller's own default layout. It affects only the connected user, not anybody else. - **Get Data Layout Relations** Returns how layouts relate to the applications and users they belong to. ## Frequently Asked Questions ### What can FlowRunner do with SpreadsheetWeb Hub? FlowRunner agents can run Calculate, Calculate Advanced, and Calculate Multiple in SpreadsheetWeb Hub, plus 70 more actions. ### Does connecting SpreadsheetWeb Hub to FlowRunner require OAuth? Yes. SpreadsheetWeb Hub connects to FlowRunner with OAuth 2.0, so agents authenticate without handling raw credentials. ### Can SpreadsheetWeb Hub trigger a FlowRunner workflow automatically? SpreadsheetWeb Hub doesn't currently expose triggers in FlowRunner. It connects as an action step inside workflows started by another trigger. **Work at SpreadsheetWeb Hub?** This integration exposes SpreadsheetWeb Hub to AI agents on every FlowRunner plan, including through MCP, at no cost to you. [See what FlowRunner offers integration partners](https://flowrunner.ai/integrations/partners), including how to keep this page current. --- Markdown version of https://flowrunner.ai/integrations/spreadsheetweb-hub. Site index: https://flowrunner.ai/llms.txt