What you’ll learn
In this article, you will learn:
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.
Support
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.