Microsoft Excel + Stax

Track new Stax payments by adding rows in Microsoft Excel

Enjoy a streamlined financial management process with this dynamic workflow. When a new payment comes through your Stax app, a row will be instantly added in your Microsoft Excel file, ensuring easy and updated record-keeping. This powerful integration gives you a seamless way of tracking payments, enhancing your business's efficiency and accuracy.

When this happens...
New Payment
Triggers when a new payment (transaction) is posted to your account.
TriggerInstant
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 Customer
Triggers when a new customer is created.
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Instant
Try It
New Scheduled Invoice
Triggers when a new scheduled invoice is created.
Trigger
Instant
Try It
Deleted Catalog Item
Triggers when a catalog item has been deleted.
Trigger
Instant
Try It
List Payment
Lists your Payments.
Trigger
Scheduled
Try It

Updated Dispute
Triggers when an existing dispute is updated. Note that the API does not highlight which field(s) have updated.
Trigger
Instant
Try It
Updated Catalog Item
Triggers when an existing catalog item has been updated. Note that the API does not highlight which field(s) have updated.
Trigger
Instant
Try It

Updated Payment
Triggers when a payment (transaction) is updated. Example, a payment is linked to a new customer. Note that a refund is considered a new transaction.
Trigger
Instant
Try It
- Customer
- Internal Memo
- Reference
- The amount of tax to collect
- The subtotal of all line itemsRequired
- The grand total to charge for the invoiceRequired
- Due Date
- Number of line items to populateRequired
- Line items will be populated by:
- Send this now to the customer's email?
- Optionally set a different date for this invoice, defaults to right now
Action
Write
- Customer
- Schedule TypeRequired
- Start OnRequired
- Run IntervalRequired
- Schedule this many timesRequired
- Internal Memo
- Reference
- The amount of tax to collect
- The subtotal of all line itemsRequired
- The grand total to charge for the invoiceRequired
- Number of line items to populateRequired
- Line items will be populated by:
- Send this now to the customer's email?
- Optionally set a different date for this invoice, defaults to right now
Action
Write
- The Item's unique identifier in the catalogRequired
- Item NameRequired
- Number in StockRequired
- Item Code
- Base Price
- Category
- Item Details
- Is Active?
- Is Taxable?
- Is Discount?
- Is Percentage?
- Is Subscription?
- Is Service?
Action
Write
- Search by keywordRequired
Action
Search
- Search by customerRequired
Action
Search
- Search by keywordRequired
Action
Search
- Search by keywordRequired
- Customer
- Internal Memo
- Reference
- The amount of tax to collect
- The subtotal of all line itemsRequired
- The grand total to charge for the invoiceRequired
- Due Date
- Number of line items to populateRequired
- Line items will be populated by:
- Send this now to the customer's email?
- Optionally set a different date for this invoice, defaults to right now
Action
Search or write
- Search by keywordRequired
- Customer
- Schedule TypeRequired
- Start OnRequired
- Run IntervalRequired
- Schedule this many timesRequired
- Internal Memo
- Reference
- The amount of tax to collect
- The subtotal of all line itemsRequired
- The grand total to charge for the invoiceRequired
- Number of line items to populateRequired
- Line items will be populated by:
- Send this now to the customer's email?
- Optionally set a different date for this invoice, defaults to right now
Action
Search or write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

