Max-Makhrov

• interface
  • ecosystem
  • interface
  • shortcuts + navigation
  • limitations and alternatives
  • useful links + link theory
  • add-ons
  • collaboration
  • pivot tables
• Looker Studio

Max-Makhrov

Creating a course

• 6-7 weeks
• 12-14 lessons
• lectures 1-2 times a week
• lecture 1.5-2 hours talk

Stages

1. Market research, brief creation

Max-Makhrov

// 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 = {

Max-Makhrov

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 = {

Max-Makhrov

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)) {

Max-Makhrov

//   __ 
//  /_ |
//   | |
//   | |
//   | |
//   |_|
// Set Bot, copy token: 
// https://t.me/botfather  
// set your token ↓
var token = "1815465433:AAGpRcd--KsZycuSYmBOCDcVvws5lSvkuqw";

Max-Makhrov

// 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

Max-Makhrov

// 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 = [];

Max-Makhrov

// Copy sample file here:
// https://docs.google.com/spreadsheets/d/1hUOuDZcfXxaLvJbEA-SxzF4oGGU3lW3iJyS4wAV8YWA/copy

function onEdit(e) {
   dvl0_(e);
}

function dvl0_sets_() {
  return [
    {

Max-Makhrov

// 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();
}