Skip to content

Commit e4e0968

Browse files
committed
add readme
1 parent 862a5e3 commit e4e0968

File tree

1 file changed

+34
-0
lines changed

1 file changed

+34
-0
lines changed

events/next18/README.md

Lines changed: 34 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,34 @@
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 &lt;your template id&gt;
24+
25+
// Add data from the stub customer service
26+
$ python qbr_tool.py add_customers \
27+
--spreadsheet_id &lt;your spreadsheet id&gt; \
28+
--customer_id jupiter
29+
30+
// Generate the filled in presentation
31+
$ python qbr_tool.py create_presentations
32+
--spreadsheet_id &lt;your spreadsheet id&gt; \
33+
--customer_id jupiter
34+
</pre>

0 commit comments

Comments
 (0)