Google BigQuery + Stripe

Create rows in Google BigQuery for new invoice items in Stripe

When a new invoice item is added in Stripe, this workflow instantly creates a detailed row in Google BigQuery. This automation improves your data collection process, giving you quick and efficient access to your invoice item data for in-depth analysis and business insights. Save time on manual data entry while gaining a comprehensive view of your invoicing records.

When this happens...
New Invoice Item
Triggers when a new invoice item is created.
TriggerPolling
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

Canceled Subscription
Triggers when a subscription is canceled (by a subscriber or due to end of billing period).
Trigger
Instant
Try It
Failed Payment
Triggers when a payment attempt fails.
Trigger
Instant
Try It
- Ignore payments intentsRequired
Trigger
Instant
Try It
New Dispute
Triggers when a customer disputes a charge.
Trigger
Instant
Try It
- Event Types
Trigger
Polling
Try It

- Status
- Collection Method
- Customer ID
- Subscription ID
Trigger
Polling
Try It
- Products
Trigger
Polling
Try It

Updated Subscription
Triggers when a customer subscription has changed.
Trigger
Instant
Try It
- Subscription IDRequired
Action
Write
- ModeRequired
- Price ID
- Quantity
- Success URLRequired
- Cancel URL
- Customer ID
- Customer Email
- Payment Method Types
- Currency
- Billing Address Collection
- Shipping Countries
- Allow Promotion Codes
- Automatic Tax Enabled
- Coupon ID
- Promotion Code ID
- Client Reference ID
- Expires At
Action
Write
- Customer ID
- Description
- Quantity
- Unit Price
- Amount
- Include Tax In Price?
- Item Taxes
- Is Discountable?
- Item Coupons
- Supply Date - Start
- Supply Date - End
- Invoice Item Currency
- Price ID
- Invoice Item Subscription ID
- Tax Code
- Shipping Rate
- Invoice Coupons
- Default Tax Rates
- Payment Collection
- Due Date
- Days Until Due
- Turn On Automatic Collection?
- Default Payment Method
- Memo
- Footer
- Custom Fields
- Tax IDs
- PDF Page Size
- Shipping Details Instructions
- Shipping Details - Name
- Shipping Details - Phone
- Shipping Details - Address Line 1
- Shipping Details - Address Line 2
- Shipping Details - City
- Shipping Details - State
- Shipping Details - Postal Code
- Shipping Details - Country
- Subscription ID
- Automatic Tax Enabled?
- Invoice Currency
- Effective At
- Payment Method Types
- Rendering - Amount Tax Display
- Statement Descriptor
- Pending Invoice Items Behavior
- Invoice Metadata
- Help Text For Finalizing Sending Charging
- Finalize Invoice?
- Send Invoice for Manual Payment?
- Pay Invoice?
- Pay Invoice - Forgive
- Pay Invoice - Off-Session
- Pay Invoice - Paid Out of Band
Action
Write
- PriceRequired
- QuantityRequired
- Minimum adjustable quantity
- Maximum adjustable quantity
- Collect Tax Automatically?
- Allow Promotion Codes?
- Maximum number of times the link can be used
- Collect Customers' Addresses?
- Require customers to provide a phone number?
- Collect Tax ID?
- Create Invoice on Payment?
- Require customers to accept terms of service agreement?
- Confirmation Page
- Metadata
- Payment Method Types
Action
Write
- NameRequired
- Description
- Image
- Tax Code
- Metadata
Action
Write
- Payment LinkRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Account IDRequired
Action
Search
- Stripe Charge IDRequired
Action
Search
- Invoice IDRequired
Action
Search
- Customer IDRequired
- Price ID
- Status
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

