Add pivot-table to a google spreadsheet, via the API

I'开发者_开发技巧d like to automatically create one of these pivot tables:

https://drive.googleblog.com/2011/05/summarize-your-data-with-pivot-tables.html

Given some data and parameters, the script would create a new google spreadsheet, complete with pivot-table and chart, non-interactively.

Is this possible?

It appears that there is a partial answer. I haven't tried it yet, and I wouldn't swear by it till I do. If anyone does try this technique, post here.