Google Sheets Cell values for Variable

brendon_prentice

Hi Team,

I am brand new to onshape and testing out the functionality.

Can I get variables from a google sheet?

A simple example would be cells with the values 200 and 400
These cells are some how referenced in onshape to create a rectangular sketch that is 400x200.

I have searched the forum and there are a few mentions of this feature in demand from many years ago.
I have the variables set in my model and I have linked the google sheet into my model via the Link Tab
I just can't get onshape to suck the values out of the sheet and apply them to the model.

Thanks in advance

Matt_Shields

Not natively.  You could paste in values from a Google Sheet.  Or write a python script to read the sheet and update your document via the API.

Matt_Shields

I'm by no means an expert, but I got a little test working.  I started here:

https://developers.google.com/sheets/api/quickstart/python

I followed that exactly.  Once I had my Python code reading my Google Sheet, then I just updated a Variable Studio using Python requests to the Onshape API.



By the way, after I was done, I also found this:
https://github.com/PTC-Education/PTC-API-Playground/blob/main/Configuration_Variables_and_Google_Sheets.ipynb

Matt_Shields

Not natively.  You could paste in values from a Google Sheet.  Or write a python script to read the sheet and update your document via the API.

brendon_prentice

I am searching for a good google sheets API - Or write a python script to read the sheet and update your document via the API.  I did a quick search of hte forums Communicating a Google Sheet with the Onshape API — Onshape

Does the python sheet get written in Onshape or google, Is there any great help resources for this or potentially someone that may be able to help in this regard.

Matt_Shields

I'm by no means an expert, but I got a little test working.  I started here:

https://developers.google.com/sheets/api/quickstart/python

I followed that exactly.  Once I had my Python code reading my Google Sheet, then I just updated a Variable Studio using Python requests to the Onshape API.



By the way, after I was done, I also found this:
https://github.com/PTC-Education/PTC-API-Playground/blob/main/Configuration_Variables_and_Google_Sheets.ipynb

brendon_prentice

That looks brilliant and exactly what I am after, I am looking forward to giving this some love. You look like an expert to me!!