public_pages:feed_sheets [LDR Knowledge Base (Keep it ISO)]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Feed Sheets ======

Pull data from our web portal into Google Sheets automatically, at regular intervals.

===== How to do get started =====

First, log into our web portal and navigate to the [[https://app.ldrprep.com/?page=mrscApiSetup|API Intergrations section]], as shown here.

{{:public_pages:bee9148ccba08e74ee4290effe3d2250.png}}

If you do not already use Feed Sheets or our API, you will need to generate an API key by clicking the Generate button as shown here:

{{:public_pages:5a0e9012b0991729818a693849d4bad2.png}}

Once you have done this, you will be able to download various reports in CSV format using the links on that page.

You can copy and paste these links into Google Sheets using the IMPORTDATA function, like this:

**=IMPORTDATA("URL FROM NMI", ",");**

That will cause Google Sheets to periodically download and import that Feed Sheet. Generally, Google Sheets will update the data about once per hour.