Uploaded August 2025 | Updated September 2026, 1 week ago

---

Ever wished you could update dropdowns on a Google Form from a Google Sheet? In this video, I'll walk you how to write a script to accomplish just that, how to run the script from a menu on the Google Sheet, or even how to make the script run automatically--either when the Google Form is submitted or on a schedule.


0:00 1. Intro
0:10 2. Creating Apps Script File
0:30 3. Getting the Google Form ID
1:07 4. Getting the Question IDs
2:24 5. Authorizing the Script
3:40 6. Getting Dropdown Data from Google Sheets
5:30 7. Updating the Form Dropdowns
7:15 8. Running the Script
8:41 9. Adding Script Menu to Sheet
10:04 10. Automatically remove submissions from options
11:42 11. Adding Trigger to Run Script Automatically
13:19 12. Final Demo & Walkthrough
14:40 13. Conclusion