5 Cool Custom Data Dashboards You Can Make With Google Sites

Posted on

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. computer science computer science computer science computer science

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

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. computer science computer science computer science computer science

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. computer science computer science computer science computer science computer science computer science

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

Something like this: computer science computer science computer science computer science

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. computer science computer science computer science

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. computer science computer science computer science

Prev1 of 6Next

Leave a Reply

Your email address will not be published. Required fields are marked *