18 May 2018

5 Cool Custom Data Dashboards You Can Make With Google Sites


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:

  1. Monitor your email
  2. Analyze your website performance
  3. Create a time management system
  4. Stay informed with live news
  5. 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.

If you have a Google email account, that might be your preferred online Gmail inbox, or any of the desktop email clients out there.

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.

Display Timestamp of Latest Email

It’s possible to sync Gmail with Google Sheets using IFTTT. But with IFTTT you can only do this with one Gmail account. This is why I usually turn to Zapier to sync multiple Gmail accounts to multiple Google Sheets. However, keep in mind that Zapier isn’t free.

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.

cool dashboards with google sites

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:

cool dashboards with google sites

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.

cool dashboards with google sites

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

cool dashboards with google sites

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.

cool dashboards with google sites

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.

cool dashboards with google sites

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.

cool dashboards with google sites

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.

That’s outside of the scope of this article, but we’ve got you covered. There are two ways you can accomplish this. Either set up an IFTTT applet that sends Google Analytics data via email to Google Sheets, or build your own spreadsheet using the Google Core Reporting API.

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.

cool dashboards with google sites

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.

cool dashboards with google sites

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.

cool dashboards with google sites

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.

cool dashboards with google sites

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.

cool dashboards with google sites

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.

cool dashboards with google sites

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.

cool dashboards with google sites

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.

5. Dashboard of Places on Google Maps

If you don’t know you can create and share lists in Google Maps, then you’ll want to explore that feature.

It’s a really useful way to keep track of all of your favorite places in organized lists.

cool dashboards with google sites

How can you use this to build a Google Sites dashboard? Easy. When you click on the Insert menu in Google Sites and click on Map, you’ll see a menu option called My Maps.

Click on that, and you’ll see all of the lists storing your favorite locations.

cool dashboards with google sites

Select one of the lists, and you’ll have an embedded map on your dashboard featuring all of those saved locations.

It’s a really convenient way to store all of your favorite spots on one URL.

cool dashboards with google sites

The next time you can’t remember the location of that hiking trail you love to visit, just open up your dashboard and check out your “hiking trails” map.

Switching between all of your dashboards is as simple as clicking the dropdown icon next to Home, and selecting the dashboard you want to see.

cool dashboards with google sites

You could even use a dashboard like this to plot out an itinerary for someone and then share the URL with them.

They could access it from any browser or phone, no matter where they are.

Start Using Google Sites Data Dashboards Today

The examples above are just the tip of the iceberg when it comes to building useful dashboards that’ll make your life a whole lot easier.

Just think of all the ways you could incorporate YouTube content, map locations, information from Google Docs or Google Sheets, and more.

Google Sites has always been an easy way to make web pages, but with the new Google Sites, you can actually make beautiful and useful dashboards like these. There’s no need for dedicated data dashboard software.


Read Full Article

No comments:

Post a Comment