AppsScriptPulse

TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥

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 💥

Send bullk emails with personalised images in G Suite using Google Apps Script

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

How to Inject Data from Google Sheets Into a Google Slides Presentation | UpBuild

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

Hacking Google Slides as a voice enabled presentation tool using Google Apps Script – MASHe

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

Figma to Google Slides using Google Apps Script

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

Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides – Yagisanatode

 

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

Source: Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides – Yagisanatode

Subscribe to Apps Script Pulse...