Site data to sheets

In Analyzing site content with GAS I showed how to analyze a Google Site and get the data as json, or file it on Google Drive. Next we want to do something with it. Here I'll use the Rest to Excel library to get data into both Google Sheets and Excel. We'll use the already created and hosted on gDrive file (although we could equally execute it from Excel or GAS and get love json using the same technique).

Type of analysis.

There are a few types of analysis we could do with the data, but we'll start with a very simple site profile - meaning a list of pages, urls and their parents.