Joseph Palumbo palumbo

Web designer/developer obsessed with productivity and organization through automation (Python, App Script).

palumbo / Download Images.gs

Created June 9, 2022 23:55

The code I used to download images into a Google Sheets cell or download images into a Google Drive folder.

	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 / checkAgainstArray.gs

Created August 27, 2022 18:10

Google Apps Script that will take a value from a user and compare it to values stored in an array.

	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 / Code.gs

Created August 27, 2022 19:45

Checking values against an array to prevent data duplication

	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 / payrollElectionSort.gs

Created September 14, 2022 02:30

Sorts payroll election order based on amount and percentage

	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 / createFolders.gs

Created August 5, 2023 16:50

This Google Apps Script creates folders and files in Google Drive based on values in Google Sheets

	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 / Code.gs

Last active December 11, 2023 00:39

Create a Notion-Style Life OS Dashboard in Google Sheets

	function onOpen() {

	randomQuote();

	let ui = SpreadsheetApp.getUi();

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