Checkout Session Completed
Triggers when a checkout session is completed.
Trigger
Instant
Try It
Invoice Payment Failed
Triggers when an invoice payment fails.
Trigger
Instant
Try It
New Customer
Triggers when a new customer is added.
Trigger
Instant
Try It
New Subscription
Triggers when a customer is signed up for a new plan.
Trigger
Instant
Try It
New Invoice Item
Triggers when a new invoice item is created.
Trigger
Polling
Try It
New Payment
Triggers when a new payment is completed.
Trigger
Instant
Try It
New Refund
Triggers when a charge is refunded, including partial refunds.
Trigger
Polling
Try It
Updated Dispute
Triggers when a dispute is updated (usually with evidence).
Trigger
Instant
Try It
- Warning
- Payment IDRequired
- Payment Method ID
- Receipt Email
- Error on Requires Action?
- Shipping - Name
- Shipping Address - Line 1
- Shipping Address - Line 2
- Shipping Address - Postal Code
- Shipping Address - City
- Shipping Address - State
- Shipping Address - Country
- Shipping - Carrier
- Shipping - Phone
- Shipping - Tracking Number
Action
Write
- Name
- Email
- Description
- Billing - Address Line 1
- Billing - Address Line 2
- Billing - City
- Billing - State
- Billing - ZIP
- Billing - Country
- Billing - Phone
- Shipping - Name
- Shipping - Address Line 1
- Shipping - Address Line 2
- Shipping - City
- Shipping - State
- Shipping - ZIP
- Shipping - Country
- Shipping - Phone
- Language
- Invoice prefix
- Next Invoice Sequence
- Tax Status
- Credit Balance
- Metadata
Action
Write
- Warning
- AmountRequired
- CurrencyRequired
- Customer ID
- Payment Method ID
- Confirm Payment Immediately?
- Error on Requires Action?
- Off Session?
- Payment Description
- Receipt Email
- Shipping - Name
- Shipping Address - Line 1
- Shipping Address - Line 2
- Shipping Address - Postal Code
- Shipping Address - City
- Shipping Address - State
- Shipping Address - Country
- Shipping - Carrier
- Shipping - Phone
- Shipping - Tracking Number
- Statement Descriptor
- Statement Descriptor Suffix
- Metadata
- Capture Method
Action
Write
- ProductRequired
- Price (in minor units, e.g. cents)Required
- CurrencyRequired
- Recurring or One time?
- Tax Behavior
Action
Write
- Customer IDRequired
- ItemsRequired
- Collection MethodRequired
- Coupon ID
- Cancel at period end?
- Metadata
Action
Write
- Customer IDRequired
- Name
- Email
- Description
- Billing - Address Line 1
- Billing - Address Line 2
- Billing - City
- Billing - State
- Billing - ZIP
- Billing - Country
- Billing - Phone
- Shipping - Name
- Shipping - Address Line 1
- Shipping - Address Line 2
- Shipping - City
- Shipping - State
- Shipping - ZIP
- Shipping - Country
- Shipping - Phone
- Language
- Invoice prefix
- Next Invoice Sequence
- Tax Status
- Credit Balance
- Metadata
Action
Write
Find Account Balance
Finds the account balance for your stripe account
Action
Search
- Created after
- Created before
- Currency
- Payout ID
- Source ID
- Type
- Transactions before
- Transactions after
Action
Search
- Find by
- QueryRequired
Action
Search
- Payment Intent IDRequired
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 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

About Stripe

Stripe is a developer-friendly way to accept payments online and in mobile apps. Stripe's suite of APIs powers commerce for thousands of companies of all sizes, processing billions of dollars for businesses each year.

Learn more

Related categories

Payment Processing

Related Zap Templates

Create rows in Google BigQuery for every new subscription in Stripe

Google BigQuery + Stripe

Create rows in Google BigQuery for new invoice items in Stripe

Canceled Subscription

Failed Payment

New Charge

New Dispute

New Event

New Invoice

New Payment Link

Updated Subscription

Cancel Subscription

Create Checkout Session

Create Invoice

Create Payment Link

Create Product

Deactivate Payment Link

API Request (Beta)

Find Account by ID

Find Charge

Find Invoice

Find Subscription

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

Checkout Session Completed

Invoice Payment Failed

New Customer

New Subscription

New Invoice Item

New Payment

New Refund

Updated Dispute

Confirm Payment

Create Customer

Create Payment

Create Price

Create Subscription

Update Customer

Find Account Balance

Find Balance Transactions

Find Customer

Find Payment

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 Google BigQuery

Related categories

About Stripe

Related categories

Related Zap Templates

Related Zap Templates