In this article, you will learn how to insert an Awesome Table view in a Classic Google Site using Awesome Table's gadget.
1 - Add the gadget to your Google Site
- Open the Gadget Gallery
Open the Google Site Page where you want to add the gadget.
Edit the page and click on menu Insert > More gadgets.
Edit the page and click on menu Insert > More gadgets.
- Find Awesome table's gadget
In the search bar, write "Awesome Table" and click on "Add".
If you are not already connected or if you never logged to Awesome-Table.com before, you will be prompted to log-in the web application Awesome-Table.com :
If you are accessing the application for the first time, you will be asked to accept the authorization Awesome-Table.com need to work.
info These authorizations are subject to changes without warning to adapt the application evolution. If that is the case, you will be prompted again with the new scopes.
2 - Managing your Awesome Table views
- Creating or editing a view :
You can access all of your existing Awesome Table views within the gadget's user interface. You can choose to edit one of your views by clicking on the pen icon or create a new one by clicking on the + button.
- Inserting an Awesome Table view :
Click on a view in your list and press the OK button.
Comments
16 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.
Please sign in to leave a comment.