Connecting Google Sheets with Revit Using Dynamo for Real Time JSON Export

Revit
, , ,
1

I’m trying to connect Google Sheets with Revit using Dynamo and export the data into a JSON file for further use.

The issue I’m facing is that I can’t achieve real-time synchronization. Specifically, I want any changes made in the Google Sheet to automatically reflect in Revit and the exported JSON file, even after a day, since it contains temperature data.

2

Hi Nasir, welcome :wave:

Dynamo is not going to achieve real-time synchronisation as it is user launched either via Dynamo inside Revit or via the Dynamo Player.

You do have some options… however they are mostly outside the scope and purpose of this forum

  • Use pyRevit to run Dyanamo in the background possibly on a schedule
  • Get a commercial add-in such as from DiRoots (can connect to Google Sheets) or NonicaTab Pro
  • Use C# to write your own add-in that listens for Revit events and/ or checks at a certain interval

If you go down the DIY route you will also have to understand and implement the Google Sheets API and authorisation process

Please review How to get help on the Dynamo forums and if you have a Dynamo component of your solution feel free to ask away here

1 Like
3

Hard to say what the use case is here, but it sounds as if you’re attempting to finagle a digital twin out of this data using Revit as the backbone. I appreciate hacking a technology to do more than it should as much as the next guy, and Revit is nice for this in that it lets you do pretty much anything… however if my instinct is correct a real digital twin tool such as Tandem would be far better suited for the task.