Note: All pages below are subject to having relevant Roles and Permissions.
Step 1 – The Bromcom Report
Create your Report in Bromcom, and Save it. Next, you will need to get the link for the Live Data Feed, to do this go to Reports > Ad Hoc > View Reports, then locate your report and select it using the tick box on the left, then go to Actions and select Live Data Feed.
The following pop-up will display. Click Copy to Copy the Live Data Feed Link to your clipboard.
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, this will be your Password, to find the User Access Key click on your Profile Icon in the top right hand corner, then select My Account.
Your User Access Key will be displayed on the right hand side. If it displays as N/A, click the Refresh symbol to the right hand side to generate a new User Access Key.
Once the Key is displayed, you can make a note of it for later, alternatively, once you’re ready to enter your password you can come back to this page and click the Copy symbol to Copy the key to your clipboard.
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.