Having used the Spreadsheets API, I can say it's definitely bad, mainly because of its slowness and the small amount of data any query can return. We needed 45

Having used the Spreadsheets API, I can say it's definitely bad, mainly because of its slowness and the small amount of data any query can return. We needed 45 seconds to modify two fields in any given document.