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
The best way to reach support is to enter a support ticket through the Help Center. Here's the direct Submit a ticket link, which is available at the top of every Help Center page. You can also connect with our support team by emailing support@amplifiedit.cdw.com.
If you want to obtain a support contract or have questions, reach out to a Google Customer Support Specialist.
Learn more about the various ways we can help your team.
| Document Version | Date | Description of Change |
| 1.0 | 2/26/2024 | Removed outdated support info (chat) |
| 1.1 | 8/13/2024 | Published after T.Groff edits - email address reverting issue |
| 1.2 | 8/14/2024 | Title change |
| 1.3 | 8/16/2024 | Added email content block |
| 1.4 | 8/19/2024 | From Andrea, yeah mark them as done so they get off that screen - she's overhauling in a few months |