# 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**

![](https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FAp5XpDP5nYAWmW9KOCkV%2Fimage%20\(7\).png?alt=media\&token=58565f2e-e0fe-40ec-bbd8-8b74a1a0d117)

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

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2F9KDuZ247IpssaAEYvDdo%2Fimage%20(8).png?alt=media&#x26;token=b9975bad-0f95-46cc-8c44-0982961e2707" alt="" width="563"><figcaption></figcaption></figure>

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

![](https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2Fg0Z9UCkxiT9In7fYyVwT%2Fimage%20\(9\).png?alt=media\&token=2e3ded14-6e33-4197-bd26-ef55b1392c8d)

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

![](https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FBtM9pg1cyZhSWKScIYNM%2Fimage%20\(10\).png?alt=media\&token=e9f3f9a7-ae07-4d1f-b5f9-ac37e5e267a6)

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

![](https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FJ7PwYVtQW0KxnHrM3u19%2Fimage%20\(12\).png?alt=media\&token=a73da8c8-fafe-470f-8479-4563a03250b5)

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

![](https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FjPekCXhB8DBC0a02NcnN%2Fimage%20\(13\).png?alt=media\&token=12b6eeea-eb3c-4493-ad4c-f99a4cc97ac2)

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.

![](https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FmY0eUdW7aJNkrABFL1vv%2FScreenshot%202024-08-16%20at%203.37.13%E2%80%AFPM%20\(1\).png?alt=media\&token=0f343751-fa6d-4a55-a52c-4595b40c4c5b)

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

![](https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FipRnPuM4bSuOzUcM3BOh%2FScreen%20Recording%202024-08-16%20at%203.40.35%E2%80%AFPM%20\(1\).gif?alt=media\&token=e9282732-4d71-43c4-ae32-f401ccc18a73)

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.

![](https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FtDetY1rywuDEwOdm85a7%2FScreen%20Recording%202024-08-16%20at%204.02.44%E2%80%AFPM%20\(1\).gif?alt=media\&token=5907ca67-1431-4cf0-b25d-fff5caba204b)

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**.