I have been working on a temporary alternative solution to enable read/write functionality from multiple users using Grasshopper.
First, I followed the instructions from this thread to create custom python components that can read and write to Google Sheets: Google sheet read with gh - Grasshopper - McNeel Forum
While these components work fine, every system that uses them requires a lengthy install, which is undesirable in my circumstances.
So, I created a GH file with the Python read write components, which receives and sends data via Speckle. This way, another user only needs to access a speckle stream in order to send or receive data from Google Sheets, rather than install the Python components. Here is a diagram to explain the logic and a screenshot of the correct data being sent/received:
The solution works, but there is an issue with how it updates. It seems as though the Grasshopper file containing the Python components needs to be open in order for it to work. I’m assuming that the GH document with the Python components can simply live on a Speckle server without being open and still enable the data transfer back and forth, is this not correct, or is there something particular about this situation that stalls the data flow?
Any help would be appreciated, and let me know if anything is unclear, thanks!