Max Brawer
Aug 30, 2021

--

Hi Genesis! This all depends on the project. Generally speaking https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app explains how to .getSheetByName() for example. For #2, I also change this depending on if I expect the data to always grow and accumulate or not. There are various tricks like calling clearContent() each time to always be pasting from scratch. If you or your company could ever use some brief consultation I am always available to work on projects! inquiries@maxbrawer.com. Better still I am working on a Workday App for Google Workspace that anyone can use.

--

--

Max Brawer
Max Brawer

Written by Max Brawer

People Tech & Analytics leader @ Atlassian, formerly Twitch, BuzzFeed, Google, Nielsen | Try his apps @ sheetswizard.com

No responses yet