Google Sheets custom functions

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

Summary :

• CUSTOM FUNCTIONS LIST
  • bit.ly
  • twitter
  • tracking
  • lookups
  • text converters
• APPS SCRIPT LIST
  • airtable sync
  • tweet logger

---

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.
• crossLookup : Get the the crossing value between a vertical and an horizontal search from a multi-dimensional range (Vloolup and Hlookup combined), with two possible search for both vertical and horizontal lookups.

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.

airtable sync

This script sync your AirTable datas to a Google Sheets document

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

Options available : sync one or multiple bases/views, sync all columns or only selected ones, store attachments to Google Drive...

The code is an improved version of robiningelbrecht work.

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.