# Google Sheets integration

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:

{% embed url="<https://www.loom.com/share/ffdfa3b97e074ce98a0a6fca983cb3bc>" %}

## Example

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

<https://docs.google.com/spreadsheets/d/16a0fuGdG_2oCr4H0mzjM1BMnBkiOkeuE-hSEOBZmt9o/edit#gid=0>

## Connecting Google Sheets to DoubleLoop

1. Go the [Metrics listing page](https://app.doubleloop.app/metrics).
2. Click the "..." in the upper right and click "Connect to Google Sheets"
3. Follow the authorization steps.
4. 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).
2. After you've updated data in your Google Sheet, you can import the data into DoubleLoop by clicking "Import latest data" on the [Metrics listing page](https://app.doubleloop.app/metrics).&#x20;

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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.doubleloop.app/measure/google-sheets-integration.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.