Category: Google Apps Script

Embedding almost anything like a Twitter Search widget in new Google Sites with Google Apps Script

If you have some content you’d like to embed into a new Google Site that isn’t accepted by the ‘Embed URL’ feature in Sites you can try following these steps

15 Comments

A Google Calendar Widget for Google Sites created with Google Apps Script

As Google also recently announced that Google Apps Script Web Apps can be embedded in new Google Sites and given the majority of Chrome Extensions are just a wrapper for HTML/JS/CSS I thought I’d have a look at porting Google’s Calendar Chrome Extension code to Google Apps Script

Changing the color of all links in Google Slides with Google Apps Script

My goto theme in Google Slides is Material and for the Totally Unscripted show use the ‘one column text’ layout for highlight news/community updates. One annoyance with this theme is the text hyperlink color defaults to light blue (HEX: #4FC3F7), which isn’t so great in the sidebar column: You can override the link color in […]

Getting YouTube Analytics with Google Apps Script when you get authentication loops

In my previous post I provided a tutorial on using the YouTube Data API with Google Apps Script for situations where you were using branded channels (channels not directly owned by a Google account). In this post I’m going to revisit this topic looking at the YouTube Analytics API.

Identity crisis: Using the YouTube Data API with Google Apps Script and Scheduling Live Broadcasts from Google Sheets

Details of how you can use a custom YouTube Data API library to interact with any YouTube account even if it’s owned by a Google+ page

My Google Apps Script app isn’t verified: Understanding why and how to fix

On July 18, 2017 Google announced new security protections to reduce risk from unverified apps. This announcement came in response to continued work to prevent phishing attacks that have used Google Apps Script. As part of this newly created Apps Script projects in certain circumstances will present the user a “app isn’t verified” screen. The […]

Sidebar Video Chat: A WebRTC video experiment in Google Apps Script as an add-on for Google Docs, Sheets and Forms

tl;dr my failed attempt to get production level video web chat into Google Doc, Sheets, Forms sidebar as an Add-on (possible with WebRTC but not without setup/running costs) Back in 2010 I predicted we’d see a lot more real-time web applications in education highlighting a number of web services that had strong real-time collaborative features. […]

4 Comments

Cloud Functions for Firebase in Google Apps Script

This tutorial was developed by Riël Notermans and Martin Hawksey GDEs for Google Apps Script. This tutorial is based on a supporting video featuring Riël going through and explaining each of these steps. Google Apps Script is a powerful tool to integrate with Google products and third party services. As Apps Script is a free […]

Using the Google Apps Script Execution API in Chrome Extensions

Recently I was asked to contribute to a Chrome Extension. As part of this project we wanted to send data from the extension into a Google Sheet. There are a number of ways you could do this including just using the Google Sheets API but the way I decided to go was to use Google […]

Tips for debugging Google Form ‘onSubmit’ functions in Google Apps Script

A question came up recently in the Google Apps Script G+ community about accessing submitted Google Form values. It can be tricky to do this sometimes as the Google Apps Script debugger can’t be triggered on the onFormSubmit event. The form submit event object also returns the data in different ways. My approach to this […]

« Previous Page — Next Page »
css.php