google-sheets-custom-functions

KO | EN

gitlite — search

#javascript #react #ai #typescript #llm #linux #docker #macos #nodejs #java #windows #awesome #pytorch #openai

google-sheets-custom-functions

(★ 9)

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

google-sheets-custom-functions Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Google Sheets custom functions

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

Summary :
- [CUSTOM FUNCTIONS LIST](#custom-functions-list)
  - [bit.ly](#bitly)
  - [twitter](#twitter)
  - [tracking](#tracking)
  - [lookups](#lookups)
  - [text converters](#text-converters)
- [APPS SCRIPT LIST](#apps-script-list)
  - [airtable sync](#airtable-sync)
  - [tweet logger](#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](https://github.com/robiningelbrecht/airtable-google-sheets-backup) 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.

google-sheets-custom-functions

google-sheets-custom-functions Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

google-sheets-custom-functions

google-sheets-custom-functions Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README