Stripe connection for LinkyFlow

LinkyFlow brings Stripe ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

Read requests

Write actions

Documented fields

137

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

Billing

Coupons

Discount coupons.

Read

Coupons

Discount coupons.

Route: GET /coupons

Excel formula: =LF.stripe.coupons("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount_off` default	number	—	-
`created` default	date	—	-
`duration` default	enum	—	-
`id` default	id	—	-
`name` default	string	—	-
`percent_off` default	number	—	-
`times_redeemed` default	number	—	-

Create

Create Coupon

Route: POST /mutation/coupons

Inputs you can set

Name	Type	Required	Description
`amount_off`	number	No	-
`currency`	string	No	-
`duration`	enum	Yes	Values: forever, once, repeating
`duration_in_months`	number	No	-
`name`	string	No	-
`percent_off`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Coupon

Route: PATCH /mutation/coupons

Inputs you can set

Name	Type	Required	Description
`amount_off`	number	No	-
`currency`	string	No	-
`duration`	enum	Yes	Values: forever, once, repeating
`duration_in_months`	number	No	-
`name`	string	No	-
`percent_off`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Coupon

Route: DELETE /mutation/coupons

Inputs you can set

Name	Type	Required	Description
`amount_off`	number	No	-
`currency`	string	No	-
`duration`	enum	Yes	Values: forever, once, repeating
`duration_in_months`	number	No	-
`name`	string	No	-
`percent_off`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Customers

Customers in your Stripe account.

Used as filter by

Charges · customer

Checkout Sessions · customer

Invoice Items · customer

Invoices · customer

Payment Intents · customer

Subscriptions · customer

Read

Customers

Customers in your Stripe account.

Route: GET /customers

Excel formula: =LF.stripe.customers("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`email`	string	No	Filter by exact email
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`balance`	number	—	-
`created` default	date	—	-
`currency`	string	—	-
`delinquent`	boolean	—	-
`description`	string	—	-
`email` default	string	—	-
`id` default	id	—	-
`name` default	string	—	-
`phone`	string	—	-

Create

Create Customer

Route: POST /mutation/customers

Inputs you can set

Name	Type	Required	Description
`description`	string	No	-
`email`	string	No	-
`name`	string	No	-
`phone`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Customer

Route: PATCH /mutation/customers

Inputs you can set

Name	Type	Required	Description
`description`	string	No	-
`email`	string	No	-
`name`	string	No	-
`phone`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Customer

Route: DELETE /mutation/customers

Inputs you can set

Name	Type	Required	Description
`description`	string	No	-
`email`	string	No	-
`name`	string	No	-
`phone`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Invoice Items

Pending line items added to a customer’s next invoice.

Read

Invoice Items

Pending line items added to a customer’s next invoice.

Route: GET /invoiceItems

Excel formula: =LF.stripe.invoiceItems("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`description` default	string	—	-
`id` default	id	—	-

Create

Create Invoice Item

Route: POST /mutation/invoiceItems

Inputs you can set

Name	Type	Required	Description
`amount`	number	No	-
`currency`	string	Yes	-
`customer`	id	Yes	-
`description`	string	No	-
`quantity`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Invoice Item

Route: PATCH /mutation/invoiceItems

Inputs you can set

Name	Type	Required	Description
`amount`	number	No	-
`currency`	string	Yes	-
`customer`	id	Yes	-
`description`	string	No	-
`quantity`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Invoice Item

Route: DELETE /mutation/invoiceItems

Inputs you can set

Name	Type	Required	Description
`amount`	number	No	-
`currency`	string	Yes	-
`customer`	id	Yes	-
`description`	string	No	-
`quantity`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Invoices

Invoices issued to customers.

Read

Invoices

Invoices issued to customers.

Route: GET /invoices

Excel formula: =LF.stripe.invoices("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`status`	enum	No	Filter by status Values: draft, open, paid, uncollectible, void
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount_due` default	number	—	-
`created` default	date	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`number` default	string	—	-
`status` default	string	—	-
`total` default	number	—	-

Create

Create Invoice

Route: POST /mutation/invoices

Inputs you can set

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`currency`	string	No	-
`customer`	id	Yes	-
`description`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Invoice

Route: PATCH /mutation/invoices

Inputs you can set

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`currency`	string	No	-
`customer`	id	Yes	-
`description`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Draft Invoice

Route: DELETE /mutation/invoices

Inputs you can set

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`currency`	string	No	-
`customer`	id	Yes	-
`description`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Promotion Codes

Customer-facing codes that apply a coupon.

Read

Promotion Codes

Customer-facing codes that apply a coupon.

Route: GET /promotionCodes

Excel formula: =LF.stripe.promotionCodes("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`code`	string	No	Filter by code
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`code` default	string	—	-
`coupon` default	id	—	-
`created` default	date	—	-
`id` default	id	—	-
`times_redeemed` default	number	—	-

Create

Create Promotion Code

Route: POST /mutation/promotionCodes

Inputs you can set

Name	Type	Required	Description
`code`	string	No	-
`coupon`	id	Yes	-
`max_redemptions`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Promotion Code

Route: PATCH /mutation/promotionCodes

Inputs you can set

Name	Type	Required	Description
`code`	string	No	-
`coupon`	id	Yes	-
`max_redemptions`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Subscriptions

Recurring subscriptions.

Read

Subscriptions

Recurring subscriptions.

Route: GET /subscriptions

Excel formula: =LF.stripe.subscriptions("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`status`	enum	No	Filter by status Values: active, past_due, unpaid, canceled, incomplete
`price`	id	No	Filter by price
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`cancel_at_period_end` default	boolean	—	-
`created` default	date	—	-
`current_period_end` default	date	—	-
`current_period_start` default	date	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`status` default	string	—	-

Create

Create Subscription

Route: POST /mutation/subscriptions

Inputs you can set

Name	Type	Required	Description
`customer`	id	Yes	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Subscription

Route: PATCH /mutation/subscriptions

Inputs you can set

Name	Type	Required	Description
`customer`	id	Yes	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Cancel Subscription

Route: DELETE /mutation/subscriptions

Inputs you can set

Name	Type	Required	Description
`customer`	id	Yes	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Tax Rates

Tax rates applied to invoices and subscriptions.

Read

Tax Rates

Tax rates applied to invoices and subscriptions.

Route: GET /taxRates

Excel formula: =LF.stripe.taxRates("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`created` default	date	—	-
`display_name` default	string	—	-
`id` default	id	—	-
`inclusive` default	boolean	—	-
`percentage` default	number	—	-

Create

Create Tax Rate

Route: POST /mutation/taxRates

Inputs you can set

Name	Type	Required	Description
`country`	string	No	-
`display_name`	string	Yes	-
`inclusive`	boolean	Yes	-
`jurisdiction`	string	No	-
`percentage`	number	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Tax Rate

Route: PATCH /mutation/taxRates

Inputs you can set

Name	Type	Required	Description
`country`	string	No	-
`display_name`	string	Yes	-
`inclusive`	boolean	Yes	-
`jurisdiction`	string	No	-
`percentage`	number	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Catalog

Prices

Prices attached to products.

Read

Prices

Prices attached to products.

Route: GET /prices

Excel formula: =LF.stripe.prices("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`product`	id	No	Filter by product
`active`	boolean	No	Filter by active state
`type`	enum	No	Filter by price type Values: one_time, recurring
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`nickname` default	string	—	-
`product` default	id	→ products	-
`type` default	string	—	-
`unit_amount` default	number	—	-

Create

Create Price

Route: POST /mutation/prices

Inputs you can set

Name	Type	Required	Description
`currency`	string	Yes	-
`nickname`	string	No	-
`product`	id	Yes	-
`recurring.interval`	enum	No	Values: day, week, month, year
`unit_amount`	number	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Price

Route: PATCH /mutation/prices

Inputs you can set

Name	Type	Required	Description
`currency`	string	Yes	-
`nickname`	string	No	-
`product`	id	Yes	-
`recurring.interval`	enum	No	Values: day, week, month, year
`unit_amount`	number	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Products

Products in your Stripe catalog.

Used as filter by

Prices · product

Read

Products

Products in your Stripe catalog.

Route: GET /products

Excel formula: =LF.stripe.products("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`created` default	date	—	-
`default_price` default	id	—	-
`description`	string	—	-
`id` default	id	—	-
`name` default	string	—	-

Create

Create Product

Route: POST /mutation/products

Inputs you can set

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`name`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Product

Route: PATCH /mutation/products

Inputs you can set

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`name`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Product

Route: DELETE /mutation/products

Inputs you can set

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`name`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Developers

Events

Account activity events.

Read

Events

Account activity events.

Route: GET /events

Excel formula: =LF.stripe.events("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`type`	string	No	Filter by event type (e.g. invoice.paid)
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`api_version`	string	—	-
`created` default	date	—	-
`id` default	id	—	-
`type` default	string	—	-

Payments

Charges

Individual charges.

Read

Charges

Individual charges.

Route: GET /charges

Excel formula: =LF.stripe.charges("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`paid` default	boolean	—	-
`status` default	string	—	-

Edit

Update Charge

Route: PATCH /mutation/charges

Inputs you can set

Name	Type	Required	Description
`description`	string	No	-
`id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Checkout Sessions

Stripe Checkout sessions.

Read

Checkout Sessions

Stripe Checkout sessions.

Route: GET /checkoutSessions

Excel formula: =LF.stripe.checkoutSessions("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount_total` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`payment_status` default	string	—	-
`status` default	string	—	-

Create

Create Checkout Session

Route: POST /mutation/checkoutSessions

Inputs you can set

Name	Type	Required	Description
`cancel_url`	string	No	-
`customer`	id	No	-
`line_items.0.price`	id	No	-
`line_items.0.quantity`	number	No	-
`mode`	enum	Yes	Values: payment, subscription, setup
`success_url`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Disputes

Disputes (chargebacks) raised by cardholders.

Read

Disputes

Disputes (chargebacks) raised by cardholders.

Route: GET /disputes

Excel formula: =LF.stripe.disputes("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`charge` default	id	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`reason` default	string	—	-
`status` default	string	—	-

Edit

Update Dispute

Route: PATCH /mutation/disputes

Inputs you can set

Name	Type	Required	Description
`id`	id	Yes	-
`metadata.note`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Payment Intents

Payment intents tracking the lifecycle of a payment.

Read

Payment Intents

Payment intents tracking the lifecycle of a payment.

Route: GET /paymentIntents

Excel formula: =LF.stripe.paymentIntents("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`status` default	string	—	-

Create

Create Payment Intent

Route: POST /mutation/paymentIntents

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`currency`	string	Yes	-
`customer`	id	No	-
`description`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Payment Intent

Route: PATCH /mutation/paymentIntents

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`currency`	string	Yes	-
`customer`	id	No	-
`description`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Payouts

Payouts to your bank account.

Read

Payouts

Payouts to your bank account.

Route: GET /payouts

Excel formula: =LF.stripe.payouts("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`status`	enum	No	Filter by status Values: pending, paid, failed, canceled, in_transit
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`arrival_date` default	date	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`status` default	string	—	-

Create

Create Payout

Route: POST /mutation/payouts

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`currency`	string	Yes	-
`description`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Payout

Route: PATCH /mutation/payouts

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`currency`	string	Yes	-
`description`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Refunds

Refunds issued against charges or payment intents.

Read

Refunds

Refunds issued against charges or payment intents.

Route: GET /refunds

Excel formula: =LF.stripe.refunds("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`charge` default	id	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`status` default	string	—	-

Create

Create Refund

Route: POST /mutation/refunds

Inputs you can set

Name	Type	Required	Description
`amount`	number	No	-
`charge`	id	No	-
`payment_intent`	id	No	-
`reason`	enum	No	Values: duplicate, fraudulent, requested_by_customer

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Refund

Route: PATCH /mutation/refunds

Inputs you can set

Name	Type	Required	Description
`amount`	number	No	-
`charge`	id	No	-
`payment_intent`	id	No	-
`reason`	enum	No	Values: duplicate, fraudulent, requested_by_customer

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Reports

Balance Transactions

Funds movements through your Stripe balance.

Read

Balance Transactions

Funds movements through your Stripe balance.

Route: GET /balanceTransactions

Excel formula: =LF.stripe.balanceTransactions("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`type`	string	No	Filter by type (e.g. charge, refund, payout)
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`fee` default	number	—	-
`id` default	id	—	-
`net` default	number	—	-
`status` default	string	—	-
`type` default	string	—	-