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
Watch video Run Authorisation and Setup Script Before Revealing Google Sheet Tabs Using Google Apps Script online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 24 May 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,695 times and liked it 27 visitors.
