How to integrate Data into Google Spreadsheet

1. Load and copy the doc (it’s the template document in this use case): https://docs.google.com/spreadsheets/d/1atEE4DNdluGtQLvP8YR-Sim-oEHK-DKL_TXXNLHeYRI/edit?usp=sharing

Open

Open

2. Then go to Extensions and choose → Apps Script .

3. Deploy the Data Feed script as it’s shown below:

• Click the Deploy button and choose New deployment from the drop-down list.

• Check information in the Configuration pop-up and click the Deploy button.

• Authorize access to your data.

• Click the Allow button.

• Click the Done button to finish the deployment.

4. Add scheduling for updating results.

• add trigger, (2 screen), 3 screen - result

• Select the Run function in the Choose which function to run item and click the Save button.

When you open the spreadsheet, the data will be updated.

You can select other options in the Select event source before updating the information if you need to.

5. You should return to the document and delete the Settings tab.

6. Press F5 button or reload a page. When the page is loaded, you will see a pop-up where you need to insert the Data Feed link (the link that is generated in the add-on).

How to get the JSON Data Feed link?
Go to the Time in the Status report, open the dropdown, and select Data Feed.

Select the Preset you want to receive as the JSON Data Feed link.

Copy the generated link.

Insert the Data Feed link

7. When you insert the link and press the Save button, the report will be loaded. Then, you can go to the Report tab in your document and get a result.