Google Sheets

Violet Add-on

How to use the Violet Add-on to integrate your Violet hardware engineering data with Google Sheets

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

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

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

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

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

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

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

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

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

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

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