View beep2telegram_v2.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 1️⃣ change settings | |
// Telegram token | |
var token = "826438459:AAH2hEf7YZq..."; | |
// Spreadseet id for storing memory | |
// Sample: | |
// https://docs.google.com/spreadsheets/d/1pI12qRVgIY7i03tVdd9jNd2GwPDgOi1RLthdpVpdMD8 | |
var memory_sets = { |
View user_email_onEdit.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function onOpen() { | |
var ui = SpreadsheetApp.getUi(); | |
ui.createMenu('😎📬 run me 2x times') | |
.addItem('please let script to see your email', 'install') | |
.addToUi(); | |
} | |
// function test() { | |
// var e = { |
View beep2telegram.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var token = "1234697707:AAHGyL2PE..."; // CHANGE1 | |
function doPost(e) { | |
var chat_id = -0123456789; // CHANGE1 | |
var msg = e.parameter.msg; | |
if (!msg || msg === '') { | |
return returnXml_('no message'); | |
} | |
// uncomment to prevent same messages | |
// if (inMemory_(msg)) { |
View telegrambot.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// __ | |
// /_ | | |
// | | | |
// | | | |
// | | | |
// |_| | |
// Set Bot, copy token: | |
// https://t.me/botfather | |
// set your token ↓ | |
var token = "1815465433:AAGpRcd--KsZycuSYmBOCDcVvws5lSvkuqw"; |
View googleFormOnSubmit.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// gentleman script for google forms | |
// | |
// gets submitted valus: | |
// 1. question label | |
// 2. question id | |
// 3. response value | |
// | |
// ⚠️ This is Form trigger. | |
// Open script editor from form interface | |
// Install it wia Triggers |
View combine.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// combine data from all sheets in current file | |
function combineData() { | |
// CHANGE SHEET NAME ↓ ///////////////////////////// | |
var sheetTo = 'combined'; | |
//////////////////////////////////////////////////// | |
var file = SpreadsheetApp.getActiveSpreadsheet(); | |
var sheets = file.getSheets(); // get all the sheets | |
// set where we want to write the results | |
var outSheet = file.getSheetByName(sheetTo); | |
var outdata = [], sheet, sName, data = []; |
View Dependent DropDowns 2D Wide. v0.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Copy sample file here: | |
// https://docs.google.com/spreadsheets/d/1hUOuDZcfXxaLvJbEA-SxzF4oGGU3lW3iJyS4wAV8YWA/copy | |
function onEdit(e) { | |
dvl0_(e); | |
} | |
function dvl0_sets_() { | |
return [ | |
{ |
View Code.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// sample file: | |
// https://docs.google.com/spreadsheets/d/1_rk4xFsMrxiuXqo5-HQWfvOjBU6nGDw1rlJFU0sci9U/copy | |
function onOpen() { | |
var ui = SpreadsheetApp.getUi(); | |
// Or DocumentApp or FormApp. | |
ui.createMenu('🙂 Click me') | |
.addItem('Image 🖼️ to Drive', 'showFormImages') | |
.addToUi(); | |
} |
View parsUrls.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function test_parse() { | |
var file = SpreadsheetApp.getActive(); | |
var sheet = file.getSheetByName('Sheet1'); // change | |
var sets = { | |
rangeParse: sheet.getRange('L2:L16429'), // change | |
rangeResult: sheet.getRange("M2"), // change | |
func_parse: parseOkkoFilmToGetHorizontalPoster_ // change / create your function | |
}; | |
parseUrls_(sets); | |
} |
View Timer.gs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function readTimer() { | |
// [ 1 ]. Get report | |
var tags = ['onMinute_admin', 'onMinute_worker', 'onMinute_importer', 'onMinute_sizif1', 'onMinute_sizif2']; | |
var report = getTimerReps_(tags); | |
console.log(report); | |
// => gives 2D Array with a report about executions. | |
// So U can write it on Spreadsheet. | |
// [ 2 ]. Gat all data from logs |
NewerOlder