Google Sheets

Google Sheets is a free, web-based spreadsheet application that allows users to create, edit, and format spreadsheets while collaborating with others in real-time.

Learn more at https://workspace.google.com/products/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

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.