Humbly liberating SIS data from silos to the cloud!

What could your SIS data be doing for you if it were live synced to Google Sheets?

Schedule the download of CSV exports from your SIS or other data platform backends and set up Local Hero automate data syncs to Google Sheets.

Once the right data is always up-to-date in Sheets, just imagine the possibilities:

  • Create a private, searchable student directory for staff. See demo.
  • Build customized, collaborative data dashboards for leadership and teaching staff. See demo.
  • Create provisioning automations using Apps Script and Add-ons for Sheets
  • Design smarter school processes and interventions that leverage live attendance or gradebook data

How Local Hero works

First, use relevant methods to schedule the delivery of SIS exports as CSV files to your local filesystem — this part Local Hero can’t do for you.  Then set up Local Hero to automatically map and sync these CSV files from your filesystem to a destination Google Sheet, on the schedule of your choosing.  Now use this live synced Sheet and a growing universe of Google Add-ons — or write your own custom time-triggered Apps Script utilities — to build downstream processes and tools like dashboards, workflows, and automations.

Choose how you want updates handled

Select if and how you want source data to update records in the destination Sheet.

Map CSV data to its destination

Indicate which columns to include, and how you want columns to be mapped, from source CSV to destination Sheet.

Schedule and manage multiple jobs

Local file updates get automatically pushed to the destination Sheet on a schedule of your choosing.

Important note:  On Aug 19th, 2016, Google announced that they are discontinuing support for local Chrome Apps in early 2018.   Because Local Hero requires the use of scheduled tasks that access the local filesystem, and these features are not possible to build via progressive web applications, Amplified Labs can no longer support Local Hero for Chrome OS devices.  

This means that if you installed the original Chrome App, you must migrate to the new Mac or Windows version (see below) and manually re-build your jobs.  Apologies in advance for this (sadly) unavoidable inconvenience.

Update on July 26, 2017:  Local Hero has been ported to an Electron.js application that is compatible with Mac and Windows.  The installer packages are available below:

Serve insights to teams

Roll your own live data dashboards in Sheets from locally scheduled SIS exports.

Automate processes

Let your SIS live in the dream of Google Sheets Add-ons.

Rethink Provisioning

Drive, Groups, Users, etc. Once your SIS data is in Sheets, there’s an Apps Script API for that.

Free

$0/year
  • Maximum of 1 sync job per user
Install now

A la carte domain subscription

starting at
$250/year
  • Get a free 30-day trial when you request a quote.
  • Discount for GAFE Collaborative members
  • Unlimited sync jobs for any user on the domain
  • Dedicated help desk support
  • Subscription price subject to district size multiplier
  • Receive an on-boarding video call with our consulting team (additional $150)
  • Need additional help? Amplified IT’s expert consultants can always help you with custom implementation.
Build me a quote

Get help

Learn more about how to install and use Local Hero.
Support & FAQ
Check out these other Amplified Labs tools
Manage your Chrome devices with bulk power, reporting intelligence, and efficiency.
Remove the administrative bottleneck and empower school-level staff to keep their own domain groups up to date.
Bulk-generate Google calendar events from Sheets.  Automate event creation from Forms.
Auto-sync your SIS rosters to Google Classroom.
Share This