Use Google Apps Script, Google Slides and Google Sheets to quickly automate creating a Certificate of Attendance and send it to attendees.
Nice example using Google Apps Script to generate and share .pdf documents via email. The source has all the code you need to get going on this.
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
This is a sample script for decoding a QR code put in Google Slides using Google Apps Script. In this case, Javascript is used at the opened dialog. And Canvas API and jsQR are used.
This is a nice example of how you can easily drop in existing JavaScript libraries into your Apps Script project by using a HTML dialog. The post also has some nice tricks for handing image data, in particular, from getDataFromQRCode() the image data is passed into the HtmlService:
const html = HtmlService.createTemplateFromFile("index");
html.image = JSON.stringify(blob.getBytes()); // adding image data
SlidesApp.getUi().showModalDialog(html.evaluate(), "sample");
This is added in client side with a printing scriptlet:
image.src = `data:image/png;base64,${btoa(String.fromCharCode(...new Uint8Array(Int8Array.of(...JSON.parse(<?= image ?>)).buffer)))}`;
Another way you could achieve this is base64 encoding the image server side with Utilities.base64Encode().
Source: Retrieving Data from QR code on Google Slides using Google Apps Script · tanaike
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
This is a sample script for cropping images in the Google Slides using Google Apps Script.
Useful snippet from Tanaike which shows how you can crop images in Google Slides by using the replace(blobSource, crop) method. The post also highlights a limitation with the image manipulation methods available around crop centering.
Source: Cropping Images in Google Slides using Google Apps Script · tanaike
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
With Creator Studio, you can easily convert your Google Slides presentation into animated GIFs and video slideshows. The add-on can also extract speaker notes from your slides and export them as a text file in Google Drive. Internally, the app uses Google Apps Script to export Speaker Notes from your Google presentation and writes them to a text file inside Google Drive.
In this post Amit Agarwal share some very clean code for iterating across each slide in Google Slides and export the speaker notes into a single file. Click through to the post for the source code.
Source: How to Download Speaker Notes in Google Slides – Digital Inspiration
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
A post dedicated to devs and highlighting the power of the Slides API.
Use Google Apps Script and the Google Slides API to create a card game like Dobble.
Source: Google Slides API — a deep dive on its powerful image manipulation methods
Upload a few images to Google Drive, press a trigger to start a little Apps Script code and get your own Dobble game on Google Slides.
This tutorial will guide you into creating your own Dobble card deck with Google Slides, which you can easily print for use in your day to day life.
Source: Make your own Dobble / Spot It game with Google Slides and Apps Script
AutoSlides is a Google presentation template powered by Apps Script code design to be used in unattended information points, although it can also be used as an informational element, linked or embedded, on any website.
Google presentations have a publishing feature that facilitates their dissemination. In this way they can be linked or embedded in web media with ease. However, if the presentation slides are modified it is necessary to reload the page that contains its versions published in the browser so that these changes are manifested. AutoSlides is capable of generating a self-hosted slide show, visible using a browser, that automatically refreshes at predetermined intervals without reloading the web page manually in the browser.
Source: pfelipm/autoslides
A Google Apps Script and Google Cloud Platform tutorial to learn how to use GCP Service Accounts to scale and protect automations
Examples of Google Apps Script being used in an enterprise setting tend to be few and far between which means this tutorial by Jeffrey Daube is an interesting insight to how script projects can be setup to serve the entire company. In particular, Jeffrey details how the use of service accounts can be used so that G Suite documents can be created with a non-human user allowing you to make calls to Google APIs without the usual authentication flow.
Source: How to use GCP service accounts with Google Apps Script projects to automate actions in G Suite
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
In my previous post, I outlined the power of Google document URLs to perform “Simple, Powerful, Work” and promised to share several tools I’ve developed to aid in building them.
Source: TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥
Earlier in the year I managed to get a bulk emailing script published in the G Suite Developer Solutions Gallery. In this post I want to show you how you can extend this script so that you can send personalised images using Gmail, Sheets and Slides.
Source: Send bullk emails with personalised images in G Suite using Google Apps Script
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
Stop copying and pasting data from Google Sheets. Have it automatically injected into a Google Slides presentation with this Apps Script.
Nice introduction post which covers the basics of Google Apps Script development using a project to populate Google Slides from Sheets as an example
Source: How to Inject Data from Google Sheets Into a Google Slides Presentation | UpBuild
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
I always enjoy presenting at DevFest as usually it is a reason to explore something new. In the case of DevFest London it was an opportunity to think about how voice interfaces could be used as part of a Google Slide presentation. In this post I’ll share some of the ideas I explored and how they did/didn’t work out.
In practice not all these experiments worked out but hopefully the post contains some useful snippets for navigating Google Slides in the editor, exporting slides as images and extracting text from the speaker notes.
Source: Hacking Google Slides as a voice enabled presentation tool using Google Apps Script – MASHe
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
Image credit: Figma
In this sample script, all pages in the Figma file are retrieved and the retrieved pages are put to new Google Slides as the image.
This post is useful for not only showing how to insert images into Google Slides, but also for featuring Figma which might be a useful tool for G Suite Add-on developers looking for an easy way to prototype/design application interfaces.
Source: Figma to Google Slides using Google Apps Script · tanaike
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
I wanted to update one of my free Google Add-on apps that works with colour. What I had is just the standard HTML color input element where the user selects from the palette and that hexadecimal colour code … had always wanted to create a tool for a sidebar or dialogue box that would allow the user to easily access the standard colours or use the custom palette provided by the HTML color input”
Continue reading this post to find out how you can implement your own copy of the colour picker
Member of Google Developers Experts Program for G Suite (Google Apps Script) and interested in supporting #GSuiteDevs
