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

Revit
, , ,
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