Connect Stripe with Google Sheets
Unlock the superpowers of Stripe + Google Sheets and automate your tasks without having to write a single line of code.
Stripe and Google Sheets
your way
Check out the available triggers and actions in the automation of apps Stripe + Google Sheets
Active subscription
For each active subscription on StripeTrigger
Subscription ID
Cancellation Date
Billing Method
Subscription creation date
End of current period
Start of current period
customer code
customer: balance
customer: balance
customer: balance
customer: creation date
customer: description
customer: email
customer: CPF/CNPJ
customer: Document
Standard payment method
Standard subscription fees
Discount Coupon: Application Date
Discount Coupon: Deadline
Discount Coupon: ID
Discount Coupon: Absolute Amount
Discount Coupon: Absolute Amount
Discount Coupon: Absolute Amount
Discount Coupon: Creation Date
Discount Coupon: Name
Discount Coupon: Pencentual Amount
Subscription end date
End of subscription trial period
Start of subscription trial period
Last Invoice: ID
Last Invoice: Billing Method
Last Invoice: Description
Last Invoice: Items
Invoice: Account Name
Last Invoice: Account Country
Last Invoice: Total Amount
Last Invoice: Total Amount
Last Invoice: Total Amount
Last Invoice: Amount Paid
Last Invoice: Amount Paid
Last Invoice: Amount Paid
Last Invoice: Remaining Amount
Last Invoice: Remaining Amount
Última Fatura: Endereço do cliente - Cidade
Última Fatura: Endereço do cliente - País
Última Fatura: Endereço do cliente - linha 1
Última Fatura: Endereço do cliente - linha 2
Última Fatura: Endereço do cliente - Código postal
Última Fatura: Endereço do cliente - Cidade
Última Fatura: E-mail do cliente
Última Fatura: Nome do cliente
Última Fatura: Telefone do cliente
Last Invoice: Creation Date
Last Invoice: Due Date
Last Invoice: Subtotal
Last Invoice: Subtotal
Last Invoice: Subtotal
Last Invoice: Fees
Last Invoice: Discount
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Approved payment
For each approved payment on StripeTrigger
transaction id
amount in cents
original amount in decimal
amount formatted in R$
amount returned in cents
original currency amount converted to standard currency (in cents)
original currency amount converted to standard currency
fee amount in cents
fee amount in R$
net amount of original currency converted to standard currency (in cents)
net amount of original currency converted to standard currency
Taxa de cambio do valor da moeda original sobre valor convertido para moeda padrão
captured transaction status
creation date (formatted - DD/MM/YYYY H:M:S)
data de criação (formatado em ano-mês-dia)
transaction description
transaction failure code
transaction failure message
Id do invoice
Value in cents of the invoice before discounts.
Value in BRL of the invoice before discounts.
Total in cents after discounts and taxes.
Total in BRL after discounts and taxes.
The amount of tax on this invoice in cents
The amount of tax on this invoice in BRL
The aggregate amounts calculated per discount across all line items in cents
The aggregate amounts calculated per discount across all line items in cents
Resume of invoice items in the format: Unit value in cents
Resume of invoice items in the format: Unit value in BRL
Resume of invoice items in the format: Product ID
Resume of invoice items in the format: Item nickname
Line items descriptions (separated by commas)
Invoice plans
Invoice number
Invoice customer name
Invoice customer e-mail
data de vencimento do invoice (formatado - DD/MM/YYYY H:M:S)
data de vencimento do invoice (formatado em ano-mês-dia)
paid transaction status
extorted transaction code
payment status
customer code
cliente: nome
customer: balance
customer: creation date
cliente: data de criação (formatado em ano-mês-dia)
customer: description
customer: email
customer: CPF/CNPJ
customer: Document
Shipping: customer's name
Shipping: customer's phone
Delivery address: city
Delivery address: country
Delivery address: street
Delivery address: complement
Delivery address: Zip Code
Delivery address: state
Billing address: city
Billing address: country
Billing address: street
Billing address: add-on
Billing address: Zip Code
Billing address: state
Customer name on billing
Billing address: email
receipt: email
Payment method type
Payment intent: Customer emails
Payment Intent: Customer Names
Payment intention: Customer phone numbers
Statement descriptor
Funds availability date (formatted - DD/MM/YYYY H:M:S)
Receipt Number
New added row
When a new row is added on Google SheetsTrigger
Line No.
Cancelled subscription
For each cancelled subscription on StripeTrigger
Subscription ID
Cancellation Date
Billing Method
Subscription creation date
End of current period
Start of current period
customer code
customer: balance
customer: balance
customer: balance
customer: creation date
customer: description
customer: email
customer: CPF/CNPJ
customer: Document
Standard payment method
Standard subscription fees
Discount Coupon: Application Date
Discount Coupon: Deadline
Discount Coupon: ID
Discount Coupon: Absolute Amount
Discount Coupon: Absolute Amount
Discount Coupon: Absolute Amount
Discount Coupon: Creation Date
Discount Coupon: Name
Discount Coupon: Pencentual Amount
Subscription end date
End of subscription trial period
Start of subscription trial period
Last Invoice: ID
Last Invoice: Billing Method
Last Invoice: Description
Last Invoice: Items
Invoice: Account Name
Last Invoice: Account Country
Last Invoice: Total Amount
Last Invoice: Total Amount
Last Invoice: Total Amount
Last Invoice: Amount Paid
Last Invoice: Amount Paid
Last Invoice: Amount Paid
Last Invoice: Remaining Amount
Last Invoice: Remaining Amount
Last Invoice: Creation Date
Last Invoice: Due Date
Last Invoice: Subtotal
Last Invoice: Subtotal
Last Invoice: Subtotal
Last Invoice: Fees
Last Invoice: Discount
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Declined payment
For each declined payment on StripeTrigger
transaction id
amount in cents
amount in Reais
amount formatted in R$
amount returned in cents
original currency amount converted to standard currency (in cents)
original currency amount converted to standard currency
fee amount in cents
fee amount in R$
net amount of original currency converted to standard currency (in cents)
net amount of original currency converted to standard currency
Taxa de cambio do valor da moeda original sobre valor convertido para moeda padrão
captured transaction status
creation date (formatted - DD/MM/YYYY H:M:S)
data de criação (formatado em ano-mês-dia)
transaction description
transaction failure code
transaction failure message
código do invoice
Value in cents of the invoice before discounts.
Value in BRL of the invoice before discounts.
Total in cents after discounts and taxes.
Total in BRL after discounts and taxes.
The amount of tax on this invoice in cents
The amount of tax on this invoice in BRL
The aggregate amounts calculated per discount across all line items in cents
The aggregate amounts calculated per discount across all line items in cents
Resume of invoice items in the format: Unit value in cents
Resume of invoice items in the format: Unit value in BRL
Resume of invoice items in the format: Product ID
Resume of invoice items in the format: Item nickname
Line items descriptions (separated by commas)
Invoice plans
Invoice number
Invoice customer name
Invoice customer e-mail
data de vencimento do invoice (formatado - DD/MM/YYYY H:M:S)
data de vencimento do invoice (formatado em ano-mês-dia)
paid transaction status
extorted transaction code
payment status
customer code
cliente: nome
customer: balance
customer: creation date
cliente: data de criação (formatado em ano-mês-dia)
customer: description
customer: email
customer: CPF/CNPJ
customer: Document
Shipping: customer's name
Shipping: customer's phone
Delivery address: city
Delivery address: country
Delivery address: street
Delivery address: complement
Delivery address: Zip Code
Delivery address: state
Billing address: city
Billing address: country
Billing address: street
Billing address: add-on
Billing address: Zip Code
Billing address: state
Customer name on billing
Billing address: email
receipt: email
Payment method type
Payment intention: Customer emails
Payment Intent: Customer Names
Payment intention: Customer phone numbers
Funds availability date (formatted - DD/MM/YYYY H:M:S)
Receipt Number
Created subscription
For each created subscription on StripeTrigger
Subscription ID
Cancellation Date
Billing Method
Subscription creation date
End of current period
Start of current period
customer code
customer: balance
customer: balance
customer: balance
customer: creation date
customer: description
customer: email
customer: CPF/CNPJ
customer: Document
Standard payment method
Standard subscription fees
Discount Coupon: Application Date
Discount Coupon: Deadline
Discount Coupon: ID
Discount Coupon: Absolute Amount
Discount Coupon: Absolute Amount
Discount Coupon: Absolute Amount
Discount Coupon: Creation Date
Discount Coupon: Name
Discount Coupon: Pencentual Amount
Subscription end date
End of subscription trial period
Start of subscription trial period
Last Invoice: ID
Last Invoice: Billing Method
Last Invoice: Description
Last Invoice: Items
Invoice: Account Name
Last Invoice: Account Country
Last Invoice: Total Amount
Last Invoice: Total Amount
Last Invoice: Total Amount
Last Invoice: Amount Paid
Last Invoice: Amount Paid
Last Invoice: Amount Paid
Last Invoice: Remaining Amount
Last Invoice: Remaining Amount
Last Invoice: Creation Date
Last Invoice: Due Date
Last Invoice: Subtotal
Last Invoice: Subtotal
Last Invoice: Subtotal
Last Invoice: Fees
Last Invoice: Discount
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Last Invoice: Total
Refunded payment
For each refunded payment on StripeTrigger
transaction id
amount in cents
amount in Reais
amount formatted in R$
amount returned in cents
original currency amount converted to standard currency (in cents)
original currency amount converted to standard currency
fee amount in cents
fee amount in R$
net amount of original currency converted to standard currency (in cents)
net amount of original currency converted to standard currency
Taxa de cambio do valor da moeda original sobre valor convertido para moeda padrão
captured transaction status
creation date (formatted - DD/MM/YYYY H:M:S)
data de criação (formatado em ano-mês-dia)
transaction description
transaction failure code
transaction failure message
código do invoice
Value in cents of the invoice before discounts.
Value in BRL of the invoice before discounts.
Total in cents after discounts and taxes.
Total in BRL after discounts and taxes.
The amount of tax on this invoice in cents
The amount of tax on this invoice in BRL
The aggregate amounts calculated per discount across all line items in cents
The aggregate amounts calculated per discount across all line items in cents
Resume of invoice items in the format: Unit value in cents
Resume of invoice items in the format: Unit value in BRL
Resume of invoice items in the format: Product ID
Resume of invoice items in the format: Item nickname
Line items descriptions (separated by commas)
Invoice plans
Invoice number
Invoice customer name
Invoice customer e-mail
data de vencimento do invoice (formatado - DD/MM/YYYY H:M:S)
data de vencimento do invoice (formatado em ano-mês-dia)
paid transaction status
extorted transaction code
payment status
customer code
cliente: nome
customer: balance
customer: creation date
cliente: data de criação (formatado em ano-mês-dia)
customer: description
customer: email
customer: CPF/CNPJ
customer: Document
Shipping: customer's name
Shipping: customer's phone
Delivery address: city
Delivery address: country
Delivery address: street
Delivery address: complement
Delivery address: Zip Code
Delivery address: state
Billing address: city
Billing address: country
Billing address: street
Billing address: add-on
Billing address: Zip Code
Billing address: state
Customer name on billing
Billing address: email
receipt: email
Payment method type
Payment intention: Customer emails
Payment Intent: Customer Names
Payment intention: Customer phone numbers
Insert row in spreadsheet
add data to a new row on a Google Sheets spreadsheetAction
Columns
Update/insert row in spreadsheet
update or add data in Google Sheets spreadsheet's row(s)Action
Didn't find your use case? Send suggestion.
Automate Stripe and Google Sheets
with Pluga integrationsExplore automation templates
For each approved payment on Stripe, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each declined payment on Stripe, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each refunded payment on Stripe, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each cancelled subscription on Stripe, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each created subscription on Stripe, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each approved payment on Stripe, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each declined payment on Stripe, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each refunded payment on Stripe, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each cancelled subscription on Stripe, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each created subscription on Stripe, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREMiss an automation with this apps?
Say to us!How to integrate apps with Pluga?
Pluga allows you to integrate two or more apps in a simple, practical way without needing to type a single line of code. Here are the steps to automate your tasks and start focusing on what really matters.
Automate Stripe + Google Sheets
and say goodbye to manual (and tedious) tasks!
By connecting the apps you use through Pluga, you can automate various processes in your routine and have time for tasks that really matter. Stripe
PaymentStripe is an online payment platform that allows businesses and entrepreneurs to securely receive payments via credit card, debit card, bank transfer, and other payment methods.
Integrations with Stripe Visit StripeGoogle Sheets
SpreadsheetGoogle Sheets is Google's online spreadsheet app that allows users to create, edit, share, and collaborate on documents both synchronously and asynchronously. It's a versatile tool for any type and size of business, serving purposes from CRM to inventory management spreadsheets.
Integrations with Google Sheets Visit Google Sheets