Connect Grist and inFlow Inventory

Both apps 103Grist 25inFlow Inventory 78

• Trigger
  New or Updated Record

  Triggered when a row in a Grist table is created or updated.

• Trigger
  New or Updated Record (Instant)

  Triggers when a Record is updated, or a new Record is added.

• Trigger
  New Record

  Triggered when a new row is added to a Grist table.

• Trigger
  New Record (Instant)

  Triggers when a new Record is created

• Action
  Add Column

  Adds a column to a table in a Grist document.

• Action
  Add Table

  Creates a new table in a Grist document, optionally with a starting set of columns.

• Action
  Create Document

  Creates a new document in a Grist workspace and returns its document ID.

• Action
  Create or Update Record

  Adds a row to a Grist table, or updates the existing row when the match column already holds the match value. Returns the row ID.

• Action
  Create Record

  Adds a new row to a Grist table and returns its row ID.

• Action
  Create Workspace

  Creates a new workspace in a Grist organization and returns its ID.

• Action
  Delete Document

  Deletes a Grist document permanently.

• Action
  Delete Records

  Deletes one or more rows from a Grist table by row ID.

• Action
  Delete Workspace

  Deletes a Grist workspace along with every document inside it.

• Action
  Find Record

  Searches a Grist table for a row whose column holds a given value and returns that row's ID and column values.

• Action
  Get Document

  Returns the details of one Grist document — its name, web address, workspace, and organization.

• Action
  Get Org

  Returns the details of one Grist organization (team site) — its name, subdomain, owner, and your access level.

• Action
  Get Workspace

  Returns the details of one Grist workspace, including the documents it contains.

• Action
  List Columns

  Returns the columns of a Grist table, with each column's ID, label, and type.

• Action
  List Orgs

  Returns every Grist organization (team site) this connection can reach.

• Action
  List Tables

  Returns the tables in a Grist document.

• Action
  List Workspaces

  Returns the workspaces in a Grist organization, each with the documents it contains.

• Action
  Run SQL Query

  Runs a read-only SELECT statement against a Grist document and returns the rows.

• Action
  Update Document

  Renames a Grist document or changes whether it is pinned. Anything left blank stays as it is.

• Action
  Update Record

  Changes the column values of one row in a Grist table. Columns left blank keep their current values.

• Action
  Update Workspace

  Renames a Grist workspace.

• Trigger
  New or Updated Customer

  Triggers when a customer is created or updated.

• Trigger
  New or Updated Manufacturing Order

  Triggers when a manufacturing order is created or updated.

• Trigger
  New or Updated Purchase Order

  Triggers when a purchase order is created or updated.

• Trigger
  New or Updated Purchase Quote

  Triggers when a purchase quote is created or updated.

• Trigger
  New or Updated Sales Order

  Triggers when a sales order is created or updated.

• Trigger
  New or Updated Sales Quote

  Triggers when a sales quote is created or updated.

• Trigger
  New or Updated Stock Adjustment

  Triggers when a stock adjustment is created or updated.

• Trigger
  New or Updated Stock Count

  Triggers when a stock count is created or updated.

• Trigger
  New or Updated Stock Transfer

  Triggers when a stock transfer is created or updated.

• Trigger
  New or Updated Vendor

  Triggers when a vendor is created or updated.

• Action
  Approve Purchase Order

  Approves an existing purchase order in inFlow, the same as clicking Approve in the inFlow app, and returns the updated purchase order.

• Action
  Convert Purchase Quote to Purchase Order

  Converts a purchase quote into a purchase order, the same as the Convert to order action in inFlow.

• Action
  Convert Sales Quote to Sales Order

  Converts an inFlow sales quote into a sales order, the same as the Convert to order action in inFlow.

• Action
  Create a Product

  Creates a new product in inFlow Inventory.

• Action
  Create a Sales Order

  Creates a new sales order (or sales quote) in inFlow for a customer, with optional product lines, addresses and custom fields.

• Action
  Create a Stock Adjustment

  Creates a stock adjustment

• Action
  Create a Stock Count

  Creates a stock count

• Action
  Create a Stock Count Sheet

  Creates a new stock count sheet.

• Action
  Create a Stock Transfer

  Creates a stock transfer

• Action
  Create a Vendor

  Creates a vendor

• Action
  Create Customer

  Creates a customer

• Action
  Create Manufacturing Order

  Creates a new manufacturing order

• Action
  Create Purchase Order

  Creates a purchase order

• Action
  Find a Adjustment Reason

  Finds adjustment reasons in inFlow Inventory by name.

• Action
  Find a Category

  Finds categories whose name contains the text you enter and returns the first match plus every match.

• Action
  Find a Count Sheet

  Looks up an inFlow count sheet by its ID.

• Action
  Find a Custom Document

  Finds inFlow records of the document type you choose (customers, vendors, products, sales orders, purchase orders and more) whose chosen field matches a value. Returns the first match plus every match on the first page.

• Action
  Find a Customer

  Returns the inFlow customers that match the given criteria (name, email, phone, address and more).

• Action
  Find a Location

  Returns up to 100 inFlow locations whose name contains the given text.

