Chargebee + Google BigQuery

Create rows in Google BigQuery for new payments in Chargebee

Keep your data up-to-date and organized efficiently. With this workflow, every time a new payment is received in Chargebee, a new row is created in Google BigQuery. This straightforward automation saves you the time and effort of manual data entry, ensuring a real-time reflection of your financial transactions in your BigQuery datasets.

When this happens...
New Payment
Triggers when a payment is collected successfully.
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

About Chargebee

Chargebee is a subscription management and recurring billing solution used by businesses to customize subscription billing workflows.

Learn more

Related categories

Payment Processing

Similar apps

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn more

Related categories

Related Zap Templates

Create rows in Google BigQuery for every new subscription in Chargebee

Manage payment failures in Chargebee by creating rows in Google BigQuery

Chargebee + Google BigQuery

Create rows in Google BigQuery for new payments in Chargebee

Card Expiration

New Customer

Payment Failure

Payment Method Updates

Subscription Activation

Subscription Cancellation

New Subscription

Subscription Reactivation

Change Next Billing Date

Create Subscription

Record Offline Payment for an Invoice

Update Customer

API Request (Beta)

Find Existing Subscription

Fetch Customer Subscription Details

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

Customer Details Updates

New Invoice

New Payment Method

New Payment

Subscription Cancellation Scheduled

Subscription Details Updates

Subscription Pause

Subscription Resumption

Create Customer

Pause Subscription

Resume Subscription

Update Subscription

Finds an Existing Customer

Fetch Subscription Invoice Details

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

About Chargebee

Related categories

Similar apps

Recurly

Cheddar

ChargeOver

About Google BigQuery

Related categories

Related Zap Templates

Related Zap Templates