Microsoft Excel + SOS Inventory

Add rows to Microsoft Excel for new purchase orders in SOS Inventory

Stay on top of your inventory management with this convenient automation. When a new purchase order is created in SOS Inventory, this workflow will add a row to your Microsoft Excel spreadsheet with the relevant order details. Keep your records up to date and organized without manual data entry, saving you time and ensuring accuracy.

When this happens...
New Purchase Order
Triggers when a new purchase order is created.
TriggerScheduled
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

New Invoice
Triggers when a new invoice is created.
Trigger
Scheduled
Try It
New Customer
Triggers when a new customer is created.
Trigger
Scheduled
Try It
New Sales Receipt
Triggers when a new sales receipt is created.
Trigger
Scheduled
Try It
New Shipment
Triggers when a new shipment is created.
Trigger
Scheduled
Try It
- Order numberRequired
- Date/timeRequired
- CustomerRequired
- Create customer if not found in SOS Inventory
- Location
- Billing company
- Billing contact
- Billing phone
- Billing email
- Billing address line 1
- Billing address line 2
- Billing address line 3
- Billing address line 4
- Billing address line 5
- Billing address city
- Billing address state/province
- Billing address postal code
- Billing address country
- Shipping company
- Shipping contact
- Shipping phone
- Shipping email
- Shipping address line 1
- Shipping address line 2
- Shipping address line 3
- Shipping address line 4
- Shipping address line 5
- Shipping address city
- Shipping address state/province
- Shipping address postal code
- Shipping address country
- Comment
- Terms
- Channel
- Priority
- ItemRequired
- Description
- QuantityRequired
- Unit priceRequired
- Amount
Action
Write

- Customer name
- Email
Action
Search
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It

- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

- Location
Trigger
Instant
Try It
New Purchase Order
Triggers when a new purchase order is created.
Trigger
Scheduled
Try It
New Sales Order
Triggers when a new sales order is created.
Trigger
Scheduled
Try It
- NameRequired
- Email addressRequired
- Website
- Phone
- Alternate phone number
- Fax number
- Company name
- Billing line 1
- Billing line 2
- Billing line 3
- Billing line 4
- Billing line 5
- Billing city
- Billing state or province
- Billing postal code
- Billing country
- Shipping line 1
- Shipping line 2
- Shipping line 3
- Shipping line 4
- Shipping line 5
- Shipping city
- Shipping state or province
- Shipping postal code
- Shipping country
- Customer notes
- Parent customer
- Terms
- Payment method
Action
Write
- Order numberRequired
- Date/timeRequired
- CustomerRequired
- Create customer if not found in SOS Inventory
- Location
- Billing company
- Billing contact
- Billing phone
- Billing email
- Billing address line 1
- Billing address line 2
- Billing address line 3
- Billing address line 4
- Billing address line 5
- Billing address city
- Billing address state/province
- Billing address postal code
- Billing address country
- Shipping company
- Shipping contact
- Shipping phone
- Shipping email
- Shipping address line 1
- Shipping address line 2
- Shipping address line 3
- Shipping address line 4
- Shipping address line 5
- Shipping address city
- Shipping address state/province
- Shipping address postal code
- Shipping address country
- Comment
- Terms
- Channel
- Priority
- ItemRequired
- Description
- QuantityRequired
- Unit priceRequired
- Amount
Action
Write
- Search query
- Start date
- End date
Action
Search
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.