Sheeter - Google Sheets Connection for Fusion 360

prainsberry
Autodesk

Sheeter - Google Sheets Connection for Fusion 360

prainsberry
Autodesk
Autodesk

I wanted to post this here i case anyone is interested in checking it out.  Something I have been working on for awhile and decided to put it out there to see what people think.  

 

This allows you to connect a Google Sheet (spreadsheet) document to a Fusion 360 design.  Then you can define multiple sizes.  Once you have defined the sizes you can switch sizes back in Fusion, or generate new Fusion models, export neutral files, or post process g-code for each size.

 

It is really just a bit of a hobby project for me so I make no guarantees, but in the tests I have done it has been pretty reliable.  

 

Let me know what you think. 

https://github.com/tapnair/FusionSheeter

 



Patrick Rainsberry
Developer Advocate, Fusion 360
8 Likes
Reply
Accepted solutions (1)
11,907 Views
63 Replies
Replies (63)

nakwadroid
Explorer
Explorer

Hello @Anonymous 

I also installed the add-in, I can push data but cannot pull it into my design. The drop down menu remains empty.

My Fusion 360 is up to date, I restarted it and my system. Still stuck. Any idea?

0 Likes

Anonymous
Not applicable
Hi!

I'm assuming you followed the instructions in:
https://tapnair.github.io/installation.html

Make sure that you have eliminated the folder called master (which is
inside the Add In folder), that seemed to have worked for me too besides
restarting Fusion. As for the drop down menu remaining empty I am clueless
about that... I did this youtube video a couple of days ago as a tutorial
for my students: https://youtu.be/AspomnkFev4?t=2791 can you at least get
it to do what I do here?
0 Likes

prainsberry
Autodesk
Autodesk

I need to do something about this, but my guess is that you haven't filled out the description field on the parameters tab in the Google Sheet.  I used to use the part number field, but then so many people asked for description that I changed it.   The problem is that if you have blank values in the description field the drop down will not get populated because of an over sight in the way I implemented it.   I might try to update it this weekend.  Until then try to add some values to the description field and see if that solves it. 



Patrick Rainsberry
Developer Advocate, Fusion 360
1 Like

nakwadroid
Explorer
Explorer

@Anonymous & @prainsberry  filling the description fields solved my issue, thank you very much!

I have been pulling my hair for weeks trying to find a way to achieve exactly what Sheeter does.
Thanks so much for this add-in. And I will keep an eye open for future updates.

0 Likes

mwaelchli
Explorer
Explorer

Hi All, im using Sheeter since last year and im very happy with it 🙂

today i downloaded the latest version and put it in to the script folder now i have the issue that the connection not work. One problem is that i recieved the message that the token is expired and the other is that i cant open the sheet in Fusion.

Thanks for your help.

0 Likes

prainsberry
Autodesk
Autodesk

Have you downloaded the latest from here:

https://n3rdlab.com/downloads/sheeter/

 

Also there is a hidden folder in **USER_HOME**/Sheeter/ called .credentials try deleting that folder.

 

 



Patrick Rainsberry
Developer Advocate, Fusion 360
0 Likes

mwaelchli
Explorer
Explorer

Thank you, it works with the credentials folder.

The only problem that i have now, is that i can't open the sheet directly from fusion 360.

 

It shows every time the message:

Couldn't not sign in

This browser or app are not be secure

0 Likes

prainsberry
Autodesk
Autodesk

Are you talking about loading the page in the Fusion frame, like in the attached image?  I'm not sure why this might be happening.  I just checked and Google prompts me to login and then it works.  Are you able to open the spread sheet in a separate browser window?

 

Is there anything specific about your environment?  Using a proxy or anything?

prainsberry_0-1613069218697.png

 

 



Patrick Rainsberry
Developer Advocate, Fusion 360
0 Likes

brianX6PNY
Explorer
Explorer

Sheeter recently starting giving me an error message when trying to link new models to new google sheets. Any ideas? See picture...

brianX6PNY_0-1625753871395.png

 

0 Likes

prainsberry
Autodesk
Autodesk

Hey its hard to say exactly, but looks like an issue with authentication.  One thing to try is to delete this file.

It is in your user directory /Sheeter/.credentials

It may be a hidden directory so make sure you are showing hidden folders.

prainsberry_0-1625867405403.png

 



Patrick Rainsberry
Developer Advocate, Fusion 360
1 Like

Anonymous
Not applicable

command executed failed: Traceback (most recent call last):

File "C:/Users/nirmi/AppData/Roaming/Autodesk/Autodesk Fusion 360/API/AddIns/Sheeter\SheeterCommands\Fusion360Utilities\Fusion360CommandBase.py", line 414, in notify

self.cmd_object_.on_execute(command_, command_inputs, args, input_values)

File "/Users/tapnair/Dropbox/n3rdlab/Fusion-Apps-Dev/Sheeter/Sheeter/SheeterCommands/SheeterCommand.py", line 866, in on_execute

File "/Users/tapnair/Dropbox/n3rdlab/Fusion-Apps-Dev/Sheeter/Sheeter/SheeterCommands/SheetsService.py", line 153, in sheets_get_ranges

File "/Users/tapnair/Dropbox/n3rdlab/Fusion-Apps-Dev/Sheeter/Sheeter/SheeterCommands/SheetsService.py", line 80, in get_sheets_service

