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

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
- 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
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- 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
- Overwrite existing worksheet with the same title
- Headers
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

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

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

Create Scheduled Invoice

Update Catalog Item

Find Invoices

Find Payment Methods

Find Payments

Find or Create Invoice

Find or Create Scheduled Invoice

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

New Dispute

New Catalog Item

New Payment

Deleted Scheduled Invoice

Updated Customer

Updated Invoice

Updated Scheduled Invoice

Create Customer

Create Item

Make a Payment

Find Customers

Find Items

Find Scheduled Invoices

Find or Create Customer

Find or Create Item

Find or Create Payment

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Stax

Related categories

Related Zap Templates

Related Zap Templates