# Google Sheets

### Use the Google Sheets Add-on to sync engineering data from Violet to Sheets

1. Within a Google Sheet, enable the Violet add-on by going to **Extensions > Add-ons > Get add-ons**

<img src="/files/YMJYZYv9tvwv9MV1NVMm" alt="" width="563">

2. At the top of the add-ons modal, enter “Violet” and hit “Enter”.

<figure><img src="/files/tTdeCRcmIss3enO4Dqi7" alt="" width="563"><figcaption></figcaption></figure>

3. Select the Violet extension and click the “Install” button.

<img src="/files/k9fkw8C8MXZGNwBi82bX" alt="" width="563">

4. Authorize with Google to allow the Violet add-on to access the sheet.

<img src="/files/yqdXBtcyUxxtIqBijXkJ" alt="" width="563">

5. Once authorizing the add-on and attached script, the Violet add-on will be ready to use.

<img src="/files/VoRpAuhmXkEqb1L7NmAw" alt="" width="375">

6. The `VIOLET` function should now be available within the current sheet.

<img src="/files/m715HRzu7oJ6raPXgY8A" alt="" width="563">

7. To use the function to reference your data in Violet, use the function like this: `=VIOLET("<Violet ID>.<property>")`, where VL-XXXX is the Violet ID of the Violet entity you’re referencing.

<img src="/files/lYe9JgN2QEDBobFNJrLE" alt="" width="563">

So, for example, to reference the entity in the image above, we can use `=VIOLET("V-DUR-25.mass")`.

![](/files/aLq30HoTNDDO1Y0etYxO)

8. Now, create a Google Sheets integration in Violet with the Sheet(s) you want to import with the Violet add-on enabled. Once the Sheet(s) imports into Violet, any references using the `VIOLET` function within the Sheet will be updated to the referenced property value. Anytime the Sheet is fetched within Violet, this reference will be re-evaluated and updated with the current value in Violet.

<img src="/files/jTbJhJ42woLCfilflJgP" alt="" width="375">

You can also perform this step first, before the above steps, as the Sheet will be processed anytime it is fetched in Violet.

9. With the extension now installed, to import the VIOLET function into other sheets, simply go to **Extensions > Violet > Use in this spreadsheet**.


---

# 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.violetlabs.com/apps/g/google-sheets.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.