Sijo Kuruvilla

Home
100 Notes
Notes to Self
Scripts
Articles
Projects
Productivity
Media
Blog
Archive

Scripts

Google App Scripts mostly
New
Top
Locating ID of a Telegram group
You can do this by making use of the get Updates method Entering the below code into any web browser immediately after adding the bot to the group. You…
Fetch link to logger spreadsheet from Telegram bot
Just made an edit to my logger code So each time I wanted to take a look at the data being logged, I had to retrieve the spreadsheet link. And each time…
Filter for calendar invitations
Has the words: invite.ics OR invite.vcs. Has attachment box. Source article: https://support.google.com/a/users/answer/9308760?hl=en
Three useful Scripts shortcuts
shift + tab - Auto indentation of code command + R - Run code command + return - view logs
Delete all Labels
// function to delete all labels function deleteAllLabels() { var sheet = SpreadsheetApp.openById(SSID).getSheetByName('Labels'); sheet.clear(); var…
List all Labels
// function to delete all labels with info function listLabelInfo() { var sheet = SpreadsheetApp.openById(SSID).getSheetByName('Labels'); sheet.clear…
Deleting all Filters
// function to delete all filters function deleteAllFilters() { var sheet = SpreadsheetApp.openById(SSID).getSheetByName('Filters'); sheet.clear(); var…
© 2023 Sijo Kuruvilla George
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing