Google Apps Script —Track videos viewed on Google Drive within your organization

SCENERIO: You are admin of a G-Suite set up. You upload training videos for your organization members on Google Drive/Team Drive. To increase productivity, you want to ensure all members watch the videos you upload.

SOLUTION: You utilize this amazing GSuite Reports API and use Google Sheets as your dashboard to view all details about your MP4 videos.

Source: Google Apps Script —Track videos viewed on Google Drive within your organization

Create a game web-app fast with Google App Maker ? Challenge accepted.

Google App Maker allow you to create responsive web-app fast in your company. What about create an internal challenge ?

In this post Jérémy Dessalines highlights the benefits of using Google App Maker to rapidly develop a web based game and all in a couple of lines of code:

The app benefits from Google App Maker to authenticate the user, create a responsive application that allows the visualization of good practices in the form of cards. … Access is secure and restricted to a small group of users via a Google Group.

Source: Create a game web-app fast with Google App Maker ? Challenge accepted.

4 Google Scripts That Make Google Sheets More Powerful

Image: makeuseof.com

Google Sheets is great out of the box, but can be even more powerful if you use Google Sheets scripts to enhance its capabilities.

Always nice to see Google Apps Script getting some publicity in the general tech news. In this post on makeuseof.com some basic Google Apps Script functionality is highlighted in particular highlighting how “productivity is the secret to productivity success”

Source: 4 Google Scripts That Make Google Sheets More Powerful

Gmail scopes automatically invalidated when a user changes the password requiring re-authentication 

I stumbled upon this particular oddity a few weeks ago when a client asked me to resolve an issue.
It turns out that if your application leverages gmail scopes, those scopes are automatically invalidated when a user changes the password on that gmail account. The client in question had changed their password which triggered an authorization prompt. Something to watch out for.
Nice highlight from Dimu Designs, the source thread is open for other ‘gotchas’.

Source: The more you know! – Google Groups

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

Stripe payment code integrated into Google Apps Script

Stripe Payment Example

Regular Google Apps Script community contributor Alan Wells has provided example Apps Script code with different examples of Stripe payment integration.

Update: Alan had published the source code to GitHub

Source: Stripe payment system – client version v3 – Apps Script integration 

Adding data from spreadsheet to custom fields in Google Contacts with Google Apps Script

At my work data of clients, opposing parties, courts, third parties and cases (among which case names) are stored in a spreadsheet. The spreadsheet is the source for contacts in Google Contacts.

For some reason names of cases are used as subject in Gmail. I use(d) Google Apps Script to add case names to Google Contacts

Nice little script example to navigate around and add data to Google Contacts.

Source: /**There must be a better way to do it but I do not yet know how*/: Adding data from spreadsheet to custom fields in Google Contacts with GAS

Improving your omnichannel customer experience – personalised problem solving (custom Exotel workflows with Google Apps Script)

With everyone talking about omnichannel communication,
@schoraria911 tells you how you create a smooth information flow between your helpdesk and phone system (@Exotel) to ensure a seamless customer experience

Always nice to see other companies promote the use of Google Apps Script with their service. In this post regular Pulse contributor Sourabh Choraria demonstrates how Apps Script can be used to configure the Exotel communications service.

Source: Improving your omnichannel customer experience – personalised problem solving – Global

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