Users unable to run apps scripts in Google sheets

43 views
Skip to first unread message

Geoffrey Quick

unread,
Jun 27, 2024, 3:54:19 AM (3 days ago) Jun 27
to Google Apps Script Community
I have a couple of scripts in my shared Google sheet which extracts date from the sheet create and email and emails it to a user.

The scripts run ok for me (the sheet owner and script creator) but won't run for another user (Editor permission on the spreadsheet).

Please advise how I can give this user access to run the scripts,

see attached message that the user gets.
WhatsApp Image 2024-06-26 at 17.15.21_7ca23cb8.jpg

Yagisanatode

unread,
Jun 27, 2024, 7:37:23 AM (3 days ago) Jun 27
to Google Apps Script Community
Each user will need to go through the Authorisation process. 

Feel free to share my video on this (I do this for my clients) if you think it will save you some time. 

Geoffrey Quick

unread,
Jun 27, 2024, 8:46:41 AM (3 days ago) Jun 27
to Google Apps Script Community
Thank you, clearly explained.

George Ghanem

unread,
Jun 27, 2024, 12:43:10 PM (2 days ago) Jun 27
to google-apps-sc...@googlegroups.com

Each user will need to give permission to the script for it to run for them.


--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/b9958279-78c4-44ca-9979-2617a44fd62an%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages