All Posts Tagged "Google Sheets"

Working with Pivot Tables in Google Sheets using Google Apps Script

by

Pivot tables are a quick and powerful way to analyse data. Using Google Apps Script, there is an ability to build and modify pivot tables in Google Sheets. In this post I’ll share some tips and tricks for interacting with pivot tables in Google Sheets.
via: MASHe Read More

Adding some AutoFill magic to your Google Sheets Apps Script projects

by

Google Sheets users can already use the magic of AutoFill to expand data automatically detecting a series of numbers, letters or dates. This feature is particularly powerful even when your series includes text or repeating dates. In this post I’ll highlight how you can also use AutoFill in your Google Apps Script projects
via: MASHe Read More

Dashboards in your inbox – Revisting tips on emailing inline Google Sheet chart images with Google Apps Script

by

Back in 2015 I shared a post on Tips on emailing inline Google Charts from Sheets using Apps Script, which looked at how you can email charts from Google Sheets. This solution is one I use in my work on a daily basis and remains largely unchanged. More recently I was faced with the problem […]
via: MASHe Read More

A bulk email/mail merge with Gmail and Google Sheets solution evolution using V8

by

Last year I had a ‘mail merge using Gmail and Google Sheets’ contribution accepted on the G Suite Developers Solution Gallery. Just over 6 months on there has been lots of useful feedback and requests for solutions to some of the limitations of the original published script. In the meantime Google has also made the […]
via: MASHe Read More

Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask

by

I’ll start off by saying this is a very geeky post and if you’ve landed here because you are struggling with extracting hyperlinks in Google Sheets then you might prefer to jump straight to Alexander Ivanov’s Extract URL’s Add-on or alternatively the Info Inspired post Extract URLs in Google Sheets Without Script. The problem: hyperlinks […]
via: MASHe Read More

Tips for using Google Sheets for event programme planning

by

At the Association for Learning Technology (ALT) hosting large events is a regular activity and over the years we have developed bespoke workflows largely based in Google Sheets. In this post I’m going to share some of the tips we use for scheduling our events including drafting/publishing an event programme and how to keep in […]
via: MASHe Read More

Google Apps Script Patterns: Writing rows of data to Google Sheets the V8 way

by

Currently one of the most popular posts on this site is my Google Apps Script Patterns: Writing rows of data to Google Sheets. Given Google’s recent announcement of the general availability of the new V8 runtime I thought it was worth revisiting this particular pattern and using the modern syntax now available to Google Apps […]
via: MASHe Read More

Human Data Interaction … and spreadsheets: Retaking ownership in the age of surveillance

by

On Friday I had the honour of speaking at a @HDINework workshop in Edinburgh for ALT with my boss Maren Deepwell. The purpose of the workshop was to answer the […]
via: MASHe Read More

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

by

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 […]
via: MASHe Read More

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

by

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 […]
via: MASHe Read More

Recent Thought Vectors Tagged "nugget"

Inquiry Nugget Series: Ep 3, Spatial Self

by
via: Section 76!

“Much like many other online identity practices on social networks, the spatial self is based […] Read More

Inquiry Nugget Series: Ep 3, Spatial Self

by
via: Danh's Mind

“Much like many other online identity practices on social networks, the spatial self is based […] Read More

Inquiry Nugget Series: Ep 2, Intimacy

by
via: Section 76!

I don’t want to end the semester with my series unfinished so I will do […] Read More

Nuggeting Sources

by
via: Univ 200

“As a prisoner, I could not access the Web directly. Staff members oversaw policies that […] Read More

Connecting Nuggets

by
via: Not So Far Far Away...

Fisheries and sustainable resources of the ocean are important. Roughly 25% of the protein used […] Read More

Nuggeting sources

by
via: morgan jacobs

This source– I actually found when doing research for a course I am taking about […] Read More