PostgreSQL + Stripe

Create new PostgreSQL rows for every new Stripe invoice

Simplify your invoicing process with this efficient workflow. When a new invoice arises in Stripe, a new row is immediately created in your PostgreSQL database. This allows you to effectively manage your financial data, saving time and reducing manual entry errors. Enjoy the ease of having your payment data organized and accessible for your business needs.

When this happens...
New Invoice
Triggers on a new invoice. You can filter based on the invoice's status. (supports line items)
TriggerScheduled
automatically do this!
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

What does this mean?

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
Scheduled
Try It

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

Updated Subscription
Triggers when a customer subscription has changed.
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
- 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?
- 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
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Stripe Charge IDRequired
Action
Search
- Invoice IDRequired
Action
Search
- Customer IDRequired
- Price ID
- Status
Action
Search
- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search

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
Scheduled
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
Scheduled
Try It
- Subscription IDRequired
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
- Find by
- QueryRequired
Action
Search
- Payment Intent IDRequired
Action
Search
- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn more

Related categories

Databases

Similar apps

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

Add PostgreSQL rows for new events on Stripe

Create new rows in PostgreSQL for new charges in Stripe

Create new Stripe customers from new PostgreSQL rows

PostgreSQL + Stripe

Create new PostgreSQL rows for every new Stripe invoice

Canceled Subscription

Failed Payment

New Charge

New Dispute

New Event

Event Types

New Invoice

Status

Collection Method

Customer ID

Subscription ID

New Payment Link

Products

Updated Subscription

Confirm Payment

Warning

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

Create Invoice

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?