Run Authorisation and Setup Script Before Revealing Google Sheet Tabs Using Google Apps Script
Setup Sheet Template: https://docs.google.com/spreadsheets/...
Starter Sheet to play along:
https://docs.google.com/spreadsheets/...
The Written tutorial:
https://yagisanatode.com/2022/05/23/o...
It can be hard to get users to run starter scripts before they start playing around in a spreadsheet. In this tutorial, I walk you through a process that gets users to authorise their Google Apps Script in the Google Sheet and then runs the Startup process before displaying selected Google Sheet tabs for the user.
00:00 Intro
00:41 Setup Sheet
01:09 Explaining the layout of the Template Setup Sheet
02:47 Add the Template Setup Sheet to your Spreadsheet
03:33 User's workflow
04:13 The code
13:04 Test run the buttons
More on:
Running Apps Script for the first time:
• Running Google Apps Script for the Fi...
Hiding Buttons after being clicked:
• Remove a Google Sheet button after it...
-How to connect a button to a function in Google Sheets
https://yagisanatode.com/2019/03/07/g...
Learn more about Google Apps Script here:
https://yagisanatode.com/google-apps-...
#GoogleAppsScript #GoogleSheets #GoogleWorkspace