Embed Google Analytics to Blog without API

This is how to put statistics from Google Analytics (Embed) into Blogger without API. Many bloggers find working with the Google API too technical, making it difficult to implement. There is another way to do this, namely by using Google Sheets. Here is an example.

How to add statistics from Google Analytics to Blogger without API

To add or embed statistics from Google Analytics to Blogger easily without API, you need to follow the steps below:

1. Go to Google Sheet page

2. Choose Blank

3. Select Add-ons (you need to install the Google Analytics Add-on if you don't have one already)

4. After the Google Analytics add-on is installed, select Add-ons -> Google Analytics -> Create new report (you will see a dialog box where you have to fill in the available fields).

5. In the configuration options section, leave Metrics and Dimensions blank. We'll fill it in later.

6. Click Create report

7. After the report is generated, fill in the metrics with ga:sessions and fill in the dimensions with ga:country.

8. Click Add-ons -> Google Analytics -> Run reports

9. If there are no errors, then your report status is successful.

10. Block the Breakdown Results section and Click Insert Chart.

11. Make chart adjustments if needed.

12. Click the chart then click the three dots at the top right of the chart and select Publish chart.

13. After the chart is published, select Embed and copy the HTML code in the box provided.

14. Paste the copied HTML code into any page where you want the statistics to be displayed.

That's how to add blog statistics from Google Analytics to your blog page without API. The data will automatically update as long as you don't delete the Sheet file from your Google Drive account.