Connect inFlow Inventory and Smartsheet

Both apps 100inFlow Inventory 78Smartsheet 22

• 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.

• Trigger
  New row

  Triggered when a new row is added to the specified sheet. Polls rows modified since the last check and emits new ones.

• Trigger
  New sheet

  Triggered when a new sheet is created. Polls the list of sheets and emits newly seen ones.

• Trigger
  Updated row

  Triggered when any row is updated in the specified sheet. Polls rows modified since the last check and emits updated ones.

• Action
  Add column

  /sheets/{sheetId}/columns - add columns to a sheet.

• Action
  Add comment

  /sheets/{sheetId}/discussions/{discussionId}/comments - add a comment to a discussion.

• Action
  Add folder

  /folders/{folderId}/folders or /home/folders - create a folder.

• Action
  Add row

  Adds a new row to the specified sheet. Provide cells as an array of {columnId, value}. Set location to Top or Bottom.

• Action
  Add sheet

  /sheets - create a sheet with columns.

• Action
  Copy row to another sheet

  Copies a row from one sheet to another sheet. The placement of the cells in the destination sheet is determined by Smartsheet's logic.

• Action
  Copy sheet

  /sheets/{sheetId}/copy - copy a sheet to a folder/workspace.

• Action
  Delete row

  Deletes a row from a sheet given its Row ID.

• Action
  Delete row if deal does not exist in ActiveCampaign (Cisco)

  Compares deals from ActiveCampaign with the Smartsheet 'ActiveCampaign Deal ID' column. Deletes rows whose deal ID is not present in the supplied list of existing ActiveCampaign deal IDs. Built from intent against Smartsheet API 2.0.

• Action
  Find rows

  Searches for rows in a specified sheet containing the specified value (in any column). Returns zero or more row IDs. Use the 'Get row' action within a Loop to fetch each row's contents.

• Action
  Find rows by column value

  Searches for rows in a specified sheet having the specified value in a specified column. Zero, one, or multiple row IDs may be returned.

• Action
  Find sheets by keyword

  Returns the sheets that match the specified keyword.

• Action
  Find single row

  Searches for a single row in a specified sheet matching the specified value (in any column). If zero or multiple rows are found, an error occurs.

• Action
  Find single row by column value

  Searches for a single row in a specified sheet having the specified value in a specified column. If zero or multiple rows are found, an error occurs.

• Action
  Get row

  Returns the column data for the specified row. An error occurs if the row is not found.

• Action
  Get sheet

  Fetches a sheet by ID, including its columns and rows. An error occurs if the sheet is not found.

• Action
  Move row to another sheet

  Moves a row from one sheet to another sheet. The placement of the cells in the destination sheet is determined by Smartsheet's logic.

• Action
  Update row

  Updates a row in a specified sheet. Provide the Row ID and cells as an array of {columnId, value}.

• Action
  Update sheet

  /sheets/{sheetId} - update sheet properties (name, project settings).

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