Devfest in London
Jan 25, 11:00 AM – 3:00 PM (EST)
Western University, 1151 Richmond St, London, N6A 3K7
This presentation by Laurence Svekis explores the integration of Google Apps Script and Gemini AI to streamline workflows, enhance automation, and unlock new possibilities in Google Workspace. It provides an overview of Apps Script as a cloud-based JavaScript platform for automating and extending Google Workspace products. The presentation introduces Gemini AI for generating content, summarizing documents, and automating image descriptions. Through practical examples and code snippets, it demonstrates how to use these technologies to enhance productivity and data-driven decision-making.
Outline of the Presentation:
- Introduction to Google Apps Script
- Overview and capabilities.
- Types of scripts: Bound and Standalone.
- Quick start guide to using Apps Script.
- Key Applications of Apps Script
- Automating repetitive tasks (e.g., scheduling reports, reminders).
- Custom functions in Google Sheets.
- Email automation and notifications.
- Web app and dashboard creation.
- Data analysis and reporting.
- Advanced Features in Apps Script
- Google Workspace integration (Sheets, Docs, Calendar).
- File management and Drive automation.
- Event triggers (simple and installable).
- API integrations and external data connections.
- Practical Examples
- Automating sales reports (generate and email PDFs).
- Extracting text from PDFs using OCR.
- Fetching and storing API data in Google Sheets.
- Introduction to Gemini AI
- Overview of Gemini’s capabilities.
- Setting up Gemini API and integrating with Apps Script.
- Applications of Gemini AI
- Document summarization and email integration.
- Image description generation and metadata extraction.
- Automating content creation using AI.
- Demonstrations and Code Snippets
- Example use cases (e.g., creating dynamic reports, extracting image descriptions).
- Links to GitHub repositories for full examples.
- Success Stories and Inspiration
- How Apps Script has evolved since 2015.
- Examples of practical use cases and their impact.
- Resources and Next Steps
- Links to documentation, GitHub repositories, and resources.
- How to get started with Apps Script and Gemini.
- Closing Remarks
- Encouragement to explore automation and AI integration.
- Call to connect and collaborate with the presenter.
This outline reflects the core content of the presentation and emphasizes the combination of technical insights with practical, actionable steps. Let me know if you’d like further details or specific examples!
