Extract Bills of Materials (BOM) part lists and update metadata from connected Onshape Assemblies.
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
* Item number
* Part Number
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:
* Part number
For workspaces only:
For versions only:
Currently this add-on extracts a "Parts-only" BOM. Connecting Google Sheets to Onshape's full cloud CAD centralizes your Bills of Material management.
* Get preview of any BOM line item
* Added support for export of BOM data into tabs for rel-1.59 Drawings insert BOM
* Added support to export any spreadsheet selection into an Onshape document for import into a Drawing using insert BOM.