ChargeOver + Google Sheets

Update Google Sheets with multiple invoice status changes from ChargeOver

Easily track your ChargeOver invoice changes in Google Sheets with this integration. When an invoice status changes within ChargeOver, corresponding rows are created in a designated Google Sheets, ensuring a thorough and seamless record of all status updates. Perfect for maintaining an automated, efficient ledger of your invoicing activity.

When this happens...
Invoice Status Changed
Triggers when a invoices status changes in ChargeOver.
TriggerInstant
automatically do this!
Create Multiple Spreadsheet Rows
Create one or more new rows in a specific spreadsheet (with line item support).
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 Contact
Triggers when a new contact is added to ChargeOver.
Trigger
Instant
Try It
New Customer
Triggers when a new customer is added to ChargeOver.
Trigger
Instant
Try It
New Invoice
Triggers when a new Invoice is added to ChargeOver.
Trigger
Instant
Try It
New Item (Product, Discount)
Triggers when a new item (product, discount) is added to ChargeOver.
Trigger
Instant
Try It
- Filter By Quote Status
Trigger
Instant
Try It

- Filter By Subscription Status
- Filter By Payment Method
- Filter By Payment Cycle
Trigger
Instant
Try It
Transaction Status Changed
Triggers when a transaction status changes in ChargeOver.
Trigger
Instant
Try It

Create a Customer
Create a new customer in ChargeOver.
Action
Write
Create an Invoice
Create a new Invoice in ChargeOver.
Action
Write
- Subscription ID #Required
- Cancellation Date
Action
Write
- Customer IDRequired
- Payment AmountRequired
Action
Write
- Find...Required
- That equals...Required
Action
Search
- Find...Required
- That equals...Required
Action
Search
- Find...Required
- That equals...Required
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
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
- 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
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- 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

Contact Was Updated
Triggers when a contact is updated in ChargeOver.
Trigger
Instant
Try It
- Filter By Customer Status
Trigger
Instant
Try It
- Filter By Invoice Status
Trigger
Instant
Try It
New Quote
Triggers when a new quote is added to ChargeOver.
Trigger
Instant
Try It
- Filter By Payment Method
- Filter By Payment Cycle
Trigger
Instant
Try It
- Filter By Transaction Type
- Filter By Gateway Status
Trigger
Instant
Try It
Create a Contact
Create a new contact in ChargeOver.
Action
Write
- Customer IDRequired
Action
Write
Create a Quote
Create a new quote in ChargeOver.
Action
Write
Create a Subscription
Create a new subscription in ChargeOver.
Action
Write
- Find...Required
- That equals...Required
Action
Search
- Find...Required
- That equals...Required
Action
Search
- Find...Required
- That equals...Required
Action
Search
- Find...Required
- That equals...Required
Action
Search
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
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 ChargeOver

Go beyond recurring and subscription billing with ChargeOver. Simplify how you manage billing workflows, increase customer satisfaction with easy no-code pages, and stay organized with reports and data!

Learn more