Project Information

  • Title: Assignment Dashboard
  • Tech: Google Spreadsheet + Google Apps Script
  • Date: Summer 2020 — Present

About

To keep track of my to-dos, I maintain a spreadsheet with the assignment name, due date, priority, status, etc. Since I'm always wrangling tabs, I set up a piece of Google Apps Script to keep my assignments in my inbox. Every morning around 4 AM, I'm greeted with my upcoming assignments.

Honestly, linking the spreadsheet to the script wasn't the difficult part — there was plenty of documentation for this piece. Instead, the challenge was the CSS for the table. I didn't realize that Google Apps Script doesn't directly support CSS, so it took a while to realize why my table rendered incorrectly. Eventually I treated my CSS file like an HTML <style> header and imported it into my main HTML document.