Integration
Connect inFlow Inventory to Microsoft Excel
When New or Updated Customer fires in inFlow Inventory, your agent runs Add Table Row in Microsoft Excel. Describe the whole flow and it is built, tested on every scenario and kept running.
What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.
Build solutions, not workarounds.
What do you want inFlow Inventory and Microsoft Excel to do together?
Ask the assistant
Connect your AI client
Give your AI client this address.
https://mcp.apiant.aiAny client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.
Set it up in your client
Claude Code
Run this in the directory you want to work in.
claude mcp add --transport http -s project apiant-ai https://mcp.apiant.aiStart Claude Code there, approve the server, and sign in in the browser page it opens.
Claude Code guide (opens in a new tab)Claude, web and desktop
Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.
Setup guide (opens in a new tab)Cursor
Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.
Setup guide (opens in a new tab)Zed
Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.
Setup guide (opens in a new tab)Codex and the ChatGPT desktop app
Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.
Setup guide (opens in a new tab)Any other MCP client
Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.
Setup guide (opens in a new tab)Example flows
What inFlow Inventory can start in Microsoft Excel
When New or Updated Customer in inFlow Inventory
then Add Table Row in Microsoft Excel
When New or Updated Manufacturing Order in inFlow Inventory
then Add Chart in Microsoft Excel
Starting points drawn from the triggers and actions in the catalog today. Describe the flow you need, at any depth, and your agent builds it and tests every scenario before it ships.
Everything your agent can do with inFlow Inventory and Microsoft Excel
Triggers and actions 10 triggers · 117 actions
Trigger
New or Updated CustomerTriggers when a customer is created or updated.
Trigger
New or Updated Manufacturing OrderTriggers when a manufacturing order is created or updated.
Trigger
New or Updated Purchase OrderTriggers when a purchase order is created or updated.
Trigger
New or Updated Purchase QuoteTriggers when a purchase quote is created or updated.
Trigger
New or Updated Sales OrderTriggers when a sales order is created or updated.
Trigger
New or Updated Sales QuoteTriggers when a sales quote is created or updated.
Trigger
New or Updated Stock AdjustmentTriggers when a stock adjustment is created or updated.
Trigger
New or Updated Stock CountTriggers when a stock count is created or updated.
Trigger
New or Updated Stock TransferTriggers when a stock transfer is created or updated.
Trigger
New or Updated VendorTriggers when a vendor is created or updated.
Action
Approve Purchase OrderApproves 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 OrderConverts a purchase quote into a purchase order, the same as the Convert to order action in inFlow.
Action
Convert Sales Quote to Sales OrderConverts an inFlow sales quote into a sales order, the same as the Convert to order action in inFlow.
Action
Create a ProductCreates a new product in inFlow Inventory.
Action
Create a Sales OrderCreates a new sales order (or sales quote) in inFlow for a customer, with optional product lines, addresses and custom fields.
Action
Create a Stock AdjustmentCreates a stock adjustment
Action
Create a Stock CountCreates a stock count
Action
Create a Stock Count SheetCreates a new stock count sheet.
Action
Create a Stock TransferCreates a stock transfer
Action
Create a VendorCreates a vendor
Action
Create CustomerCreates a customer
Action
Create Manufacturing OrderCreates a new manufacturing order
Action
Create Purchase OrderCreates a purchase order
Action
Find a Adjustment ReasonFinds adjustment reasons in inFlow Inventory by name.
Action
Find a CategoryFinds categories whose name contains the text you enter and returns the first match plus every match.
Action
Find a Count SheetLooks up an inFlow count sheet by its ID.
Action
Find a Custom DocumentFinds 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 CustomerReturns the inFlow customers that match the given criteria (name, email, phone, address and more).
Action
Find a LocationReturns up to 100 inFlow locations whose name contains the given text.
Action
Find a Manufacturing OrderFinds manufacturing orders in inFlow by order number, status, dates, location or assignee. Returns every match plus the first matching order.
Action
Find a Payment TermFinds payment terms in inFlow whose name contains the given text.
Action
Find a Pricing SchemeReturns the pricing schemes whose name contains the specified text.
Action
Find a ProductReturns up to 100 inFlow products matching the name, barcode, description, smart search text or other filters supplied.
Action
Find a Purchase OrderFinds purchase orders by order number or other filters and returns the matches.
Action
Find a Sales OrderSearch for the details of a sales order by a Sales Order ID or Sales Order Number.
Action
Find a Stock AdjustmentSearch for the details of a Stock Adjustment by a Stock Adjustment ID or Stock Adjustment Number.
Action
Find a Stock CountSearch for the details of a Stock Count by a Stock Count ID or Stock Count Number.
Action
Find a Stockroom ScanFinds stockroom scans by scan number. inFlow has deprecated this endpoint; newer scans are recorded as stock adjustments.
Action
Find a Stock TransferSearch for the details of a Stock Transfer by a Stock Transfer ID or Stock Transfer Number.
Action
Find a Taxing SchemeSearch for the details of a taxing scheme by Name.
Action
Find a VendorFinds 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 DocumentFinds 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 DocumentSearches for a manufacturing order document by document type.
Action
Find or Create a ProductReturns the product with exactly the given name, creating it first if no such product exists.
Action
Find or Create a Purchase Order DocumentSearches for a purchase order document by document type.
Action
Find or Create a Sales Order DocumentLooks 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 DocumentSearches for a stock adjustment document by document type.
Action
Find or Create a Stock Count DocumentSearches for a stock count document by document type.
Action
Find or Create a Stock Transfer DocumentSearches for a stock transfer document by document type.
Action
Find or Create a VendorSearches for a vendor by ID or name and creates a new vendor if it doesn't exist.
Action
Find or Create a Vendor DocumentSearches for a vendor document by document type.
Action
Find or Create CustomerFinds a customer by exact name; if none exists, creates one with the supplied details.
Action
Find or Create Customer by EmailLooks 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 EmailSearches for a vendor by Email and/or name and creates a new vendor if it doesn't exist.
Action
Fulfill Purchase OrderMarks every line of a purchase order as received and adds the corresponding stock, the same as the Fulfill button in inFlow.
Action
Fulfill Sales OrderQuick-fulfills a sales order in one step.
Action
Invoice Sales OrderQuick-invoices a sales order.
Action
List CustomersReturns all customers in the inFlow account, with pagination.
Action
List LocationsLists the locations (warehouses, stores) in your inFlow account.
Action
List Manufacturing OrdersLists manufacturing orders in inFlow, optionally filtered by number, status, dates, location or assignee. Returns up to 100 orders.
Action
List ProductsLists 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 OrdersReturns all purchase orders, with pagination.
Action
List Sales OrdersReturns all sales orders, with pagination.
Action
List Stock CountsReturns all stock counts, with pagination.
Action
List VendorsReturns all vendors in the inFlow account, with pagination.
Action
Pay Sales OrderMarks an inFlow sales order as paid, the same as the Mark paid button in inFlow.
Action
Ship Sales OrderMarks a sales order as quick-shipped (final fulfillment step).
Action
Update a Manufacturing OrderUpdates an existing manufacturing order by ID. Only the fields you fill in are changed.
Action
Update a ProductUpdates a product given their ID.
Action
Update a Purchase OrderUpdates an existing purchase order in inFlow by ID. Only the fields you fill in are changed.
Action
Update a Sales OrderUpdates a sales order given their ID.
Action
Update a Stock AdjustmentUpdates a stock adjustment given their ID.
Action
Update a Stock CountUpdates a stock count given their ID.
Action
Update a Stock Count SheetUpdates a stock count sheet.
Action
Update a Stockroom ScanUpdates a stockroom scan in inFlow. inFlow marks this endpoint deprecated; new scans are stored as stock adjustments.
Action
Update a Stock TransferUpdates a stock transfer given their ID.
Action
Update CustomerUpdates a customer given their ID.
Action
Update VendorUpdates an existing vendor by ID. Fields left blank keep their current values.
Action
Add ChartAdd a chart to a worksheet using microsoft graph api.
Action
Add Sharepoint WorksheetAdd a new worksheet to a sharepoint excel workbook using microsoft graph sites api.
Action
Add TableCreate a table over a range in an Excel workbook.
Action
Add Table ColumnAdd a column to a table using microsoft graph api.
Action
Add Table RowAdd a row to a table using microsoft graph api.
Action
Add Workbook PermissionTool to grant access to a workbook via invite. use when you need to share a specific workbook file with designated recipients and roles.
Action
Add WorksheetAdd a new worksheet to an excel workbook using microsoft graph api.
Action
Apply Table FilterApply a filter to a table column using microsoft graph api.
Action
Apply Table SortApply a sort to a table using microsoft graph api.
Action
Clear RangeTool to clear values, formats, or contents in a specified worksheet range. use when you need to reset cells before adding new data.
Action
Clear Table FilterClear a filter from a table column using microsoft graph api.
Action
Close SessionTool to close an existing excel workbook session. use when you need to explicitly end a persistent session to release workbook locks.
Action
Convert Table To RangeConvert a table to a range using microsoft graph api.
Action
Create WorkbookCreate an .xlsx workbook in the user's OneDrive, from a file URL or blank.
Action
Delete Table ColumnDelete a column from a table using microsoft graph api.
Action
Delete Table RowDelete a row from a table using microsoft graph api.
Action
Delete WorksheetTool to delete a worksheet from the workbook. use when cleaning up unused or temporary sheets after verifying no dependencies exist. example: "delete 'sheet2' after review."
Action
Get Chart AxisTool to retrieve a specific axis from a chart. use when you need properties like min, max, interval, and formatting of the chart axis.
Action
Get Chart Data LabelsTool to retrieve the data labels object of a chart. use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.
Action
Get Chart LegendTool to retrieve the legend object of a chart. use after creating or updating a chart when you need to inspect legend visibility and formatting.
Action
Get RangeGet a range from a worksheet using microsoft graph api.
Action
Get SessionCreate a session for an excel workbook using microsoft graph api.
Action
Get Sharepoint RangeGet a range from a worksheet in sharepoint using microsoft graph sites api.
Action
Get Sharepoint WorksheetGet a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api.
Action
Get Table ColumnTool to retrieve a specific column from a workbook table. use when you need to fetch column properties and data by its id or name.
Action
Get WorkbookTool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets.
Action
Get WorksheetGet a worksheet by name or id from an excel workbook using microsoft graph api.
Action
Insert RangeTool to insert a new cell range into a worksheet, shifting existing cells down or right. use when you need to create space for new content without overwriting.
Action
List ChartsList charts in a worksheet using microsoft graph api.
Action
List Chart SeriesTool to list all data series in a chart. use when you need to enumerate chart series for further analysis.
Action
List CommentsTool to list comments in an excel workbook. use when you need to retrieve all workbook comments via microsoft graph api.
Action
List FilesList files and folders in a drive root or specified path.
Action
List Named ItemsList named items in a workbook using microsoft graph api.
Action
List Sharepoint TablesList tables in a sharepoint worksheet using microsoft graph sites api.
Action
List Sharepoint WorksheetsList worksheets in an excel workbook stored in sharepoint using microsoft graph sites api.
Action
List Table ColumnsList columns in a table using microsoft graph api.
Action
List Table RowsList rows in a table using microsoft graph api.
Action
List TablesList tables in a worksheet using microsoft graph api.
Action
List Workbook PermissionsTool to list permissions set on the workbook file. use when you need to see which users or links have access to a specific excel file by supplying its drive and item ids. example: "list permissions for workbook with drive id 'b!abc123' and item id '0123456789abcdef'."
Action
List WorksheetsList worksheets in an excel workbook using microsoft graph api.
Action
Merge CellsMerge cells in a worksheet range using microsoft graph api.
Action
Protect WorksheetTool to protect a worksheet using optional protection options. use when you need to prevent editing certain parts of a sheet before sharing. example: "protect 'sheet1' to lock formatting and sorting."
Action
Sort RangeSort a range in a worksheet using microsoft graph api.
Action
Update ChartUpdate a chart in a worksheet using microsoft graph api.
Action
Update Chart LegendTool to update formatting or position of a chart legend. use when adjusting legend settings after confirming chart and worksheet exist.
Action
Update RangeUpdate a range in a worksheet using microsoft graph api.
Action
Update Sharepoint RangeUpdate a range in a sharepoint worksheet using microsoft graph sites api.
Action
Update TableUpdate a table in a workbook using microsoft graph api.
Action
Update WorksheetUpdate worksheet properties (name, position) in an excel workbook using microsoft graph api.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Each app on its own
Reviews
What our customers say
More from inFlow Inventory
inFlow Inventory to SalesforceSalesforce is a leading enterprise customer relationship management (CRM) platform.
inFlow Inventory to SlackSlack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...
inFlow Inventory to MailchimpMailchimp marketing automation and email platform.
inFlow Inventory to StripeStripe is a payment processing platform for online businesses.
inFlow Inventory to ShopifyShopify is a commerce platform for online stores and retail point-of-sale.
inFlow Inventory to QuickBooks OnlineQuickBooks Online accounting — manage customers, invoices, bills, payments, vendors, expenses, and more via...
More into Microsoft Excel
HubSpot to Microsoft ExcelHubSpot is your all-in-one stop for all of your marketing software needs.
Salesforce to Microsoft ExcelSalesforce is a leading enterprise customer relationship management (CRM) platform.
Slack to Microsoft ExcelSlack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...
Google Sheets to Microsoft ExcelGoogle Sheets
Gmail to Microsoft ExcelGmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...
Google Calendar to Microsoft ExcelGoogle Calendar is a time management tool providing scheduling features, event reminders, and integration...
Questions
inFlow Inventory and Microsoft Excel, answered
What can start an automation from inFlow Inventory?
Any of inFlow Inventory's 10 triggers in the catalog, including New or Updated Customer, New or Updated Manufacturing Order, New or Updated Purchase Order and New or Updated Purchase Quote. Describe the moment in plain language and your agent picks the right one.
What can your agent do in Microsoft Excel when something happens in inFlow Inventory?
Any of Microsoft Excel's 49 actions, including Create Workbook, Update Chart, Update Chart Legend and Update Range. Your agent maps the data both ways and tests every scenario before it ships.
Can it also run from Microsoft Excel to inFlow Inventory?
Microsoft Excel has no triggers in the catalog today, so automations start in inFlow Inventory. If you need the other direction, ask: your agent reads Microsoft Excel's API documentation and adds it.
Do I have to build a connector for inFlow Inventory or Microsoft Excel?
No. Both are in the catalog with their triggers and actions. You describe the automation; your agent builds it, tests every scenario and keeps it running.
What happens when something fails?
Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.
Is there a free plan?
Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.