To allow your scripts to run, you will need to authorise them. Below are the steps which show you how to do this:
- Click the play button on the toolbar.
2. A dialogue box will open asking for authorisation. Click “Review Permissions”.
3. It will then ask you to select an account to run the script from. Usually, the one you want is shown at the top. Click on it. If you want to choose a different account, select “Use another account” and select an account.
4. This will state that the app isn’t verified, which means Google haven’t verified it. Ignore that, and click “Advanced”.
5. This will show further information at the bottom. Click “Go to First Script (unsafe)” (Go to + the name of your script project + (unsafe)). Don’t worry it is safe! It’s your script!
6. On the final page, it will confirm what the script will be able to do. For example, here as we’ve used the SpreadsheetApp it allows us to see, edit, create and delete spreadsheets. just click “Allow”.
Your script will now be authorised and will run.
Note, if you add code to your project that access other areas (scopes), such as using the DriveApp to access your or someone’s Drive, then you will have to reauthorise it following the same steps.
[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”3.21.1″][et_pb_column type=”4_4″ _builder_version=”3.21.1″][et_pb_text admin_label=”PostEnd” _builder_version=”3.21.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” use_border_color=”off” border_color=”#ffffff” border_style=”solid” global_module=”22296″ saved_tabs=”all”]Note, some of the information above may be out-of-date as Google continually add new features to the apps and make cosmetic changes. I have a set of eBooks, which are periodically updated to include the latest changes.
eBooks available on Drive, Forms, Sheets, Docs, Slides, Sheet Functions, and Apps Script:
- “Beginner’s Guide to Google Drive” – Kindle store / Apple Books store
- “Beginner’s Guide to Google Forms” – Kindle store / Apple Books store
- “Beginner’s Guide to Google Sheets” – Kindle store / Apple Books store
- “Beginner’s Guide to Google Docs” – Kindle store / Apple Books store
- “Step-by-step Guide to Google Slides” – Kindle store / Apple Books store
- “Google Sheet Functions – A step-by-step guide” – Kindle Store / Apple Books store
- “Beginner’s Guide to Google Apps Script 1&2 – Sheets & Forms” – Kindle Store / Apple Books Store
- “Beginner’s Guide to Google Apps Script 3 – Drive” – Kindle Store / Apple Books Store
- “Step-by-step Guide to Google Apps Script 4 – Documents” – Kindle Store
Baz Roberts (Flipboard / Twitter)
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]