You want to create a site catalog to list all Google sites hosted in your domain and you want to display it in Awesome Table. This article explains how to install the Sites Catalog add-on for Awesome Table.
1. G Suite Marketplace
To install the add-on, click the install button on Site Catalog’s G Suite Marketplace page.
2. Granting permissions
After clicking this button, an authentication pop-up appears. Select the relevant account to install the add-on.
Once selected, you will be prompted to grant permissions to Sites Catalog. Click Allow to complete the installation.
3. Installation Successful
The People Directory add-on is now successfully installed in Google Sheets. You can now see Sites Catalog by Awesome Table > List all sites.