LogoLogo
DoubleLoop homepagePrivacy policyContact support
  • General
    • Quickstart to Impact-Oriented Strategy
    • Roles
    • Build your First Proof-of-Concept
  • Map building
    • Map objects
  • Metrics
    • How to add metric data
    • Metric types
    • Control the stats on your strategy map
      • Weighted averages
    • Google Sheets integration
    • Amazon Redshift integration
    • BigQuery integration
    • CSV file upload
    • Google Analytics integration
    • Looker Action Hub integration
    • Looker API integration
    • Amplitude integration
    • Mixpanel integration
    • MySQL
    • PostgreSQL
    • Snowflake integration
    • Dedicated outbound IPs
    • Data segmentation
    • Bulk Importing Bookmarklet
  • Work
    • Jira app
    • Event fields
    • Asana integration
  • Share
    • Access settings for maps
    • Automated Slack reports
  • AI assistants
    • Company Map Generator (AI assistant)
  • Other
    • Privacy Policy
    • Terms of Use
    • Contact support
    • Security
Powered by GitBook
On this page
  • Video overview
  • Example
  • Connecting Google Sheets to DoubleLoop
  • Importing data from Google Sheets into DoubleLoop

Was this helpful?

  1. Metrics

Google Sheets integration

Learn how to use Google Sheets to populate you maps with data

PreviousWeighted averagesNextAmazon Redshift integration

Last updated 1 year ago

Was this helpful?

Our Google Sheets integration is a good way to quickly populate your stategy maps with data, without deeper data integrations. Even if you're planning to ultimately connect DoubleLoop directly to your metric sources for automation, the Google Sheets integration can be a great way to make a proof-of-concept of a data-connected maps.

Video overview

This video provides a high-level overview of how the Google Sheets integration works:

Example

Here's an example of a Google Sheet populated with data that you can import into DoubleLoop:

Connecting Google Sheets to DoubleLoop

  1. Click the "..." in the upper right and click "Connect to Google Sheets"

  2. Follow the authorization steps.

  3. Click the "..." and click "Open Linked Data sheets"

Importing data from Google Sheets into DoubleLoop

  1. The top of your linked Google Sheet has detailed instructions for how to use the integration (see example above).

Notes:

  • You can use the Google Sheet integration to update existing metrics in DoubleLoop or add new metrics. See the instructions at the top of the linked Google Sheet. To add a metric to the map that you added via Google Sheets, after clicking the "Metric" option on a map, you can search to find that metric.

  • The Google Sheets integration is not a bi-directional sync. If you make changes in DoubleLoop and would like the Google Sheet to reflect that, you can unlink your linked Google Sheet and re-connect. This will export the latest data to a linked Google Sheet.

Go the .

After you've updated data in your Google Sheet, you can import the data into DoubleLoop by clicking "Import latest data" on the .

https://docs.google.com/spreadsheets/d/16a0fuGdG_2oCr4H0mzjM1BMnBkiOkeuE-hSEOBZmt9o/edit#gid=0
Metrics listing page
Metrics listing page