File tree Expand file tree Collapse file tree 1 file changed +34
-0
lines changed
Expand file tree Collapse file tree 1 file changed +34
-0
lines changed Original file line number Diff line number Diff line change 1+ # Quarterly business review demo
2+
3+ This sample was created for a talk for Google Cloud NEXT'18 entitled "Building
4+ on the Docs Editors: APIs and Apps Script". It is the implementation of a
5+ commandline tool that:
6+
7+ * Extracts template variables out of a Google Slides template presentation
8+ * Writes those variables to a Google Sheets spreadsheet
9+ * Adds data to the spreadsheet based on those variables from a stub data service
10+ * Generates new Google Slides presentations using the template and the
11+ spreadsheet data
12+
13+ ## Getting started
14+
15+ * Follow the [ Sheets API python quickstart] ( https://developers.google.com/sheets/api/quickstart/python )
16+ * Make sure to save the client-secrets.json in your working directory
17+ * In the developer project you created, also enable the Google Slides API and
18+ the Google Drive API
19+ * Run the tool:
20+
21+ <pre >
22+ // Create the spreadsheet from the Google Slides template
23+ $ python qbr_tool.py create_sheet --template_id < ; your template id> ;
24+
25+ // Add data from the stub customer service
26+ $ python qbr_tool.py add_customers \
27+ --spreadsheet_id < ; your spreadsheet id> ; \
28+ --customer_id jupiter
29+
30+ // Generate the filled in presentation
31+ $ python qbr_tool.py create_presentations
32+ --spreadsheet_id < ; your spreadsheet id> ; \
33+ --customer_id jupiter
34+ </pre >
You can’t perform that action at this time.
0 commit comments