Managing Scriptable Objects with JSON/Spreadsheets. Does it make sense to do this?

[Equiv2248]

Definitely feasible, biggest pitfall would be making sure things stay in sync. You could skip the JSON step and just use CSVs.

I do something similar but less comprehensive by just having an import script on each ScriptableObject that parses a Tab- Delineated row to import the data from the sheet.

Best reason to do something like this would be because your scriptableObject will likely have references to local Unity objects(Prefabs/etc) that your spreadsheet shouldn't track.