Microsoft Excel + SOS Inventory

Create new rows in Microsoft Excel for new invoices in SOS Inventory

Create a seamless connection between your SOS Inventory and Microsoft Excel with this convenient workflow. As soon as a new invoice is generated in SOS Inventory, this workflow immediately adds a row to your selected Excel spreadsheet. This way, you'll stay organized and up-to-date on your invoicing without any extra manual steps, solving the hassle of transferring data between platforms.

When this happens...
New Invoice
Triggers when a new invoice 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

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.