Google Sheets custom functions

A collection of custom functions made for Google Sheets / Google Scripts.

CUSTOM FUNCTIONS LIST

How to use it ?

• Simply open a Google Sheets file and go to Tools > Script editor.
• Copy paste the functions you want (you should better create new script files if you want to use a lot of custom functions).
• Save and go back to your Sheets file.
• Begin to use the function in your cells the same way you are doing it with native functions !

bit.ly

• BITLYshortener : Generate a short bit.ly link.
• BITLYunshortener : Retrieve the original (long) url from a bit.ly link.
• BITLYclick : Get the number of clicks from a bit.ly link.

bit.ly API credentials are required, see the configuration steps on the file

twitter

• TWITTERsearchCount : Get the number of published tweets with the specified searched term, hashtag or twitter query (from the 7 previous days maximum).
• TWITTERfollowersCount : Get the number of "followers" from the specified account.
• TWITTERfollowingsCount : Get the number of "followings" from a specified account.

Twitter API credentials are required, see the configuration steps on the file

tracking

• UTMtag : Generate a Google UTM tag to append to a link.

lookups

• headLookup : Get the head row value of a searched term, from a multi-dimensional range.
• rangeLookup : Get the lookup (vertical) value from a multi-dimensional range.

text converters

• removeACCENT : Replace every accented characters by non-accented version.
• encodeURI : Encode a regular text (ISO 8859-1) to Uniform Resource Identifier (URI).
• decodeURI : Decode an Uniform Resource Identifier (URI) to regular text (ISO 8859-1).
• encodeHTML : Encode a regular text (ISO 8859-1) to HTML one.
• decodeHTML : Decode an HTML text to regular one (ISO 8859-1).
• encodeUTF8 : Encode a regular text (ISO 8859-1) to UTF8.
• decodeUTF8 : Decode UTF8 text to regular one (ISO 8859-1).
• toString : Convert a value into a string.

APPS SCRIPT LIST

How to use it ?

• Simply open a Google Sheets file and go to Tools > Script editor.
• Copy paste the app you want.
• Read and follow the Script configuration steps.

tweet logger

This script log tweets informations to a Google Sheets document, based on searched term, hashtag or twitter query.

It can be used with a clock trigger to have automatic updates.

The tweet informations logged are : date, username, user handle, tweet id, user followers count, user followings count, tweet text, retweets count, likes count, tweet status, RT reply user, RT reply id.