This article describes how to insert your Awesome Table as a gadget in the Classic Google Sites. You can learn more about the difference between the Classic & New Google Sites here.
Before you begin this tutorial, you need to log in to Awesome Table (via your Google account) and have an existing app that you can use.
1. Adding the Awesome Table gadget
Navigate to the Classic Google Sites page.
Click the relevant site where you want to embed your Awesome Table app. The site opens in a new tab.
Click the Edit page icon.
Click Insert > More gadgets. The Add a gadget to your page screen appears.
Select Public > Featured, then enter Awesome Table on the search bar.
2. Selecting the Awesome Table app you want to use
Find the app. You can:
- Enter the file name (or key phrases) of the app (a)
- Scroll through the list (b)
Select the app that you want to use.
3. Configuring the Display (app) settings
You can set the following defaults.
- Width (a)
- Height (b)
- Select the checkbox if you want to include a scroll bar on the gadget (c)
- Select the checkbox if you want to include a border around the gadget (d)
- Select the checkbox if you want to display a title on the gadget (e)
Click OK.
4. Publishing your page
Click Save to publish your Classic Google Sites page with the Awesome Table app gadget.
Awesome Table app gadget inside a Classic Google Sites.
Comments
19 comments
How do I embed this to my Google Sites without a set height? This adds a scroll bar that I don't want. I have tried embedding in an iframe gadget and in the Awesome Table gadget as mentioned above and they both require a height (which can't be auto or 100%).
Thanks
Hello Sshellhammer,
It is definitely possible to change the width of your Awesome Table view when you embed it in a Classic Google Site. You just need to choose the width in the settings (see the screenshot below).
Kind regards.
Thomas
Hi Thomas,
Thank you for your quick reply, although this does not solve my problem. It is the height that I want to change, not the width. I would like to put a height auto or no height at all, but the only option seems to be a set pixel height.
Hello Sshellhammer,
Sorry, I misunderstood your question. Indeed, it is a limitation of Classic Google Site and you can't apply an auto height.
So, I suggest you limit the number of items displayed in your view (see the screenshot below) and apply the correct height in pixels.
Thank you for your understanding.
Thomas
I have put my tables and maps on google site, but when I share the site with other users they can not see the information.
Hello Alejandro,
Can you confirm that you have given access to the source spreadsheet to these people?
Does this only work on classic sites? I'd love to use this on a new google site if possible.
Hello Jake,
Please have a look at this article on how to insert an Awesome Table view in a new Google site.
Nicolas
I have used Awesome Tables with old Google Sites for a long time but just noticed a recent development. All my pages no longer work as expected. The Learn360 movies database is doubling up entries and the nice card setup of the JIT Videos are reduced to just links. I have not changed the setup on either page/spreadsheet. Can you provide some help or is it just time to switch to new Sites?
Doubling of entries
Spreadsheet headers:
No longer showing cards.
Card template:
<div>
<b>{{Title}}</b>
</div>
<div style='color:grey'>{{Description}}</div>
</a>
-webkit-touch-callout: none;
-webkit-user-select: none;
-khtml-user-select: none;
-moz-user-select: none;
-ms-user-select: none;
user-select: none;
}
.card-link{
display: inline-block;
width: 100%;
text-decoration: none;
color: #000;
}
Hell,
I created a ticket because it will be simpler to discuss with you about your issue.
Kind regards.
Thomas
I'm having the same issue as Alejandro even though I've set permissions on my Google doc to be viewable to anyone with the link.
Hi @Emily.
Please share your:
AwesomeTable link - Share with us your AwesomeTable & Google Sheets datasource so we can pinpoint where the problem is and provide the right solution at the soonest possible time. Detailed instructions here.
Google Sheets datasource - It's best to set the sharing settings to Anyone with the link. Click here to learn more.
You can opt to anonymize your content by using *dummy data* (fake, but realistic) if your Sheets contains confidential info.
- Randy
hello, how can make the Order Form of the cards template save to my own datasheet pls? thank you!
Hi @Jorge.
Please create a new (and separate) post (tagged under General discussion) as the question isn't related to the current article.
And on that separate post, please specify what template you're referring to. It would greatly help if you can share your:
AwesomeTable link - Share with us your AwesomeTable & Google Sheets datasource so we can pinpoint where the problem is and provide the right solution at the soonest possible time. Detailed instructions here.
Google Sheets datasource - It's best to set the sharing settings to Anyone with the link. Click here to learn more.
You can opt to anonymize your content by using *dummy data* (fake, but realistic) if your Sheets contains confidential info.
- Randy
Has anyone had problems today with this on existing Awesome Table Gadgets on a classic site?
I have 2 embedded awesome tables ruining in a google site. Some viewers of the site are reporting that the table will not display and it is not giving them the option to authorize.
Here is what the user sees they are logged in with their google account because they can access the rest of the site. the tables are good because when I log in I can see the correct view the way it is supposed to display.
En el momento de compartir URL las personas que quieren acceder no pueden ver la tabla
<!-- Place this tag where you want the Awesome Table Widget to render -->
<div data-type="AwesomeTableView" data-viewID="-Ly4P9OQIfkwY15QYL92"></div>
<!-- Place this within the <head> tag or just before the end of your <body> tag. -->
<script src="https://awesome-table.com/AwesomeTableInclude.js"></script>
AND
<iframe height="600px" width="100%" style="border:none;" src="https://view-awesome-table.com/-Ly4P9OQIfkwY15QYL92/view"></iframe>
cannot public view , access can only be done by the user owner only !
Hi erix bcd.
To ensure that your Awesome Table view is available to your users or visitors, please follow our prescribed method on how to Properly configure your spreadsheet settings.
- Randy
Please sign in to leave a comment.