Category: Google Sheets

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

Redux: How to open a Google Sheet at a specific row for editing

Many years ago I posted a way you could open a Google Sheet at a specific row for editing. This let you do some url wrangling where you could direct someone to open a Google Sheet in what was ‘List View’ and edit the row: Sadly List View disappeared in the Google Sheets update announced […]

Using CiviCRM with Google Script/Google Drive with the new CiviService Google Script Library

At the Association for Learning Technology (ALT) we use the open source CiviCRM for membership and events management. I’ve previously described how we are able to do Custom regular reporting from #CiviCRM with Google Sheets and Google Apps Script which is able to trigger reports from Civi which are emailed to a Gmail account before […]

TAGS Tricks: Making a searchable location map of your top Twitter contributors with Geocode by Awesome Table

In this post I’ll show you how to make a searchable Twitter contributor map like the one below in a couple of clicks, however I feel it’s my duty to educate you first…

Tips on emailing inline Google Charts from Sheets using Apps Script

There are various techniques for automatically distributing these using Apps Script and in this post I’m going to highlight one method for emailing inline charts.

Custom regular reporting from #CiviCRM with Google Sheets and Google Apps Script

At the Association for Learning Technology (ALT) one of the core tools we use for membership management is CiviCRM. In this post I show you how we use Google Apps Script to automate reporting and analysis

Batch changing Google Sheet cell background colours with Google Apps Script

At ALT we use Google Sheets as an easy way to share and collaborate on draft event timetables. Recent examples are the ALT Annual Conference 2014  and the OER15 timetables. One of the reasons for publishing draft timetables using Google Sheets is  we can get a static url for people to download it as PDFs […]

Generate a PDF (csv/xlsx/ods) download/publish to the web link for new Google Sheets

Basic little Google Sheet template for generating download links of new Google Sheets in different formats including pdf, csv and xlsx

Creating a Twitter Question/Revision Bot using Google Sheets

My old colleague at Cetis, David Sherlock, posted a nice little  ‘Twitter Question/Revision Bot’. This uses a .csv file of questions and multiple choice answers which get randomly tweeted out using a Python script. David designed the project with a Raspberry Pi in mind but also highlights it can be easily run on any Unix […]

4 Comments

Dynamically remove Google Form options after they have been selected by someone or reach defined limits

You can imagine the scenario, you’ve got a Google Form perhaps setup as a booking form and a select option for picking timeslots. As the slots fill up you’d like the option to be removed. I was surprised not to find an example of this so here is a rough sketch of some code that might do the job

One Comment
« Previous Page — Next Page »
css.php