Category: Google Sheets

Allow anyone to add videos to a YouTube playlist from a Google Form using Google Apps Script

A quick example of how you can use Google Apps Script to automatically allow anyone to add YouTube videos to one of your playlists

One Comment

Converting .csv or Google Sheets into Wikipedia tables

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.

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet)

Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.

One Comment

TwtrService: A Twitter API client library for Google Apps Script

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.

3 Comments

Need a better Twitter Archiving Google Sheet? TAGS v6.0 is here!

Amazing to think the TAGS (Twitter Archiving Google Sheet) has been going for over 4 years now. Version 6 is a major code rewrite and the most important new feature is a better setup processes. Read this post to find out more.

11 Comments

Breaking the cell: Google Sheets for data mining, analysis and more #webexpo

Slides from presentation at #WebExpo on using Google Apps Script and Sheets for social data mining and analysis.

One Comment

Google Sheets as a Database – INSERT with Apps Script using POST/GET methods (with ajax example)

Revisiting my POST/GET Google Apps Script example which lets you submit data to a Google Sheet (and other destinations) using your own forms or other ajax calls

One Comment

Using Google Apps Script to integrate with import.io

This post illustrates how you can integrate the structured web data scraping service import.io with Google Apps Script.

7 Comments

Generating a column of series repeating text in Google Sheets

Sometimes it’s useful to generate a column of data based on a series repeating x number of times. Here’s a formula for doing this in Google Sheets

MASHe Review 2013: Google Apps Script and Google Sheets

A look back at some of the work I’ve done around Google Apps Script and Google Spreadsheets/Sheets in 2013

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