123 SYnc for Google Fit
Description of 123 Sync for Google Fit
When to use it
The Google Spreadsheet™ add-on can be used to sync your Google Fit™ data to your spreadsheet. Easily capture the progress, and display it in custom charts or tables. Keep the Google Fit data as long as you want. You can even share it easily with your personal trainer or coach to get personal advice.
Some example use case;
Keep track of your weight, heart rate and steps
Compare values by day, week, month, year
Create charts to illustrate your data
The add-on is ideal if you want to analyze your data in Google Fit.
How it works
After creating a new Google Spreadsheet and adding the add-on “123 Sync for Google Fit” you take the following steps:
Specify the Start date to get your initial data
Decide the scope of data to sync and start your sync
Setup a schedule to get new data in the spreadsheet
After the add-on schedule is activated the script runs on the specified period and adds new data points to your Google Spreadsheet.
In the Google Spreadsheet add-on menu you can choose “About”, “Configuration” or “Help”.
About shows a popup window with a short description
Shows the sidebar screen for the configuration
Help shows the default Google screen
Clicking About in the menu will show a pop-up window which explains the add-on briefly.
You can click the “Open help” link to this help guide, the Start button to show the sidebar with the configuration menu, or click Close for closing the popup window.
1 - Sync Data
Clicking Configuration in the menu will show the sidebar of the Google Spreadsheet add-on.
Select the scope of data you want to sync. After you save your selection the specified scope will be used for the initial sync as well as for the scheduled sync.
Specify the start date for the initial sync.
Click the button Get Data to start the sync
a message will confirm your selection, click OK
a message will be shown when the sync is finished
Note, at the bottom of the screen you see;
the Help link to open this help document.
the Privacy link to open the Privacy statement
link to the product homepage
version number is displayed as well (for support reasons)
2 - Set schedule
3 - Create charts
The 3rd step is currently a manual step. You can add charts in the Spreadsheet to visualize the data.
Send an email to email@example.com with your chart ideas and they will be added to the standard functionality of the add-on.
About the add-on
The Info page shows a bit generic information about the add-on.
Read the requirements for correct functionality.
Read what to do in case of an issue.
Read what to do in case you like the add-on.
How to add the Google Workspace extension '123 sync for Google Fit' to your Google Spreadsheet as an add-on ?
Option 1: Installation from the spreadsheet
Start a new Google Spreadsheet in Google Drive. (https://sheets.new)
In the top menu bar of the Google Spreadsheet select Extensions.
Click in the menu “Add-ons” and “ Get add-ons”.
A new pop-up window will show the Google Workspace marketplace.
Search for “123 Sync for Google Fit”.
Click the button “Individual Install”.
Option 2: Installation from the Google Workspace marketplace
Go to the Google Workspace marketplace: https://workspace.google.com/marketplace
Get ready for Install
Click Continue to confirm that your want to install the Google Spreadsheet extension.
Google will inform you after a few seconds that the Google Spreadsheet extension is installed.
The Google picture is a bit outdated, as Google has renamed Add-ons to Extensions.
FAQ - Frequently Asked Questions
Is there a product roadmap available?
Yes a roadmap is available, when there is interest in this add-on. The following features will be added.
default charts to visualize your data
extend the scope of data which is exported from Google Fit into your Spreadsheet
speed up the add-on for collecting data and writing the data to the Spreadsheet
improve error handling when you schedule the add-on
How do I know my personal health data from Google Fit is safe?
The add-on is completely safe to use. The add-on only reads data from Google Fit and can not change your data in Google Fit. The add-on also only stores data in the Google Spreadsheet where the add-on is installed in. Hence your personal data is not visible to anyone else. However you can of course share your the Google Spreadsheet with those who you trust.
That the add-on only has access to the current Spreadsheet, is shown in the Consent screen that you see during installation. You can also find those authorizations in your Google account by going to this page: https://myaccount.google.com/permissions.
Note: the privacy statement of the application is also vetted by Google.