palumbo

function onOpen() {

  randomQuote(); 

  let ui = SpreadsheetApp.getUi(); 

  ui.createMenu("Life OS")
    .addItem("New Quote", "randomQuote")
    .addItem("New Journal Entry", "dailyJournal")
    .addToUi(); 

palumbo

function myFunction() {
  
  // Spreadsheet Variables 
  var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  var sheet = ss.getActiveSheet(); 
  var lastRow = sheet.getLastRow(); 

  // Google Drive Variables 
  var rootFolder = DriveApp.getFolderById("1oqHxYeC8wC0ufJ8WPtq4WKfoJDqulppB"); 

palumbo

function myFunction() {
  let sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); 
  let lastRow = sheet.getLastRow(); 

  for (var i = 1; i < lastRow; i++) {
    let check1 = sheet.getRange(i+7,2).getValue(); // GETS FIRST VALUE IN COLUMN B
    let check2 = sheet.getRange(i+6,2).getValue(); // GETS SECOND VALUE

    if (check1 == check2) {
      let amount = sheet.getRange(i+7,33).getValue();

palumbo

function myFunction() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); 
  var nameArray = ["Eddie", "Jaime", "Katie", 42];

  var inputFromUser = Browser.inputBox('Please enter a value');

  Logger.log(inputFromUser);  

  let checkCell = sheet.getRange("A1");

palumbo

function myFunction() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); 
  var nameArray = ["Joseph", "Elizabeth", "Roman", "Sophia"];

  // GET VALUE FROM USER 

  let valueFromUser = Browser.inputBox("Who are you looking for?");
  
  Logger.log(valueFromUser);

palumbo

function insertImage() {

  let sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); 
  let lastRow = sheet.getLastRow(); 

  for (let i = 0; i < lastRow-1; i++) {
    let url = sheet.getRange(2+i,1).getValue(); 
    let image = SpreadsheetApp.newCellImage().setSourceUrl(url); 
    sheet.getRange(2+i,2).setValue(image); 
  }

palumbo

function onOpen(e) {
  let ui = SpreadsheetApp.getUi(); 
  ui.createMenu('🤖 Automation Tools')
    .addItem('Move reps to individual sheets', 'moveRows')
    .addToUi(); 
}; 

function moveRows() {
  const ss = SpreadsheetApp.getActiveSpreadsheet(); 
  const sheet = ss.getActiveSheet(); 

palumbo

import sys
import requests
import os
from urllib.request import urlopen
from bs4 import BeautifulSoup

# unpack argv
script, url = sys.argv

# get URL

palumbo

#!/bin/bash
yum install httpd php-mysql -y
amazon-linux-extras install -y php7.3
cd /var/www/html
wget https://wordpress.org/latest.tar.gz
tar -xzf latest.tar.gz
cp -r wordpress/* /var/www/html/
rm -rf wordpress
rm -rf latest.tar.gz
chmod -R 755 wp-content

palumbo

function onEdit(e) {
  // setting common variables
  var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  var sheet = ss.getActiveSheet(); 
  var user = Session.getActiveUser(); 
  var cell = sheet.getActiveCell().getA1Notation(); 
  var val = sheet.getActiveCell().getValue(); 
  var range = sheet.getRange("A1:Z182"); // creates range needed to use getCell() later
  var url = ss.getUrl();