Onshape BOM for Google Sheets Add-on connects to your Onshape account and extracts bills of material (BOMs) from your assemblies. Once extracted, all important metadata from the assembly is populated into the Google Sheet including:

* Created by 
* Created date (UTC)
* Modified by
* Modified date (UTC)
* BOM creation date

BOM columns:

* Item number
* Quantity
* Name
* Description
* Part Number
* Revision
* State

Modification of the BOM values in Google Sheets can also be updated and synchronized back to the Onshape part and assembly metadata fields for the following:

For workspaces and versions:
* Description
* Part number
* Revision

For workspaces only:
* Name

For versions only:
* State

Currently this add-on extracts a "Parts-only" BOM.  Connecting Google Sheets to Onshape's full cloud CAD centralizes your Bills of Material management.

Other options:
* Get preview of any BOM line item
* Added support for export of BOM data into tabs for rel-1.59 Drawings insert BOM

NEW: 
* Added export to CSV in addition to JSON