Google Sheets + Stax

Update Google Sheets rows with new customers from Stax

When a new customer is added in Stax, ensure their details are seamlessly captured on your Google Sheets. This workflow makes it possible by updating a spreadsheet row in your Google Sheets with the new customer's data from Stax. Perfect for maintaining an up-to-date customer database, having the latest information right at your fingertips. The end result: efficient customer management without manual data entry.

When this happens...
New Customer
Triggers when a new customer is created.
TriggerInstant
automatically do this!
Update Spreadsheet Row
Update a row in a specific spreadsheet.
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
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

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
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

Related categories

Similar apps

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

Related Zap Templates

Create rows in a Google Sheet for new payments completed in Stax

Related Zap Templates

Create rows in a Google Sheet for new payments completed in Stax

Google Sheets + Stax

Update Google Sheets rows with new customers from Stax

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

Due Date

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

Internal Memo

Reference

The amount of tax to collect

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

Item Code

Base Price

Category

Item Details

Is Active?

Is Taxable?

Is Discount?

Is Percentage?

Is Subscription?

Is Service?

Find Invoices

Find Payment Methods

Find Payments

Find or Create Invoice

Customer

Internal Memo

Reference

The amount of tax to collect

Due Date

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

Customer

Internal Memo

Reference

The amount of tax to collect

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

New Spreadsheet Row (Team Drive)

Drive

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

Trigger Column

Create Spreadsheet Column

Drive

Index

Create Multiple Spreadsheet Rows

Drive

Create Spreadsheet

Spreadsheet to Copy

Headers

Clear Spreadsheet Row

Drive

Update Spreadsheet Row

Drive

API Request (Beta)

Api Docs Info

Query String Parameters