Bigquery Sheets Slides
| Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
|---|---|---|---|---|---|---|---|---|---|---|
| Android_data | 8,594 | 3 months ago | 6 | Java | ||||||
| Some Android learning materials, hoping to help you learn Android development. | ||||||||||
| Arcore Android Sdk | 4,713 | 22 days ago | 320 | other | C | |||||
| ARCore SDK for Android Studio | ||||||||||
| Google Authenticator | 4,262 | 3 years ago | 162 | apache-2.0 | Java | |||||
| Open source version of Google Authenticator (except the Android app) | ||||||||||
| Awesome Pwa | 4,184 | 9 days ago | 10 | |||||||
| Awesome list of progressive web apps! (PR welcomed ;)) | ||||||||||
| Apps Script Samples | 3,893 | a month ago | 36 | apache-2.0 | JavaScript | |||||
| Apps Script samples for Google Workspace products. | ||||||||||
| Apkupdater | 1,469 | 3 months ago | 48 | gpl-3.0 | Kotlin | |||||
| APKUpdater is an open source tool that simplifies the process of finding updates for your installed apps. | ||||||||||
| Google Apps Script Awesome List | 1,289 | 3 months ago | 2 | |||||||
| The usual list of links to interesting resources for Google Apps Script | ||||||||||
| Greenscreen | 1,208 |  | 2 | 6 years ago | 1 | April 04, 2015 | 46 | bsd-3-clause | CoffeeScript | |
| Kubernetes Engine Samples | 1,058 | 2 days ago | 12 | apache-2.0 | HCL | |||||
| Sample applications for Google Kubernetes Engine (GKE) | ||||||||||
| React Google Apps Script | 1,015 | 3 months ago | 1 | February 27, 2022 | 13 | mit | JavaScript | |||
| This is your boilerplate project for developing React apps inside Google Sheets, Docs, Forms and Slides projects. It's perfect for personal projects and for publishing complex add-ons in the Google Workspace Marketplace. | ||||||||||
Code that Final Mile: Big Data Analysis to Slide Presentation
This intermediate Google Apps Script codelab shows you how to build a sample app that demonstrates use of the Google BigQuery API to query a public data set and create a Google Slides presentation with the results data. A Google Sheet is used as an intermediary to store the analysis data as well as its ability to create charts on its data.
Pre-requisites
- Access to the internet and a web browser
- A Google account (G Suite accounts may require administrator approval)
- Basic JavaScript skills
Description
BigQuery first performs a query on one of its public data sets; in this case, a query that determines the top 10 most common words in Shakespeare's works. BigQuery has a collection of public data sets, so you're free to issue other queries against this or any other data table you desire in doing this exercise. The app stores the query results from BigQuery into a newly-created Google Sheet. The Sheets API is then used to create a chart based on the results data. Finally, a new Google Slides presentation is created. A new slide is added whereby the the Sheet's cell data is imported. A second new slide is added embedding (and linking to) the chart from the Sheet.
This repo supports the developer codelab found at https://g.co/codelabs/bigquery-sheets-slides).
Follow its step-by-step instructions and refer to the corresponding repo folder as necessary to
see where your app should be at the end of each (major) step. The final subdirectory contains
the completed, fully-working sample. When you run it, you should get a slide presentation that looks like this:
The manifest file (see below) stays constant throughout the codelab and thus is stationed at the top-level of this repo. There are 2 key files for this entire sample (while the rest are intermediary):
-
appsscript.json: Apps Script application manifest -
final/bq-sheets-slides.js: application code
This application was also featured in a Google Cloud NEXT 2018 breakout session (although the demo was borked due to a permission problem): G Suite + GCP: Building Serverless Applications with All of Google Cloud. Here is the video for that talk.
