Event Description
Tired of tedious, manual spreadsheet work? Learn how to prompt Gemini to generate quick, basic Apps Script snippets that simplify tasks, like mapping dates to university semesters.
Repetitive spreadsheet tasks--like sorting administrative dates into academic terms--can eat up hours of your week. Gemini makes it possible to build quick, self-contained micro-automation scripts using everyday, conversational language. We'll use plain-English prompts to ask Gemini for simple Google Apps Script code snippets. We'll use the example of mapping dates to university semesters: Instead of manually adding a Semester, we'll create a script that will look at the date and automatically add the appropriate semester. You will leave with a workflow to automate simple spreadsheet chores, eliminating manual errors and boosting efficiency.
In this session, you will:
- Locate and navigate the built-in Apps Script editor within Google Sheets and understand how basic micro-automations work.
- Craft targeted Gemini prompts that specify exactly which columns to read (e.g., event dates) and which columns to fill (e.g., academic semesters).
- Copy, paste, and execute Gemini-generated code snippets in Google Sheets safely--without writing a single line of code from scratch.
- Test and adapt simple scripts to confirm accuracy and identify other low-risk, repetitive data tasks in your daily workflow.
Register.
