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.
- When this happens...

New PaymentTriggers when a new payment (transaction) is posted to your account.TriggerInstant - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Stax and Google Sheets
Discover other triggers and actions you can use with Stax and Google Sheets
New CustomerTriggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New InvoiceTriggers when a new invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Scheduled InvoiceTriggers when a new scheduled invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Deleted Catalog ItemTriggers when a catalog item has been deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
List PaymentLists your Payments.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Updated DisputeTriggers 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 ItemTriggers 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 PaymentTriggers 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 app- Search by customerRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search by keywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- 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
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- 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
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- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_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.- Api_docs_info
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- 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 DisputeTriggers when a new dispute is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Catalog ItemTriggers when a new catalog item is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New PaymentTriggers 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 InvoiceTriggers when a scheduled invoice has been deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated CustomerTriggers 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 InvoiceTriggers 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 InvoiceTriggers 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 app- Search by keywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search by keywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- 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
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- 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?
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- Search 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 found- Dont_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 plan- Drive
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 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.Search or writeFind existing data in your app, or create a new record if no data is found




