Generate a Full Account Report with Google Sheets and the Instapage API

Using our Google Sheets spreadsheet template and your personal API token, you can generate a comprehensive spreadsheet report of your workspaces, pages, traffic, and conversions.

Download a copy of the template

A copy of the spreadsheet will be created in your own Google Drive account upon clicking the following link: https://d.pr/jyhSKs 

The spreadsheet already has all the necessary coding to generate your report without any additional effort required from your side.

Connect your token

1. To get the token from your Instapage account, go to https://app.instapage.com/account. More information about the Personal API Token can be found in the dedicated guide here: https://d.pr/ELj2Z2

2. Navigate to the spreadsheet tab called Input Information and paste your confidential token in the B1 cell (the first row, second column).

The cell is formatted with a white font color. This is done to obscure the content from screen recordings as long as the B1 cell is deselected. It is crucial that you treat the token as confidential information, as it can provide access to all of your Instapage account data, including leads.

Screen Capture on 2025-02-04 at 19-13-19.gif

3. Click on Generate Report

The first time you do this it will open a Google authentication and authorization screen. Proceed to Allow the requested permissions, and then you will be taken back to the spreadsheet.

Click on Generate Report again, and the spreadsheet will auto-populate with data. Depending on your account's size, this can take a few minutes.

View the data

Once data is being pulled in, you can navigate to any of the spreadsheet tabs to view it, sort it, export it, and use it to make decisions that will boost your conversions.

Please note that Personalizations are not shown in the report. The published page count will exclude them. 

Keep in mind that changing the structure of the spreadsheet means altering the custom script that was used to generate it. If you want to make edits or write your own scripts, we recommend involving your developers early to clarify what is possible and where they can support. You can share our API documentation (https://devdocs.instapage.com/) with them to get started.

Convert customers can also generate custom reports with the help of our Professional Services team.  More information about Convert benefits can be found on our pricing page: https://instapage.com/plans