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 = { |
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 = { |
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)) { |
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"; |
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 |
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 = []; |
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 [ | |
{ |
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(); | |
} |
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); | |
} |
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