5 Cool Custom Data Dashboards You Can Make With Google Sites

Posted on

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.

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.

Prev2 of 6Next

Leave a Reply

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