• Action
  Find a Manufacturing Order

  Finds manufacturing orders in inFlow by order number, status, dates, location or assignee. Returns every match plus the first matching order.

• Action
  Find a Payment Term

  Finds payment terms in inFlow whose name contains the given text.

• Action
  Find a Pricing Scheme

  Returns the pricing schemes whose name contains the specified text.

• Action
  Find a Product

  Returns up to 100 inFlow products matching the name, barcode, description, smart search text or other filters supplied.

• Action
  Find a Purchase Order

  Finds purchase orders by order number or other filters and returns the matches.

• Action
  Find a Sales Order

  Search for the details of a sales order by a Sales Order ID or Sales Order Number.

• Action
  Find a Stock Adjustment

  Search for the details of a Stock Adjustment by a Stock Adjustment ID or Stock Adjustment Number.

• Action
  Find a Stock Count

  Search for the details of a Stock Count by a Stock Count ID or Stock Count Number.

• Action
  Find a Stockroom Scan

  Finds stockroom scans by scan number. inFlow has deprecated this endpoint; newer scans are recorded as stock adjustments.

• Action
  Find a Stock Transfer

  Search for the details of a Stock Transfer by a Stock Transfer ID or Stock Transfer Number.

• Action
  Find a Taxing Scheme

  Search for the details of a taxing scheme by Name.

• Action
  Find a Vendor

  Finds inFlow vendors matching name, contact, email, phone, address or other filters, returning the first match and the full list.

• Action
  Find or Create a Customer Document

  Finds a customer whose name exactly matches the given name; if none exists, creates one with the supplied details. Returns the customer record either way.

• Action
  Find or Create a Manufacturing Order Document

  Searches for a manufacturing order document by document type.

• Action
  Find or Create a Product

  Returns the product with exactly the given name, creating it first if no such product exists.

• Action
  Find or Create a Purchase Order Document

  Searches for a purchase order document by document type.

• Action
  Find or Create a Sales Order Document

  Looks up a sales order by its order number and returns it; if no order has that number, creates a new sales order with it.

• Action
  Find or Create a Stock Adjustment Document

  Searches for a stock adjustment document by document type.

• Action
  Find or Create a Stock Count Document

  Searches for a stock count document by document type.

• Action
  Find or Create a Stock Transfer Document

  Searches for a stock transfer document by document type.

• Action
  Find or Create a Vendor

  Searches for a vendor by ID or name and creates a new vendor if it doesn't exist.

• Action
  Find or Create a Vendor Document

  Searches for a vendor document by document type.

• Action
  Find or Create Customer

  Finds a customer by exact name; if none exists, creates one with the supplied details.

• Action
  Find or Create Customer by Email

  Looks up an inFlow customer by exact email address and returns it; if none exists, creates a new customer with that email.

• Action
  Find or Create Vendor by Email

  Searches for a vendor by Email and/or name and creates a new vendor if it doesn't exist.

• Action
  Fulfill Purchase Order

  Marks every line of a purchase order as received and adds the corresponding stock, the same as the Fulfill button in inFlow.

• Action
  Fulfill Sales Order

  Quick-fulfills a sales order in one step.

• Action
  Invoice Sales Order

  Quick-invoices a sales order.

• Action
  List Customers

  Returns all customers in the inFlow account, with pagination.

• Action
  List Locations

  Lists the locations (warehouses, stores) in your inFlow account.

• Action
  List Manufacturing Orders

  Lists manufacturing orders in inFlow, optionally filtered by number, status, dates, location or assignee. Returns up to 100 orders.

• Action
  List Products

  Lists products in inFlow, optionally filtered by name, description, barcode, type, category, lot tracking, modification date or a smart search. Returns up to 100 products.

• Action
  List Purchase Orders

  Returns all purchase orders, with pagination.

• Action
  List Sales Orders

  Returns all sales orders, with pagination.

• Action
  List Stock Counts

  Returns all stock counts, with pagination.

• Action
  List Vendors

  Returns all vendors in the inFlow account, with pagination.

• Action
  Pay Sales Order

  Marks an inFlow sales order as paid, the same as the Mark paid button in inFlow.

• Action
  Ship Sales Order

  Marks a sales order as quick-shipped (final fulfillment step).

• Action
  Update a Manufacturing Order

  Updates an existing manufacturing order by ID. Only the fields you fill in are changed.

• Action
  Update a Product

  Updates a product given their ID.

• Action
  Update a Purchase Order

  Updates an existing purchase order in inFlow by ID. Only the fields you fill in are changed.

• Action
  Update a Sales Order

  Updates a sales order given their ID.

• Action
  Update a Stock Adjustment

  Updates a stock adjustment given their ID.

• Action
  Update a Stock Count

  Updates a stock count given their ID.

• Action
  Update a Stock Count Sheet

  Updates a stock count sheet.

• Action
  Update a Stockroom Scan

  Updates a stockroom scan in inFlow. inFlow marks this endpoint deprecated; new scans are stored as stock adjustments.

• Action
  Update a Stock Transfer

  Updates a stock transfer given their ID.

• Action
  Update Customer

  Updates a customer given their ID.

• Action
  Update Vendor

  Updates an existing vendor by ID. Fields left blank keep their current values.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.