File "C:/Users/nirmi/AppData/Roaming/Autodesk/Autodesk Fusion 360/API/AddIns/Sheeter\SheeterCommands\lib\google\oauth2\credentials.py", line 183, in refresh

self._scopes,

File "C:/Users/nirmi/AppData/Roaming/Autodesk/Autodesk Fusion 360/API/AddIns/Sheeter\SheeterCommands\lib\google\oauth2\_client.py", line 248, in refresh_grant

response_data = _token_endpoint_request(request, token_uri, body)

File "C:/Users/nirmi/AppData/Roaming/Autodesk/Autodesk Fusion 360/API/AddIns/Sheeter\SheeterCommands\lib\google\oauth2\_client.py", line 124, in _token_endpoint_request

_handle_error_response(response_body)

File "C:/Users/nirmi/AppData/Roaming/Autodesk/Autodesk Fusion 360/API/AddIns/Sheeter\SheeterCommands\lib\google\oauth2\_client.py", line 60, in _handle_error_response

raise exceptions.RefreshError(error_details, response_body)

google.auth.exceptions.RefreshError: ('invalid_grant: Token has been expired or revoked.', '{\n "error": "invalid_grant",\n "error_description": "Token has been expired or revoked."\n}')

 

 

I'm facing this issue with Fusion Sheeter.

 

Please help!!

0 Likes

Anonymous
Not applicable

it works !

Thank you!

0 Likes

managementSJGDP
Observer
Observer

Hello @prainsberry . Using Sheeter for the first time. Seems like sheeter can push data to Google Drive ok, but whenever I try to pull data into my Fusion project using the "sync" I get the error in the attached screenshot. Something about an invalid expression (I don't know python). Sheeter seems to pull the "Description" field into Fusion despite the error. I know this because I see it adding new "sizes" after I add a row in Google, sync, and receive the error pop-up. This error occurs even when I don't modify the sheet at all. I simply push the data, then try to pull the same data back, and the error occurs.

 

I'm on Mac OS Catalina. Running Sheets in Chrome. Disabled my VPN. This plugin sounds incredible, so I'm hoping you can help me sort this out

0 Likes

managementSJGDP
Observer
Observer
Ok so I changed parameters one by one, resyncing Sheeter after each. Sheeter updated about the first 5 parameters until it ran into a "No Unit" parameter. Fusion.py returning "invalid expression" as seen in the screenshot sounds a lot like the Fusion error when your parameter expression uses the incorrect units. So I think this is the problem area. Does Sheeter automatically apply units to the values it's pulling in from Google? Or is there no logic to handle unitless parameters?

These are calculated constants that I can let Google handle, so I'm going to try that next. Also going to nullify my units from Google's end with a 1/in multiplier.
0 Likes

managementSJGDP
Observer
Observer

Ok that was the root issue. Interestingly though, when the sync finally worked, I had one other "No Unit" parameter functioning in the design that sheeter had no trouble with. The difference being that the "No Unit" parameter that disrupted the Sheeter sync was being used directly in a sketch dimension formula to set a dimension length in inches, i.e. "x*1.41 in" where x has a value pulled directly through sheeter. The other one that worked fine was only used inside a formula "expression" that calculated the value of some other parameter, before that resulting parameter was ever used directly in a sketch.

So all in all, it's a units thing. Ironically some of the appeal of this plugin was to avoid unit errors from Fusion by delegating complex formulas to Google lol.

@prainsberrymy stuff is working now, but could you provide some additional clarity on how Sheeter handles units when it's doing its hand-offs with Fusion? Might help us all avoid other sneaky errors in the future

0 Likes

Rafa_Navarro
Participant
Participant

Hi Patrick.

 

I've been using your outstanding addin to carry on some activities with my students. It's great to develop their skills in CAD, CAM, and even spreadsheets, in one unique software as a whole.

 

Suddenly, last week we were noticed, it wouldn't work any longer with the next update, which has been set today, resulting in a total failure of your addin.

 

Are you planning to deliver a new version for Sheeter compatible with the update of Fusion 360?

 

Thanks in advance!

0 Likes

n3rDlab
Participant
Participant

Hello,

Yes I am going to get a new version published today.  I had a handful of enhancements I'd been wanting to finalize and got pretty much everything working last night.  I just need to do a little more testing and should have it posted today.  

 

Thanks for the feedback, I apologize I intended to have this done before the update.  

0 Likes

Rafa_Navarro
Participant
Participant

Hi again,

 

Thanks a lot for your work, you can't imagine how useful it is for us.

 

I've seen you have updated the information at the download site, even the download link appears as Sheeter v.3.0.0, but when I hit the link, the file I get is the older version yet.

0 Likes

n3rDlab
Participant
Participant

Ahh thanks for the heads up.  Still not very good with all that word press stuff.  I think it is working now.  Let me know if not. 

Note - all of that is to make the Google happy... 

It should be updated now.

I've also made some nice enhancements, let me know what you think.

I will say I incorporated a bunch of changes and didn't have a ton of time to test.  If there are issues please let me know and I'll try to fix asap.  

 

 

0 Likes

Rafa_Navarro
Participant
Participant

Google things...🙄

 

The file linked this time is the updated one, but when I try the addin I get this Issue. The drop down menu doesn't list the sizes.

 

Rafa_Navarro_0-1648619732223.png

 

0 Likes