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. GSuite Marketplace
To install the add-on, click the install button on Site Catalog’s GSuite 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 'Accept' to complete the installation.
3. Installation Successful
The People Directory add-on is now successfully installed in Google Sheets. You should be able to see Sites Catalog by Awesome Table under Add-ons.