Quick Start Guide

What you’ll learn

In this article, you will learn:

What is Local Hero?

Installing the application

How to Create a Google Sheets sync Job

How to Create a BigQuery sync Job


What is Local Hero?

Local Hero acts as a transfer service between CSVs and Google Sheets. It is commonly used to sync CSVs from a SIS to a Google Sheet which can then be made into custom reports and dashboards and shared with people who may not have access to the SIS data. It can be used with any CSV though to sync and keep a Google Sheet up to date.

Installing the application

Local Hero is a local install on your device. Check out this Help Center Article to get the installer file.

How to create a Google Sheets sync job

To setup a Google Sheets sync job, you’ll need to make sure you have the CSV on your device, and a Google Sheet already created. Clicking on the plus icon will allow you to create a new job. There you will link the CSV and Google Sheets ID, map your headers, choose how you want your data synced, and schedule your automated syncs.

How to create a BigQuery sync job

Local Hero does support BigQuery, but the BigQuery service is a separate and paid service. If you are interested in using BigQuery reach out to your account manager for help setting up the billing for your service. To set up your BigQuery sync job, check out this Help Center Article.


You can access support from the Customer Success team a couple of different ways:

Live chat, when available, is located at the bottom of the sidebar. When chat is offline, you can instead open a support ticket from the chat widget. 

Also, we have an extensive Help Center with knowledgebase articles on the tool and its features, and you can also access the live chat from here, as well as submit a ticket. 

Finally, you can always email support@amplifiedit.com to open a support ticket with us at any time. 

Articles in this section