Local Hero

  • Overview

  • Local Hero is a server app that allows you to sync your SIS data with Google Sheets and BigQuery for creating customizable dashboards and automations.

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

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

    • Connect Sheets or BigQuery to Google Data Studio to design smarter school processes, dashboards, and interventions that leverage live attendance or gradebook data.

    • Create a private, searchable student directory for staff using Spreadsheet tools like Awesome Table. 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

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.


$0 per year

Hello World 🙂

  • Maximum of 1 sync job per user
  • Get your first 30-days of premium access for free when you request a quote

Install Now

A la carte domain subscription

starting at

$250 per year

Hello World 🙂

  • Additional 10% discount for GFE Technical Collaborative members
  • Unlimited sync jobs for any user on the domain
  • Dedicated help desk and live chat support
  • Subscription price subject to district size multiplier
  • Get your first 30-days free when you request a quote below

Build Me a Quote

Get help

Learn more about how to install and use Local Hero.

Support & FAQ