> For the complete documentation index, see [llms.txt](https://docs.doubleloop.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.doubleloop.app/measure/google-sheets-integration.md).

# 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.