what happens if you hit F5 on your browser too?
Here are some further tests. I did the whole process again with my standard personal Gmail account. Actually one thing I noticed that is different when doing the OAuth Setup in Google Console between a GSuite and normal Google Account:
With GSuite you can have it set to “internal”, meaning the OAuth screen is not publicly reachable. With a normal Google Account you either have to have it public (which means getting it verified by Google) or setting it to “Test” and having to manually add test users’ email addresses.
Either way, the behaviour here is the same. It is caching solutions based on the range I enter. You can see in the video it is even still showing previous solutions from a video I just recorded before. At the very end when I change the range to …C101 does it load the current state. Writing works fine and instantaneously.
Could it be that it is region-specific? I am in Zurich, Switzerland and we actually have a huge Google Campus not 5km from here. I know they are always testing new things here like Google Maps features and many others we get before most other regions.
So weird and still no solution… 
have you tried a different browser? Or maybe flushing all browser cache/cookies etc.?
So I spoke with someone who has used the API before and all things point towards the need for the flush() function in the code. Its purpose seems to be exactly for preventing caching to take place.
Unfortunately I know very little about Python and so don’t know how or where to exactly integrate that function.
Anyone?
I’m afraid that’s not the same API (as far as I can tell at least). The one I’ve implemented is this one:
Hm, man, why is this so difficult.
You know what I would love: if someone would actually just make a http GET and POST component and we could just talk to APIs that way.
There is actually a really easy tool to turn your Google Sheet into an API: sheetdb.io
I tried adding the urllib3 to Python, but without much luck. It’s all you would need to do simple HTTP requests in Grasshopper. Anybody know how to do it? Python - HTTP Requests - Tutorialspoint
Yeah it’s definitely not always straightforward, too many APIs and potential points of breakage. I think I’d follow the advice presented here and post your issue on Stack Overflow, maybe some more in-the-know eyes can provide better insight than we’ve been able to:
I have the same problem!
After uninstalling Rhino 7 - it’s working again in Rhino 6 
It looks like it might be the well known issue of having several Newtonsoft.Json.dll assemblies on the same system (i.e. of different versions). It’s odd that this would cause an issue in this case though, since we are explicitly referencing the .dll in the dependenciesPath folder.
You might consider trying out Speckle:
Yeah, that is strange. Weird that it wouldn’t be a problem in Rhino6, but is in Rhino7.
Speckle looks cool, but is not quite what I am looking for. I would love an actual plugin for GH that can talk to an API (like Google Docs, Shapediver, etc) and not so much another software tool. It seems Speckle has itself only tools for Python and other programming languages. But that’s the issue: I am not a python or C# programmer
I mean, that’s pretty much what GHPython and the other scripting components are. It probably would be difficult to develop a generic and node-based plugin that could “talk to an API”. Not just because API’s typically target one (or more) of the popular textual programming languages, but also because they develop so fast. And often become brittle and deprecated fast, such as the old Google Sheets API, where the compiled GH plugins the wrapped that became obsolete over night 
But you could be, and it sounds like it might solve a lot 
Yes, I know, I should probably learn some Python, but I don’t have much time for that. Working with GH is only part of my job and I am also still learning so many other things (Blender, V-Ray), then other automation tools like Integromat. Meanwhile programming some stuff in Wordpress and Javascript. Then I actually do other visual programming languages, where I work a lot in vvvv and VL. And that’s all just one of my 2 jobs which I do 2 days a week. 3 days a week I am actually a UX designer and advice companies on improving their online services and make them more user-friendly.
Basically I need a few more hours in the day 
I think for a start I should understand how to load libraries into the GH python environment, because of any code snippets you find always import these other libraries.
Of course I am aware it would be very difficult for exactly the reasons you mention, but I am saying that it would be great if it existed. I mean Shapediver is already going that way of having an API and so on, but yeah that is going to take a long time before it does all that it could. Rhino compute is also interesting, but again, still so many things to get into first to set it up.
You can try Bookworm (available through package manager). It’s still work-in-progress but it does work with Rhino7.
Any suggestions and PR are very welcome.
bookworm repo
There seems to be something with NewtonsoftJson library conflicts but I’m not sure. I had a similar issue some time ago when two plugins couldn’t coexist because there were two different newtonsoftJson.dll versions. I don’t know if this is the case but you can try to temporarily move all other plugins out of the Grasshopper Library folder and try launch bookworm again. If there’s no problem then it have to be some other plugin conflicting with Google Api libraries.
Indeed, good to verify this. That’s what I was suggesting earlier:
@seltzdesign you can try to install Everything and search your system for stray Newtonsoft.Json.dll files. There’s probably a whole bunch of these floating around your system (so/too many softwares depend on/issue this!).