There was a question that came up in the Google Apps Script G+ community about moving a row of data to another sheet. In this post I look at how to solve this for Google new Sheets
A question came in on the Google Apps Script Google+ Community which in part was asking about parsing .csv files into a Google Sheet. I intially pointed the asker to some dated documentation so for my penance have updated it.
Back in 2012 I shared some of the exploratory work I did issuing Mozilla Open Badges with using a combination of Google Apps Script and Google Sites. I revisit this idea with new knowledge of the Mozilla Issuer API
Recently I was trying to get full screen access in Google Drive using Google Apps Script and I couldn’t get it to work resulting in this feature request. In this post I want to share some of my thought processes and highlight why this would be a useful feature.
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
A quick example of how you can use Google Apps Script to automatically allow anyone to add YouTube videos to one of your playlists
I was recently invited to London to talk at the GDG DevFest London. As part of the ‘authenticated playground’ I highlighted 3 core features of Google Apps Script
You’ll find lots of blog posts explaining how to do this the other way, converting a table from Wikipedia into a spreadsheet. This post looks at taking a .csv or a spreadsheet and formatting it as a Wikipedia table.
Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.
The TwtrService library for Google Apps Script centrally stores your Twitter access details allowing them to accessed from multiple script projects without the need for re-authentication. This post outline usage of the library.