HubSpot’s reporting tools are powerful, but sometimes businesses need more customized insights than the default dashboards provide. That’s where the HubSpot Analytics API and Report API come in. These API let you fetch data programmatically, process it in your own application, and build fully custom reports tailored to your business needs by creating custom reports with Hubspot API integration.
In this blog, we’ll walk through the steps to create a custom HubSpot report using APIs, from fetching CRM data to visualizing it in your own dashboard or application.
Prerequisite
- HubSpot Developer account
- Latest version of Node.js
- Basic Knowledge of JavaScript and REST APIs
Steps to Create Custom Reports with Hubspot API Integration
Step 1: First, Create a HubSpot Private App.
HubSpot->Settings->Integrations->Legacy App->Create Legacy App->Private App.
Enter the ‘Name’ of the app in Basic info option.
Then, go to Scopes, and add new scope.
- Click on Create App.
- Copy the Private App Access Token.
Step 2: Set Up Your Integration.
- You can integrate HubSpot’s API with various platforms but here we’ll use Google Sheets.
- Create a Google Sheet and define column headers according to the object attributes you plan to extract for the report.
Step 3: Create a Google Service Account.
- Go to Google Cloud Console.
- Make sure you are logged into the Google account you want to use for this project.
- If you don’t have a project yet, create one by clicking on Select a project->New Project
Give it a name and Click Create. - Go to APIs & Services->Library->Search for Google Sheets API->Click Enable.
- Also, enable Google Drive API.
- Go to IAM & Admin->Service Accounts.
- Click Create Service Account->Enter details->Click Create and Continue.
- You’ll see Service account permissions (optional)->Add Editor->Click Done.
- In the Service Accounts list, click your new service account.
- Go to Keys ->Add Key->Create New Key->Select JSON and click Create.
Step 4: Share Your Google Sheet with the Service Account.
- Open your Google Sheet.
- Click Share->Add People and Groups.
- Enter the service account email .
- Give Editor access and click Send.
Step 5: Setup Backend (Node.js Local Server)
- Run these commands in your command prompt: npm init -y and npm install express axios googleapis body-parser.
- Create an index.js file.
Step 6: Run the server.
- Run node index.js.
- Open in browser: http://localhost:3000/update-leads
- Check Google Sheet ->data should be updated.
Step 7: Connect Google Sheet to Looker Studio.
- Once your data is in Google Sheets, you can use Google Looker Studio to create interactive, shareable reports.
- Go to Looker Studio->Create->Report.
- Add Google Sheets as data source->select your Sheet and tab.
- Build custom charts, tables, and metrics based on the data pulled from HubSpot’s API.
Watch Live Demo
Conclusion
Building custom reports with HubSpot’s API unlocks far more control than standard dashboards, allowing teams to analyze data exactly the way their business requires. By integrating HubSpot with Google Sheets, Looker Studio, or any analytics platform, you can automate data collection, build deeper insights, and create fully personalized reporting workflows. With the right setup, your HubSpot API integration becomes a scalable, future-proof solution for reporting, analytics, and performance tracking.
Get End-to-End HubSpot Development Services Designed for Your Business Needs.
No Data Found.
India 
USA
UK
Canada