New Dispute
Triggers when a new dispute is created.
Trigger
Instant
Try It
New Catalog Item
Triggers when a new catalog item is created.
Trigger
Instant
Try It
New Payment
Triggers when a new payment (transaction) is posted to your account.
Trigger
Instant
Try It
Deleted Scheduled Invoice
Triggers when a scheduled invoice has been deleted.
Trigger
Instant
Try It
Updated Customer
Triggers when a an existing customer is updated. Note that the API does not highlight which field(s) have updated.
Trigger
Instant
Try It
Updated Invoice
Triggers when a new invoice is updated. Note that the API does not highlight which field(s) have updated.
Trigger
Instant
Try It
Updated Scheduled Invoice
Triggers when an existing scheduled invoice is updated. Examples: occurence dates changed, amount changes. Note that the API does not highlight which field(s) have updated.
Trigger
Instant
Try It
- First/Given NameRequired
- Last/Family NameRequired
- Email AddressRequired
- Allow Customer to Pay With Credit Card
- Company associated with this customer
- Phone Number
- SMS Number
- Street Address, Line 1
- Street Address, Line 2
- City
- State/Province
- Zip/Postal Code
- Country
- Reference
- Notes about Customer
Action
Write
- Item NameRequired
- Number in StockRequired
- Item Code
- Base Price
- Category
- Item Details
- Is Active?
- Is Taxable?
- Is Discount?
- Is Percentage?
- Is Subscription?
- Is Service?
Action
Write
- Total to ChargeRequired
- Payment MethodRequired
- Invoice
- Create Pre-Authorization?Required
- First/Given NameRequired
Action
Write
- Search by keywordRequired
Action
Search
- Search by keywordRequired
Action
Search
- Search by keywordRequired
Action
Search
- Search by keywordRequired
- First/Given NameRequired
- Last/Family NameRequired
- Email AddressRequired
- Allow Customer to Pay With Credit Card
- Company associated with this customer
- Phone Number
- SMS Number
- Street Address, Line 1
- Street Address, Line 2
- City
- State/Province
- Zip/Postal Code
- Country
- Reference
- Notes about Customer
Action
Search or write
- Search by keywordRequired
- Item NameRequired
- Number in StockRequired
- Item Code
- Base Price
- Category
- Item Details
- Is Active?
- Is Taxable?
- Is Discount?
- Is Percentage?
- Is Subscription?
- Is Service?
Action
Search or write
- Search by keywordRequired
- Total to ChargeRequired
- Payment MethodRequired
- Invoice
- Create Pre-Authorization?Required
- First/Given NameRequired
Action
Search or write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- FolderRequired
- 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.

Help

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About Stax

Stax makes it easy to accept payments in-person and online and provides businesses with the tools they need to grow.

Learn more Help

Related categories

Payment Processing

PRODUCTS

CAPABILITIES

By team

Microsoft Excel + Stax

Track new Stax payments by adding rows in Microsoft Excel

New Customer

New Invoice

New Scheduled Invoice

Deleted Catalog Item

List Payment

Updated Dispute

Updated Catalog Item

Updated Payment

Create Invoice

Customer

Internal Memo

Reference

The amount of tax to collect

The grand total to charge for the invoiceRequired

Due Date

Number of line items to populateRequired

Line items will be populated by:

Send this now to the customer's email?

Optionally set a different date for this invoice, defaults to right now

Create Scheduled Invoice

Customer

Schedule TypeRequired

Start OnRequired

Run IntervalRequired

Schedule this many timesRequired

Internal Memo

Reference

The amount of tax to collect

The subtotal of all line itemsRequired

The grand total to charge for the invoiceRequired

Number of line items to populateRequired

Line items will be populated by:

Send this now to the customer's email?

Optionally set a different date for this invoice, defaults to right now

Update Catalog Item

The Item's unique identifier in the catalogRequired

Item NameRequired

Number in StockRequired

Item Code

Base Price

Category

Item Details

Is Active?

Is Taxable?

Is Discount?

Is Percentage?

Is Subscription?

Is Service?

Find Invoices

Search by keywordRequired

Find Payment Methods

Search by customerRequired

Find Payments

Search by keywordRequired

Find or Create Invoice

Search by keywordRequired

Customer

Internal Memo

Reference

The amount of tax to collect

The subtotal of all line itemsRequired

The grand total to charge for the invoiceRequired

Due Date

Number of line items to populateRequired

Line items will be populated by:

Send this now to the customer's email?

Optionally set a different date for this invoice, defaults to right now

Find or Create Scheduled Invoice

Search by keywordRequired

Customer

Schedule TypeRequired

Start OnRequired

Run IntervalRequired

Schedule this many timesRequired

Internal Memo