Extract Bills of Materials (BOM) part lists and update metadata from connected Onshape Assemblies.
Works with:
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

* Added export to CSV in addition to JSON
Additional information
PricingNot available
Trader status unspecified
Privacy policy
Terms of service
Onshape BOM will ask for the permissions shown below. Learn more
Onshape BOM will need access to your Google account
This will allow Onshape BOM to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu