Collect
      Back to home
      1. Help Center
      2. Collect

      Connect data via a Google Sheet

      Organize your active data sets from a Google Sheet in the Collect section. Connect a Google Sheet with existing data to see it reflected in a new data table in the Collect section. 

      How to import data by connecting a Google Sheet

      A Google Sheet is a web based spreadsheet where you can store and manage your data live. When you input data to UpMetrics by connecting a Google Sheet, changes to your Google Sheet will be automatically reflected in our platform. You must have a Google Account with a Google Sheet ready with some data in it to proceed with connecting it to UpMetrics. 

      Your Google Sheet's formatting will be maintained.
      The data itself and the way your spreadsheet is organized will be reflected in the data table once you connect a Google Sheet.

      1. Open the data set where you’d like the Google Sheet’s data to be stored.
      2. Select the button in the upper right corner of the page to add a new data table.
      3. Select the option to add data via a Google Sheet from the drop down menu.
      4. Sign into the Google account where your data is stored.
      5. Once the authentication is completed, name the Google account being used for integration to continue.
      6. View the data table with your newly added data.

      How to manually sync updates to your Google Sheet in one step

      Google Sheets sync automatically every night. When you make a change to your Google Sheet, the change will automatically be reflected in UpMetrics.

      1. To manually sync data, select the refresh icon. Wait 5-10 minutes to see your data reflected in UpMetrics since a large data sync can take time.

      Edit, delete, or export your new data table in one step

      1. To edit, delete or export this data table, select the chevron to the right of the data table’s name.

      Add new columns or headers in UpMetrics

      To adjust the columns or header labels on a column in UpMetrics, you’ll need to edit your data table.

      Updating columns and headers to prevent an error

      If you try to update the header labels on a column in your Google Sheet, or add a new column from Google Sheets, you may notice an error pop up to prevent the sync from continuing. If you continue, then the formatting in your Google Sheet will override what’s saved in UpMetrics. 

      1. To add a new column with a new header in UpMetrics, select the Edit button.
      2. Check the box to the left of any header you want to see reflected in your data table.
      3. Select Continue to see the updated changes.


      🔥 Nice work! Now you’re set to connect your data from a Google Sheet.