Skip to content

Instantly share code, notes, and snippets.

View vutlhari's full-sized avatar
🏠
Working from home

Vutlhari Rikhotso vutlhari

🏠
Working from home
View GitHub Profile
name: Rule Based Categorizer
description: ''
host: EXCEL
api_set: {}
script:
content: |
let categories = {
"BANK_FEES_OTHER.BANK_FEES": ["SEND CASH FEE", "MONTHLY SERVICE CHARGE", "FASTER PAYMENT FEE"],
"ENTERTAINMENT.MUSIC_AND_AUDIO": ["PAUL BOTHNER", "SPOTIFY"],
"ENTERTAINMENT.TV_AND_MOVIES": ["M-CHOICE", "WWW.F1.COM", "NETFLIX", "DISNEY PLUS"],
name: GTP-3 Categorizer
description: ''
host: EXCEL
api_set: {}
script:
content: |
/**
* Returns category data from GPT-3
* @customfunction
* @param {string} transaction