Google Sheets + Stax
Create rows in a Google Sheet for new payments completed in Stax
If you use Google Sheets to monitor your payment activity, you can automate the process so you don't have to manually enter the payment information into Google Sheets. With this integration, every time a transaction is processed in Stax's Omni platform, the transaction information will be sent as a new row to the Google Sheet of your choice.
If you use Google Sheets to monitor your payment activity, you can automate the process so you don't have to manually enter the payment information into Google Sheets. With this integration, every time a transaction is processed in Stax's Omni platform, the transaction information will be sent as a new row to the Google Sheet of your choice.
- When this happens...
New PaymentTriggers when a new payment (transaction) is posted to your account.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Customer
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when a new invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Scheduled Invoice
Triggers when a new scheduled invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Catalog Item
Triggers when a catalog item has been deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Payment
Lists your Payments.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUpdated Dispute
Triggers when an existing dispute is updated. Note that the API does not highlight which field(s) have updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Catalog Item
Triggers when an existing catalog item has been updated. Note that the API does not highlight which field(s) have updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search by keywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch by customerRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch by keywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Dispute
Triggers when a new dispute is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Catalog Item
Triggers when a new catalog item is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Payment
Triggers when a new payment (transaction) is posted to your account.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Scheduled Invoice
Triggers when a scheduled invoice has been deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Customer
Triggers when a an existing customer is updated. Note that the API does not highlight which field(s) have updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Invoice
Triggers when a new invoice is updated. Note that the API does not highlight which field(s) have updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Item NameRequired
Number in StockRequired
Item Code
Base Price
Category
Item Details
Is Active?
Is Taxable?
Is Discount?
Is Percentage?
Is Subscription?
Is Service?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Total to ChargeRequired
Payment MethodRequired
Invoice
Create Pre-Authorization?Required
First/Given NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search by keywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch by keywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch by keywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch 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?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch by keywordRequired
Total to ChargeRequired
Payment MethodRequired
Invoice
Create Pre-Authorization?Required
First/Given NameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
