This was my instant thought too when I saw this question. For those that don't know, Zapier is basically IFTTT (if this then that) except focused on more business/enterprise tools and tasks. So they have a json input and a Google Sheets output. With a few clicks you can accomplish what you're looking to do.
If you're trying to prototype using the data in Google Sheets, try Atomic's new feature, Data. Will pull information directly from your Sheet and put it in the prototype you create.