Note: All pages below are subject to having relevant Roles and Permissions.

Step 1 – The Bromcom Report

Write your report (or pick an existing one). Preview the report and then select the Live Data Feed and Copy the URL from the Live Data Feed box. Note the Live Data Feed is only available on Custom Reports.

Step 2 – Your Username and Password to access the Report

You need the School Site ID which will be your Username. You also need your User Access Key, which can be found under your Profile, click on your image top right of the screen and select the My Account option from the dropdown list and scroll down to the General section, your User Access Key will be displayed here, make a note of these.

Step 3 – Setup the Google Sheet

Create the Google Sheet that is going to receive the Data.

Note: Please double check the code after pasting, as it may not copy and paste correctly, especially the double and single quotation marks.

Click on the Tools option and select Script Editor and paste in the following code:

Click below to download a document containing the code.

In the code replace the Red text below with your report URL, your School Site ID and your Access Key.

              REPORT LIVE DATA FEED URL – “Replace this text with your report URL“,

                    ‘SCHOOLID‘ – “Replace this text with your School Site ID“,

                    YOUR KEY HERE – Replace this text with you Access Key“);

Select Save and name the Sheet, this will Save the Script. Select the Main function, to the right of Debug and then click on Run. Your Bromcom report will now appear in your Sheet.

You can click the Timer button to make Main run on a Schedule – to update the Data as often as you like.

Note: Please double check the code after pasting, as it may not copy and paste correctly, especially the double and single quotation marks.