Chargebee + Google BigQuery

Create rows in Google BigQuery for every new subscription in Chargebee

Effortlessly manage and analyze your new subscriptions data with this workflow. Whenever a new subscription is received in Chargebee, it swiftly creates rows in Google BigQuery. This efficient automation not only gives you a consolidated view of all your fresh subscription data but also lets you deep-dive into analytics without manual intervention. Say goodbye to data silos and let this seamless integration streamline your business processes.

When this happens...
New Subscription
Triggers when a subscription is created.
TriggerInstant
automatically do this!
Create Rows
Creates new rows of data in a table (accepts line items). Note: Does not create a job.
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

Card Expiration
Triggers when a credit card expires.
Trigger
Instant
Try It
New Customer
Triggers when a customer is created.
Trigger
Instant
Try It
Payment Failure
Triggers when a payment fails.
Trigger
Instant
Try It
Payment Method Updates
Triggers when a payment method is updated.
Trigger
Instant
Try It
Subscription Activation
Triggers when a subscription is changed from Trial to Active state.
Trigger
Instant
Try It

Subscription Cancellation
Triggers when a subscription is cancelled.
Trigger
Instant
Try It
New Subscription
Triggers when a subscription is created.
Trigger
Instant
Try It

Subscription Reactivation
Triggers when a subscription is moved from Cancelled state to Active/In Trial/Non Renewing/Future state.
Trigger
Instant
Try It
Change Next Billing Date
Updates next billing date of a subscription.
Action
Write
Create Subscription
Creates a new subscription. If you are on Catalog 1.0 of Chargebee, this action allows you to create a subscription and a customer in a single step. If you are on Catalog 2.0 of Chargebee, this action allows you to create a subscription for an existing customer
Action
Write
Record Offline Payment for an Invoice
Records an offline payment for unpaid invoices.
Action
Write
Update Customer
Updates customer details in Chargebee.
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Subscription IdRequired
Action
Search
- Customer IdRequired
- When a customer has multiple subscriptionsRequired
Action
Search
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

Customer Details Updates
Triggers when customer details such as first name, last name, email, billing address, etc., are updated.
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is generated(with line item support).
Trigger
Instant
Try It
New Payment Method
Triggers when a payment method is added.
Trigger
Instant
Try It
New Payment
Triggers when a payment is collected successfully.
Trigger
Instant
Try It
Subscription Cancellation Scheduled
Triggers when a subscription is scheduled for cancellation.
Trigger
Instant
Try It
Subscription Details Updates
Triggers when subscription details such as custom fields, billing information, recurring items etc., are modified.
Trigger
Instant
Try It
Subscription Pause
Triggers when a subscription is paused.
Trigger
Instant
Try It
Subscription Resumption
Triggers when a paused subscription is resumed.
Trigger
Instant
Try It
Create Customer
Creates a new customer in Chargebee.
Action
Write
Pause Subscription
Pauses a subscription in Chargebee.
Action
Write
Resume Subscription
Resumes a paused subscription in Chargebee.
Action
Write
Update Subscription
Updates a subscription in Chargebee.
Action
Write
- Customer Id
- Email
- Company
Action
Search
- Subscription IdRequired
- When a subscription has multiple invoicesRequired
Action
Search
- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search