Use the Spreadsheet Document API to create and modify pivot tables in code. - View it on GitHub