Managing the results of a digital business requires organization and quick access to sales information. To make this process easier, Hotmart offers direct integration with Google Sheets through an extension. By centralizing your sales and subscription data in one place, you gain the flexibility to build custom dashboards, analyze your product’s performance, and track revenue growth without having to manually export reports every day.
In this article, you'll learn in detail how the Google Sheets add-on works. You'll find step-by-step instructions on how to install it in your Google environment, generate the necessary credentials within the Hotmart platform, and connect both tools.
What is Hotmart for Sheets and how does it work?
Hotmart for Sheets is an extension designed to connect your creator account directly to Google Sheets. This tool eliminates the repetitive task of downloading CSV or XLSX files from the platform to update your internal records. Once the connection is established, the extension imports your transaction history directly into the spreadsheet of your choice.
The integration works through security keys generated in your user account. These keys ensure that only your spreadsheet has authorized access to read sales data from the platform.
It's important to note that the add-on was designed to consolidate structured revenue data, transaction statuses, and basic buyer identification information, serving as a reliable database for your financial management.
How do I install the add-on in Google Sheets?
The first step of the setup process takes place directly within Google Sheets. Installation is completed through the Google Workspace Marketplace.
- Open Google Sheets and create a blank spreadsheet where you want to centralize your business data.
- In the top menu, click Extensions (or Add-ons) and then select Add-ons > Get add-ons.
- In the search bar of the Google Workspace Marketplace window, type Hotmart for Sheets.
- Click the official Hotmart add-on and then select Install.
- Google will request the necessary permissions so the add-on can write data to your spreadsheet. Click Continue, select the appropriate Google account, and click Allow.
Once the process is complete, you'll see a confirmation message indicating that the installation was successful.
How do I create access credentials on the Hotmart platform?
With the extension installed in your browser, the next step is to generate credentials in Hotmart so the spreadsheet knows which account to retrieve information from.
- Log in to your Hotmart account at https://app.hotmart.com.
- In the left-hand menu on the main screen, click Tools.
- From the list of available tools, locate and select Hotmart Credentials.
- In the top tab, make sure you are viewing the correct environment and click + Create Credential.
- Assign a clear name to your credential (for example, "Sales Spreadsheet Sheets") and click Confirm.
- The screen will display three essential codes: Client ID, Client Secret, and Basic. Copy these codes and download the information, as you won't be able to view them again after completing the creation process.
How do I complete the connection between Hotmart and my spreadsheet?
Now that you have installed the add-on and generated the security keys, you only need to complete the final connection within Google Sheets.
- Return to the blank spreadsheet you created at the beginning of the process.
- Click Extensions again in the top menu, locate Hotmart for Sheets, and click Open.
- A sidebar will appear on the right side of your spreadsheet with authentication fields.
- Carefully enter the Client ID, Client Secret, and Basic codes generated in your Hotmart account. Make sure not to copy any extra spaces before or after the values.
- Click Submit.
The system will validate the information with Hotmart's servers. If everything is correct, the extension will display a success message and unlock the search screen so you can start importing your product data.