This guide will walk you through how to authenticate or reauthenticate Semrush Projects in Supermetrics with Google Sheets, Data Studio, and Excel.
Before you begin
To connect Supermetrics to Semrush Projects, you need an API account with Semrush and a Semrush subscription for API request units. Learn more about Semrush accounts and API request units.
Each API call has a cost, and the cost of requests is measured in API units. Units are determined by the type of report or request retrieved from the Semrush API, and fetching historical data requires more units than live data. One US dollar is equal to approximately 20,000 API units.
Instructions
- Open a new Google Sheets file
- Click Add-ons → Supermetrics → Launch to open the sidebar.
- Under Data source, select Semrush Projects.
- Enter your API key and click Start.
- Select the project.
- Navigate to Report configuration.
- Select the query type.
- Open the Supermetrics data source gallery.
- Navigate to Semrush Projects and click Try.
- Click Authorize.
- If you're authenticating the data source for the first time, log in to Supermetrics with the Google Account you use in Data Studio. Click Allow.
- Click Authorize.
- Enter your API key and click Start.
- Select the project.
- Select the query type and click Next.
- Depending on the query type you choose, there will be additional filters to select. The Tracked URL field is required.
- Click Connect on the top right-hand side.
- Click Create report.
- Click Add to report.
Connections
If you use Excel and no other Supermetrics products, you’ll be able to connect accounts to data sources and share these connections with your team. You can manage connections either within the add-in sidebar or via the Supermetrics Team Site. Learn more about shared connections.
Before you can authenticate Semrush Projects in Excel, you need to install the Supermetrics add-on.
- Open an Excel file.
- Click Data → Show Supermetrics
- Under Data source, select Semrush Projects.
- Enter your API key and click Start.
- Select the project.
- Select the query type.
Troubleshooting
- If you encounter an authentication error such as “authentication failed”, “you need to reauthenticate” or similar, see this guide.
- If you encounter a permission error such as “user permission denied” or similar, follow this guide.