You could more or less achieve this, by using a Google Apps Script that exposes the sheet. I found spreadapi to be good enough for basic use.

https://github.com/ziolko/spreadapi