It's now easier to add an Awesome Table view in the "New" Google Sites.
- Go to your Awesome Table view and click on the share button
- Copy the share link
- Go to your Google Site on edit mode, than click on "Embed Url".
- Paste the link inside "Embed Url"
- Click on "ADD", and adjust your Awesome Table