How does Kondado replicate Hotmart data to Google Sheets?

Kondado connects to your Hotmart account through a direct integration and extracts data from selected pipelines on your configured schedule. The platform automatically structures the information into spreadsheet columns, updating existing rows and adding new records as transactions occur in your Hotmart marketplace.

What Hotmart data can I replicate to Google Sheets?

You can access 11 pipelines including Subscribers, Sales History, Sales Commissions, Subscription Transactions, and Hotmart Club educational data. Each pipeline contains specific fields such as subscriber details, transaction codes, commission values, and student progress percentages that populate separate tabs in your spreadsheet.

How often does Hotmart data update in Google Sheets?

Kondado updates your spreadsheets on a configurable schedule ranging from every 5 minutes to daily intervals. You can set different frequencies for each pipeline, allowing near-real-time monitoring for active sales while using daily updates for historical analysis or student progress tracking.

Can I combine Hotmart data with other sources in Google Sheets?

Yes, you can replicate data from additional sources alongside information from your Hotmart connection to other platforms. This enables unified reporting where you correlate Hotmart sales with advertising spend from Facebook Ads or inventory data from Shopify within the same workbook.

How is Hotmart data formatted in Google Sheets?

Each pipeline creates a separate sheet within your workbook, with column headers corresponding to Hotmart field names like subscriber_code, commission_value, and product_id. Data types are preserved as text, numbers, or dates, allowing immediate use in pivot tables, charts, and formulas without reformatting.

Can I send Hotmart data to destinations other than Google Sheets?

Absolutely, Kondado supports multiple destinations including BigQuery , PostgreSQL , Power BI , and Looker Studio . You can also route Hotmart data to MySQL, Excel, Redshift, SQL Server, or Amazon S3 for different analytical needs.

Do I need technical skills to set up Hotmart to Google Sheets replication?

No coding is required to configure the connection. You simply authenticate your Hotmart account, select the desired pipelines from the available options, and specify your target spreadsheet. The no-code interface guides you through field selection and scheduling without requiring API knowledge or SQL expertise.

Can I track Hotmart Club student progress in Google Sheets?

Yes, the Hotmart Club: Students, Modules, and Student Progress pipelines replicate completion percentages, module access data, and enrollment status directly into your spreadsheets. This allows course creators to build custom learning analytics dashboards that monitor student engagement across different digital products.

Send data from Hotmart to Google Sheets

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Send Hotmart Data to Google Sheets Automatically

Kondado enables you to replicate your Hotmart sales, subscription, and student data directly into Google Sheets without writing any code. By connecting your Hotmart account as a data source, you can automate the extraction of transaction records, commission details, and subscriber information into organized spreadsheets. The platform updates your data on a configurable schedule, ensuring your financial tracking and student progress monitoring always reflect the latest information from your digital product sales.

Kondado provides a direct integration between Hotmart and Google Sheets, offering 11 distinct pipelines including Subscribers, Sales Commissions, Sales History, and Hotmart Club progress data. Users can replicate 202 fields of ecommerce and educational content data on schedules ranging from every 5 minutes to daily, enabling automated financial reporting and student analytics within collaborative spreadsheet environments.

With your Hotmart data automatically flowing into Google Sheets, you can build custom dashboards, share live sales reports with stakeholders, and combine marketplace insights with other business metrics. This eliminates manual data exports and ensures your team always works with current information when analyzing course performance or tracking affiliate commissions.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

What You Can Do with Hotmart Data in Google Sheets

Replicate your Subscribers and Subscription Transactions pipelines to track recurring revenue patterns and churn rates directly in your spreadsheets. By analyzing subscriber_code and status fields alongside transaction dates, you can create dynamic cohort analyses that reveal which digital products generate the most consistent monthly revenue.

Combine Sales Commissions data with Subscriber Purchases records to calculate net profitability per transaction and monitor affiliate performance. The commission_value and price_value fields enable you to build automated margin calculators in Google Sheets, while Hotmart Club: Student Progress data allows course creators to visualize completion rates and identify students who may need additional support.

Try out all the features for free for 14 days

Hotmart data available for Google Sheets

available pipelines

202

extractable fields

Available integrations

Integration	Description
Subscribers	Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.
Sales Commissions	Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.
Subscriber Purchases	Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.
Sales Price Breakdown	Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.
Sales History	Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.
Hotmart Club: Students	Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.
Hotmart Club: Modules	Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.
Hotmart Club: Student Progress	Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.
Hotmart Club: Pages	Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.
Products	Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.
Subscription Transactions	Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

Subscribers

Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.

Sales Commissions

Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.

Subscriber Purchases

Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.

Sales Price Breakdown

Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.

Sales History

Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.

Hotmart Club: Students

Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.

Hotmart Club: Modules

Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.

Hotmart Club: Student Progress

Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.

Hotmart Club: Pages

Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.

Products

Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.

Subscription Transactions

Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

See all available data →

Try out all the features for free for 14 days

How to send Hotmart data to Google Sheets

Sync data automatically — no code, no manual exports.

Connect Hotmart Account

Authenticate your Hotmart data source by providing your API credentials in the Kondado interface. Select the marketplace account containing your digital products and subscription data to establish the initial connection.

Configure Google Sheets Destination

Specify your target Google Sheets document by entering the spreadsheet URL and selecting the workbook where your Hotmart data will reside. You can use an existing file or create a new dedicated spreadsheet for your ecommerce analytics.

Select Pipelines and Schedule

Choose from the 11 available pipelines such as Subscribers, Sales Commissions, or Hotmart Club data, then set your preferred update frequency ranging from 5 minutes to daily. Kondado will begin replicating your selected Hotmart fields immediately and maintain automated updates according to your schedule.

Try out all the features for free for 14 days