Google Sites is one of the most convenient ways to create and publish a website with the least amount of effort. With the tools available in Google Sites, you can actually create very useful personal dashboards that can boost your organization and productivity.

In this article, you’re going to see how you can use Google Sites to create some very cool dashboards that can:

Monitor your email

Analyze your website performance

Create a time management system

Stay informed with live news

Save your favorite locations

1. Email Monitoring Dashboard

One of the most annoying things about email is that you need some kind of email client to know when a new email has arrived in your inbox.

But with Google Sites, you could actually build a custom data dashboard to display all incoming emails in one place. With a single dashboard, you can just glance to see all the new incoming emails for the day.

This requires syncing Gmail to a Google Sheets and then displaying those sheets in a Google Sites page.

With Zapier, you just create a “Zap” with an input for the Gmail account you want to monitor and choose it to trigger with every new incoming email. Then choose Google Sheets as the output.

You should create a Google Sheet called “Incoming Emails” ahead of time.

Zapier lets you choose the spreadsheet by name and the worksheet inside it where you want your email information to go.

In this first example, you’ll create a widget on your dashboard that shows each account.

Something like this:

Every few minutes, the script will run and update the second column, of the row you specify.

So to update the MakeUseOf row with the timestamp of the latest email in the inbox, I’d choose row three. Then select the email data you want to import.

In this case, I’m importing the received date of the latest email.

Once an individual “Zap” is created for each gmail account, the dashboard widget will look something like below.

You can import this widget into your Google Sites web page (dashboard) by clicking on Sheets under the Insert menu on the right side of the page.

Display All Incoming Email

To add a widget that’ll show you all the incoming emails for the day, create the same kind of Zap. Also, create three columns in the sheet: Name, Date, and Subject.

Then, when you add the Sheet action in the Zap, you’ll choose the same workbook, but choose the sheet you created for that email account.

Then fill out the fields with the email data you want to import.

This will bring all new incoming emails into your new Google Sheet. Here’s what the widget will look like when you import it into your new dashboard.

Of course, you don’t want to just let this sheet keep filling up. The widget’s purpose is to show you incoming emails for the day, so you’ll want to add a Google Script to the sheet to clear out the sheets every day at midnight.

This is very easy to do. In the Google sheet, just click on the Tools menu, and select Script editor.

Paste a new function called “ClearAll” into this script editor.

function ClearAll() {
var start, end;
var sheet = SpreadsheetApp.getActive().getSheetByName('Makeuseof');
start = 2;
end = sheet.getLastRow() - 1;//Number of last row with content
//blank rows after last row with content will not be deleted
sheet.deleteRows(start, end);
var sheet = SpreadsheetApp.getActive().getSheetByName('IAMMarketing');
start = 2;
end = sheet.getLastRow() - 1;//Number of last row with content
//blank rows after last row with content will not be deleted
sheet.deleteRows(start, end);
var sheet = SpreadsheetApp.getActive().getSheetByName('Gmail');
start = 2;
end = sheet.getLastRow() - 1;//Number of last row with content
//blank rows after last row with content will not be deleted
sheet.deleteRows(start, end);
}

You’ll want to edit the “getSheetByName” section with the actual name of your sheets that contain the emails.

To run this script every day at midnight, in the Script Editor, save your script by clicking on File and then Save. Then click on Edit and Current project’s triggers.

Set the events to Time-driven, Day timer, and Midnight to 1am. Then click Save.

This will clear all sheets at midnight, so every morning you’re dashboard will start with a fresh sheet, displaying only the latest incoming emails for the day.

2. Website Performance Dashboard

Another useful data dashboard is a performance display if you own or operate a website.

To create a dashboard that shows you data about your website performance, you’ll need that data in a location that automatically updates. Since Google Sites lets you import charts from Google Sheets, you’ll want to set up Google Sheets to automatically receive data from Google Analytics.

The reporting API is much more powerful and gives you access to nearly all of the data Google Analytics collects about your website, but it has a slightly steeper learning curve.

Once your spreadsheet is receiving data and you’ve created a few charts that plot your traffic or demographics, you’re ready to build your dashboard.

In Google Sites, just click the Insert menu and select Charts. Browse to the spreadsheet in Google Drive where you’ve saved your spreadsheet, and Google Sites will give you the option to select any of the charts that exist in that spreadsheet.

Build your website dashboard by clicking each of the charts you want to include, and place them on the page where you’d like them to go.

In just a few clicks you’ll have a beautiful web performance monitoring dashboard.

You don’t need an individual Google Site for these different dashboards. You can create sub-pages on the site for each individual dashboard.

This way there’s just one URL to access everything you want to monitor.

3. Time Management Dashboard

If you have several Google Calendars, you can use a time management dashboard that displays three formats of your calendar: Agenda, The Week, and The Month.

Unlike Google Calendar where you have to flip between these views, you can create a Google Sites dashboard that displays them all at once.

Even better, you could embed all the calendars from all of your Google accounts on a single dashboard. Here’s how you do it:

In Google Sites, under Insert, click on Calendar.

This gives you the option to select which Google Calendar you want to insert.

When you select the calendar you want to embed, under View Selection, you can choose from Month, Week, or Agenda.

To create a dashboard with all three, just insert one of these at a time into the dashboard.

Choose a clean layout for the three formats, and you’ll have a highly functional time management dashboard.

Since the Agenda view is so narrow, you could easily fit the Weekly calendar view beside it.

Then, add the larger Monthly calendar view underneath both of those.

Also, you can switch the display mode of each of these widgets on the live dashboard at any time. So you aren’t stuck to a static display after setting it up.

If you want to include calendars from your other Google accounts on the same page, just scroll down to the bottom and start adding more. Or you can create an entirely new sub-page for each Google account.

The layout you choose for your dashboard is completely up to you!

4. Live News Dashboard

If you’ve ever wanted a “mission control” panel with a bunch of displays streaming lots of information at you all at once, Google Sites is the perfect platform to do it.

In the Insert menu, click on YouTube. This brings up a search field where you can find any video on YouTube you may want to embed on your web page.

Most YouTube videos are static though, which would be pretty boring. Luckily there are live news channels on YouTube you can embed. Just search for “live news” or “live” followed by your favorite news network, to find them.

After you’ve embedded all of the live YouTube streams you want to monitor, you can click on each of them to start them playing.

All videos will stream simultaneously on the same page. It looks really cool and will make you feel like you’re sitting at a desk at mission control under Cheyenne Mountain.

SUPERB TECHNOLOGIES CREDIT SOLUTIONS ARE THE BEST; THEIR SERVICES ARE SATISFACTORY COS THEY HELPED WITH MY CREDIT ISSUES AND GRANT ME A VERY GOOD SCORE OF 793.YOU CAN CONTACT THEM FOR MORE OF THEIR SERVICES VIA. SUPERBTECHNOLOGIES444 AT GMAIL DOT COM

Ryan has a BSc degree in Electrical Engineering. He's worked 13 years in automation engineering, 5 years in IT, and now is an Apps Engineer. A former Managing Editor of MakeUseOf, he's spoken at national conferences on Data Visualization and has been featured on national TV and radio.