Google Sheets

Automatically import your daily nutrition data from MacrosFirst to Google Sheets™.

success icon
The Google Sheets integration is a MacrosFirst Premium feature.

You will learn

Learn how the Google Sheets™ integration enables you to import daily nutrition totals from the foods you logged in MacrosFirst into any Google spreadsheet without manual data entry.

If you work with a nutrition coach in a shared Google spreadsheet, this integration will automate a significant portion of the check-in process. It also makes performing advanced analysis of your nutrition trends much easier.

This guide explains how to add the MacrosFirst add-on to Google Sheets and how to use it.

Add the MacrosFirst add-on to Google Sheets

info icon
A computer is required to install and use the Google Sheets integration. It is not available on mobile devices.
  1. Install the MacrosFirst add-on to Google Sheets here.

  2. In your Google Spreadsheet, open the MacrosFirst add-on

  3. Within the add-on, click Connect to connect your MacrosFirst account.

  4. Log into your MacrosFirst account and grant access to the Google Sheets importer

  5. Close the MacrosFirst tab and return to your spreadsheet where you’ll find the Importer is now connected to your MacrosFirst account.

Once you’ve installed the Imported and connected it to your account, you’re ready to import your data.

Importing Data

There are two steps to importing data to your spreadsheet:

  1. Select the cells in the spreadsheet to update

  2. Click Import Now

Selecting the Cells to Update

The Cells to update input is where you specify the data range in your spreadsheet that the MacrosFirst importer can write your nutrition data into. You can select your data range by typing it in, eg C11:I16, or by clicking the grid icon and selecting the cells with your cursor.

The importer is designed to support a huge variety of custom formatted Google Sheets. The only requirements are that the cells to update are bordered by:

  1. A single row above the cells to update containing either dates or nutrient names

  2. A single column left of the cells to update containing either dates or nutrient names, that is whichever of the two is not also in the row above the cells to update

Checkout this sample Google Sheet which you can play with to see the two table formats in action.

Metrics from MacrosFirst can be matched to any of the following metric names in your spreadsheet:

* Additional metrics coming soon.

Update Empty Cells Only

The default setting of the importer is to update empty cells only. You can change this by unchecking the checkbox to enable overwriting all cells within the selected range, even those that already contain data.

Schedule Daily Imports

You can schedule your imports to run automatically once a day. This is a great way to automate your check-ins when working with a coach in a shared spreadsheet.

  1. Check the box next to Schedule daily imports

  2. Select the time when the import will run daily

  3. Click Import Now to run the import and set the schedule live

Scheduled imports will run within one hour of the specified time. For example, if you set the scheduled time of 1:30 PM, your import will run daily between 1:30 PM and 2:30 PM.

Troubleshooting

Problem: I cannot update my "cells to update". Tapping the grid icon to select a range does nothing.

Solution: Ensure that you're not signed into multiple Google Accounts in the same browser session. Being logged into more than one Google Account at the same time in the same browser can cause the importer to get confused.

Problem: I cannot update dates in the future.

Solution: The Google Sheets Importer supports writing data to today's date and dates in the past. It does not write data to days in the future. However, you can select a data range that includes dates in the future and schedule automatic daily imports. Those future dates will update as time passes.

Did this answer your question?
😞
😐
😁