January, 2025



AppSheet year in review: AI-powered apps and more streamlined controls

2024 was a year of growth and innovation for AppSheet. We launched new features and products that helped our customers create powerful and transformative apps. Here are three innovations that enabled both business users and IT professionals to build apps and automate processes without writing a single line of code.






Developer News

Join the Developer Preview Program

Want early access to Google Workspace features and help shape their development? Join the Developer Preview Program! This video gives you the rundown and how to apply. Learn about the program, its benefits, how to find features, apply, and the requirements. Don't miss out!  


Watch now


Developer Spotlight with Zack Akil - Senior ML Engineer & Developer Advocate

Meet Zack Akil, a Google ML Engineer, as he discusses building "Event Genie" with Gemini Flash! Learn how this Google Workspace add-on extracts event details from emails and get tips on experimenting with Gemini models.  Zack also shares his approach to creating AI demos and teases upcoming projects using Gemini 2.0. Don't miss this insightful episode packed with valuable information and inspiration!


Watch now




Community Spotlight


Can Al Watch YouTube for You? Automating Insights with Gemini & Google Apps Script

by Ivan Kutil

This post describes an automated system built with the YouTube Data API, Google Apps Script, and Vertex AI, that extracts and summarizes key information from YouTube videos. This system uses a Researcher agent to find relevant videos and save their details, and a Librarian agent which leverages Gemini AI on Vertex AI to watch the videos, summarize them, and compile those summaries into a Google Doc. This solution eliminates the need to manually watch and summarize videos, allowing you to focus on analyzing the information.



Manage Gemini uploads, schemas and prompts

by Bruce Mcpherson

I have thousands of PDF documents stored on Cloud Storage that I need to analyze using Gemini. To streamline this process, I created a way to efficiently upload and manage these documents within Gemini directly from my terminal session. This would help me to experiment with different schemas and prompts and iterate on the uploaded files. Additionally, I created a method to identify and remove duplicate documents based on their content, as many of them have different filenames but contain identical information. 




Solutions Spotlight


Time management: Make an agenda for meetings   

Automatically create agenda documents in Google Docs and attach them to your Google Calendar meetings. The script creates a document template for an agenda. When you update your calendar, the script checks to see if any events you own include "#agenda" in the description. If the tag is present, the script makes a copy of the template, adds it to the calendar event, and shares it with the event attendees.



Integrating AppSheet with Google Workspace

Did you know that AppSheet can integrate with Google Workspace? In this video, we speak to how AppSheet - Google’s no-code application platform - helps you streamline workflows, and demonstrate how you can create your own apps that integrate with Google Workspace. Watch to explore the possibilities of AppSheet!