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 for Windows, Mac and Linux users:  On Aug 19th, 2016, Google announced that they will be discontinuing support for Chrome Apps for non-Chrome OS devices in early 2018.   Chrome OS devices can now access Windows network drives, which bridge the local filesystem to the Google cloud, allowing Local Hero to remain quite useful when running on Chrome OS!  Nevertheless, users should be aware that after 2018, this app will require a device running Chrome OS.

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

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