[Google App Script] How to create a trigger
#GoogleScript #Trigger
Tell you how to create script behide a sheet on which any change will fire the script as trigger.
1. Logout all accounts from google
2. Create an Google Sheet
3. Tools/Script Editor: SpreadsheetApp.getUi().alert('Hello, Changed in Tips A');
4. Run: For testing
5. Resources/Advanced Google services: Turn on "Google Sheets App" on
6. Create a project on Goto Google Cloud Platform Console: https://console.cloud.google.com/
7. Get project number
8. API & Service/OAuth consent screen: Set "External"
9. Assign project to a trigger: https://script.google.com/
10. Back Script Editor: Resources/Cloud Plantform Project: Set project number
11. Unsafe type: Advanced -- Go to "project name" (unsafe) -- Allow
12. Publish/Deploy as Sheets ad-on
13. Back to your sheets for testing: Change any cell
14. Popup window happens.
Good luck!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Please make sure to leave a like👍 & comment
❤️ SUBSCRIBE IF YOU ARE NEW AND TURN THE BELL ON🔔