Connect Google Sheets with Hotmart
Unlock the superpowers of Google Sheets + Hotmart and automate your tasks without having to write a single line of code.
Google Sheets and Hotmart
your way
Check out the available triggers and actions in the automation of apps Google Sheets + Hotmart
New added row
When a new row is added on Google SheetsTrigger
Line No.
Completed purchase
For each completed sale on HotmartTrigger
Product: Code
Product: Name
Offer: Code
Offer: Price
Affiliate: Code
Affiliate: Name
Buyer: Email
Buyer: Full name
Buyer: First name
Buyer: Last name
Buyer: Document (number)
Buyer: Type of Document (CPF, CNPJ, etc.)
Buyer: telephone area code (registration)
Buyer: Phone number (registration)
Buyer: Phone area code (checkout)
Buyer: Phone number (checkout)
Buyer: Address
Comprador: Endereço (checkout)
Buyer: Address number
Comprador: Número do endereço (checkout)
Buyer: Country
Comprador: País (checkout)
Buyer: Neighborhood
Comprador: Bairro (checkout)
Buyer: Add address
Comprador: Complemento do endereço do checkout
Comprador: Complemento do endereço (checkout)
Buyer: City
Comprador: Cidade (checkout)
Buyer: State
Comprador: Estado (checkout)
Buyer: Zip Code
Comprador: CEP (checkout)
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Hotkey
Subscription plan name
Subscriber code
Recurrence period
Payment period in which the subscriber is
Intermediation and payment processing fees
Producer's commission
Affiliate commission
Co-producer's commission
Discount coupon
Subscription status
Transaction code generated by the external payment method
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Data do pedido (em DD/MM/AAAA)
Data da liberação da compra (em DD/MM/AAAA)
Bank slip: Link to file
Bank slip: Barcode
Coin
Original value
Currency description (R$, €, US$)
Producer: Name
Producer: Document
Producer: Legal Nature
Origin of the currency used to pay for the purchase
Total purchase amount
Warranty expiration date (in YYYY-MM-DD T HH:MM:SS Z)
Product support email
Type of recipient
Number of e-tickets
Number of plots
Type of payment for the offer (e.g. cash payment, multiple payments, etc.)
Amount at which the commission will be paid.
Product: SCK
Order Bump
Status da venda
Taxa utilizada no momento da conversão
Created sale
For each created sale on HotmartTrigger
Product: Code
Product: Name
Offer: Code
Offer: Type of payment (e.g. PAYMENT_UNIQUE)
Purchase price
Affiliate: Code
Affiliate: Name
Buyer: Code
Buyer: Email
Buyer: Full name
Buyer: Document (number)
Buyer: Type of Document (CPF, CNPJ, etc.)
Buyer: phone area code
Buyer: Phone number
Buyer: Address
Buyer: Address number
Buyer: Country
Buyer: Neighborhood
Buyer: Add address
Buyer: City
Buyer: State
Buyer: Zip Code
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Recurrence period
Nature of Sale
Sales commission amount
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Currency used for purchase
Total purchase amount
Number of plots
Cancelled subscription
When a subscription is cancelled on HotmartTrigger
Subscription code
Subscriber: Code
Cancellation date
Subscriber: Name
Subscriber: Email
Current amount of the charged recurrence
Product: Name
Plan: Subscription plan name
Approved purchase
For each approved sale on HotmartTrigger
Product: Code
Product: Name
Offer: Code
Offer: Price
Affiliate: Code
Affiliate: Name
Buyer: Email
Buyer: Full name
Buyer: First name
Buyer: Last name
Buyer: Document (number)
Buyer: Type of Document (CPF, CNPJ, etc.)
Buyer: telephone area code (registration)
Buyer: Phone number (registration)
Buyer: Phone area code (checkout)
Buyer: Phone number (checkout)
Buyer: Address
Comprador: Endereço (checkout)
Buyer: Address number
Comprador: Número do endereço (checkout)
Buyer: Country
Comprador: País (checkout)
Buyer: Neighborhood
Comprador: Bairro (checkout)
Buyer: Add address
Comprador: Complemento do endereço do checkout
Comprador: Complemento do endereço (checkout)
Buyer: City
Comprador: Cidade (checkout)
Buyer: State
Comprador: Estado (checkout)
Buyer: Zip Code
Comprador: CEP (checkout)
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Hotkey
Subscription plan name
Subscriber code
Recurrence period
Payment period in which the subscriber is
Intermediation and payment processing fees
Producer's commission
Affiliate commission
Co-producer's commission
Discount coupon
Subscription status
Transaction code generated by the external payment method
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Data do pedido (em DD/MM/AAAA)
Data da liberação da compra (em DD/MM/AAAA)
Bank slip: Link to file
Bank slip: Barcode
Coin
Original value
Currency description (R$, €, US$)
Producer: Name
Producer: Document
Producer: Legal Nature
Origin of the currency used to pay for the sale
Total sale amount
Warranty expiration date (in YYYY-MM-DD T HH:MM:SS Z)
Product support email
Type of recipient
Number of e-tickets
Number of plots
Type of payment for the offer (e.g. cash payment, multiple payments, etc.)
Amount at which the commission will be paid.
Product: SCK
Order Bump
Status da venda
Taxa utilizada no momento da conversão
Expired purchase
For each expired sale on HotmartTrigger
Product: Code
Product: Name
Offer: Code
Offer: Price
Affiliate: Code
Affiliate: Name
Buyer: Email
Buyer: Full name
Buyer: First name
Buyer: Last name
Buyer: Document (number)
Buyer: Type of Document (CPF, CNPJ, etc.)
Buyer: telephone area code (registration)
Buyer: Phone number (registration)
Buyer: Phone area code (checkout)
Buyer: Phone number (checkout)
Buyer: Address
Comprador: Endereço (checkout)
Buyer: Address number
Comprador: Número do endereço (checkout)
Buyer: Country
Comprador: País (checkout)
Buyer: Neighborhood
Comprador: Bairro (checkout)
Buyer: Add address
Comprador: Complemento do endereço do checkout
Comprador: Complemento do endereço (checkout)
Buyer: City
Comprador: Cidade (checkout)
Buyer: State
Comprador: Estado (checkout)
Buyer: Zip Code
Comprador: CEP (checkout)
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Hotkey
Subscription plan name
Subscriber code
Recurrence period
Payment period in which the subscriber is
Intermediation and payment processing fee
Producer's commission
Affiliate commission
Co-producer's commission
Discount coupon
Subscription status
Transaction code generated by the external payment method
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Data do pedido (em DD/MM/AAAA)
Data da liberação da compra (em DD/MM/AAAA)
Bank slip: Link to file
Bank slip: Barcode
Coin
Original value
Currency description (R$, €, US$)
Producer: Name
Producer: Document
Producer: Legal Nature
Origin of the currency used to pay for the purchase
Total purchase amount
Warranty expiration date (in YYYY-MM-DD T HH:MM:SS Z)
Product support email
Type of recipient
Number of e-tickets
Number of plots
Type of payment for the offer (e.g. cash payment, multiple payments, etc.)
Valor em que a comissão será paga.
Product: SCK
Order Bump
Status da venda
Taxa utilizada no momento da conversão
Delayed purchase
When a sale is late on HotmartTrigger
Product: Code
Product: Name
Offer: Code
Offer: Price
Affiliate: Code
Affiliate: Name
Buyer: Email
Buyer: Full name
Buyer: First name
Buyer: Last name
Buyer: Document (number)
Buyer: Type of Document (CPF, CNPJ, etc.)
Buyer: telephone area code (registration)
Buyer: Phone number (registration)
Buyer: Phone area code (checkout)
Buyer: Phone number (checkout)
Buyer: Address
Comprador: Endereço (checkout)
Buyer: Address number
Comprador: Número do endereço (checkout)
Buyer: Country
Comprador: País (checkout)
Buyer: Neighborhood
Comprador: Bairro (checkout)
Buyer: Add address
Comprador: Complemento do endereço do checkout
Comprador: Complemento do endereço (checkout)
Buyer: City
Comprador: Cidade (checkout)
Buyer: State
Comprador: Estado (checkout)
Buyer: Zip Code
Comprador: CEP (checkout)
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Hotkey
Subscription plan name
Subscriber code
Recurrence period
Payment period in which the subscriber is
Intermediation and payment processing fees
Producer's commission
Affiliate commission
Co-producer's commission
Discount coupon
Subscription status
Transaction code generated by the external payment method
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Data do pedido (em DD/MM/AAAA)
Data da liberação da compra (em DD/MM/AAAA)
Bank slip: Link to file
Bank slip: Barcode
Coin
Original value
Currency description (R$, €, US$)
Producer: Name
Producer: Document
Producer: Legal Nature
Origin of the currency used to pay for the purchase
Total purchase amount
Warranty expiration date (in YYYY-MM-DD T HH:MM:SS Z)
Product support email
Type of recipient
Number of e-tickets
Number of plots
Type of payment for the offer (e.g. cash payment, multiple payments, etc.)
Valor em que a comissão será paga.
Product: SCK
Order Bump
Status da venda
Taxa utilizada no momento da conversão
Created subscription
When a subscription is created on HotmartTrigger
Product: Code
Product: Name
Subscriber: Email
Subscriber: Full name
Subscriber: telephone area code
Subscriber: Phone number (registration)
Subscriber: cell phone area code
Subscriber: Mobile number
Subscriber: Address
Subscriber: Address number
Subscriber: Country
Subscriber: Neighborhood
Subscriber: Address complement
Subscriber: City
Subscriber: State
Subscriber: Zip Code
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Subscription plan name
Subscriber code
Recurrence period
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Coin
Origin of the currency used to pay for the purchase
Subscription amount
Number of plots
Cancelled sale
For each cancelled sale on HotmartTrigger
Product: Code
Product: Name
Offer: Code
Offer: Price
Affiliate: Code
Affiliate: Name
Buyer: Email
Buyer: Full name
Buyer: First name
Buyer: Last name
Buyer: Document (number)
Buyer: Type of Document (CPF, CNPJ, etc.)
Buyer: telephone area code (registration)
Buyer: Phone number (registration)
Buyer: Phone area code (checkout)
Buyer: Phone number (checkout)
Buyer: Address
Comprador: Endereço (checkout)
Buyer: Address number
Comprador: Número do endereço (checkout)
Buyer: Country
Comprador: País (checkout)
Buyer: Neighborhood
Comprador: Bairro (checkout)
Buyer: Add address
Comprador: Complemento do endereço do checkout
Comprador: Complemento do endereço (checkout)
Buyer: City
Comprador: Cidade (checkout)
Buyer: State
Comprador: Estado (checkout)
Buyer: Zip Code
Comprador: CEP (checkout)
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Hotkey
Subscription plan name
Subscriber code
Recurrence period
Payment period in which the subscriber is
Intermediation and payment processing fees
Producer's commission
Affiliate commission
Co-producer's commission
Discount coupon
Subscription status
Transaction code generated by the external payment method
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Data do pedido (em DD/MM/AAAA)
Data da liberação da compra (em DD/MM/AAAA)
Bank slip: Link to file
Bank slip: Barcode
Coin
Original value
Currency description (R$, €, US$)
Producer: Name
Producer: Document
Producer: Legal Nature
Origin of the currency used to pay for the purchase
Total purchase amount
Warranty expiration date (in YYYY-MM-DD T HH:MM:SS Z)
Product support email
Type of recipient
Number of e-tickets
Number of plots
Type of payment for the offer (e.g. cash payment, multiple payments, etc.)
Valor em que a comissão será paga.
Product: SCK
Order Bump
Status da venda
Taxa utilizada no momento da conversão
Refunded purchase
For each refunded sale on HotmartTrigger
Product: Code
Product: Name
Offer: Code
Offer: Price
Affiliate: Code
Affiliate: Name
Buyer: Email
Buyer: Full name
Buyer: First name
Buyer: Last name
Buyer: Document (number)
Buyer: Type of Document (CPF, CNPJ, etc.)
Buyer: telephone area code (registration)
Buyer: Phone number (registration)
Buyer: Phone area code (checkout)
Buyer: Phone number (checkout)
Buyer: Address
Comprador: Endereço (checkout)
Buyer: Address number
Comprador: Número do endereço (checkout)
Buyer: Country
Comprador: País (checkout)
Buyer: Neighborhood
Comprador: Bairro (checkout)
Buyer: Add address
Comprador: Complemento do endereço do checkout
Comprador: Complemento do endereço (checkout)
Buyer: City
Comprador: Cidade (checkout)
Buyer: State
Comprador: Estado (checkout)
Buyer: Zip Code
Comprador: CEP (checkout)
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Hotkey
Subscription plan name
Subscriber code
Recurrence period
Payment period in which the subscriber is
Intermediation and payment processing fee
Producer's commission
Affiliate commission
Co-producer's commission
Discount coupon
Subscription status
Transaction code generated by the external payment method
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Data do pedido (em DD/MM/AAAA)
Data da liberação da compra (em DD/MM/AAAA)
Bank slip: Link to file
Bank slip: Barcode
Coin
Original value
Currency description (R$, €, US$)
Producer: Name
Producer: Document
Producer: Legal Nature
Origin of the currency used to pay for the purchase
Total purchase amount
Warranty expiration date (in YYYY-MM-DD T HH:MM:SS Z)
Product support email
Type of recipient
Number of e-tickets
Number of plots
Type of payment for the offer (e.g. cash payment, multiple payments, etc.)
Valor em que a comissão será paga.
Product: SCK
Order Bump
Status da venda
Taxa utilizada no momento da conversão
Refunding request
When a refund request is made on HotmartTrigger
Product: Code
Product: Name
Offer: Code
Offer: Price
Affiliate: Code
Affiliate: Name
Buyer: Email
Buyer: Full name
Buyer: First name
Buyer: Last name
Buyer: Document (number)
Buyer: Type of Document (CPF, CNPJ, etc.)
Buyer: telephone area code (registration)
Buyer: Phone number (registration)
Buyer: Phone area code (checkout)
Buyer: Phone number (checkout)
Buyer: Address
Comprador: Endereço (checkout)
Buyer: Address number
Comprador: Número do endereço (checkout)
Buyer: Country
Comprador: País (checkout)
Buyer: Neighborhood
Comprador: Bairro (checkout)
Buyer: Add address
Comprador: Complemento do endereço (checkout)
Comprador: Complemento do endereço (checkout)
Buyer: City
Comprador: Cidade (checkout)
Buyer: State
Comprador: Estado (checkout)
Buyer: Zip Code
Comprador: CEP (checkout)
Transaction code
Payment method
Payment method (bank slip, credit card, etc.)
Hotkey
Subscription plan name
Subscriber code
Recurrence period
Payment period in which the subscriber is
Intermediation and payment processing fees
Producer's commission
Affiliate commission
Co-producer's commission
Discount coupon
Subscription status
Transaction code generated by the external payment method
Order date (in YYYY-MM-DD T HH:MM:SS Z)
Purchase release date (in YYYY-MM-DD T HH:MM:SS Z)
Data do pedido (em DD/MM/AAAA)
Data da liberação da compra (em DD/MM/AAAA)
Bank slip: Link to file
Bank slip: Barcode
Coin
Original value
Currency description (R$, €, US$)
Producer: Name
Producer: Document
Producer: Legal Nature
Origin of the currency used to pay for the purchase
Total purchase amount
Warranty expiration date (in YYYY-MM-DD T HH:MM:SS Z)
Product support email
Type of recipient
Number of e-tickets
Number of plots
Type of payment for the offer (e.g. cash payment, multiple payments, etc.)
Valor em que a comissão será paga.
Product: SCK
Order Bump
Status da venda
Taxa utilizada no momento da conversão
Abandoned Cart
For each abandoned cart on HotmartTrigger
Product's name
Buyer: Full name
Buyer: Email
Buyer: Telephone
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 Google Sheets and Hotmart
with Pluga integrationsExplore automation templates
For each created sale on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each approved sale on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each completed sale on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each expired sale on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each cancelled sale on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each refunded sale on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREWhen a refund request is made on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREWhen a sale is late on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREWhen a subscription is created on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREWhen a subscription is cancelled on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each abandoned cart on Hotmart, add data to a new row on a Google Sheets spreadsheet
EXPLOREFor each created sale on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each approved sale on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each completed sale on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each expired sale on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each cancelled sale on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each refunded sale on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREWhen a refund request is made on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREWhen a sale is late on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREWhen a subscription is created on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREWhen a subscription is cancelled on Hotmart, update or add data in a new row of a Google Sheets spreadsheet
EXPLOREFor each abandoned cart on Hotmart, 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 Google Sheets + Hotmart
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. Google 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 SheetsHotmart
Product InfoHotmart is one of the most well-known platforms for selling digital products, or infoproducts, in Latin America. With various features, the platform supports the entire process of managing and selling digital products.
Integrations with Hotmart Visit Hotmart