August, 2024




See how the Google Workspace product team use Apps Script to prototype

Vishnu Sivaji is Product Director Google Workspace at Google. Check out what he has to say about how he and his team create new features for Google Docs, Sheets, and Slides and what role Apps Script plays in this.





Developer News

Google Workspace Developer News on YouTube

In the latest episode of the Google Workspace Developer News on YouTube we cover updates to the Google Docs API, the Google Chat app card interface, the Meet Add-ons SDK, and more. 



Watch now


Join Google Cloud Innovators

The Innovators program gives developers and practitioners the latest updates, access to technologies and expertise, and exclusive benefits to build your skills on Google Cloud. Connect with your peers, accelerate your learning, and access special live events with Google leaders and experts.


Learn more



Community Spotlight


Automate Google Drive test data creation with Google Apps Script

by Martin Hawksey

This post demonstrates how to automate the creation of test data in Google Drive using Google Apps Script. The script efficiently generates nested folders and various file types, providing a realistic test environment for Google Workspace users.



Find Legitimate Emails in your Gmail Spam Folder with AI and Google Apps Script

by Amit Agarwal

False positives in Gmail are uncommon but can happen, meaning an important email might mistakenly end up in your spam folder. When you’re dealing with hundreds of spam messages daily, identifying these legitimate emails becomes even more challenging. What if we used AI to analyze our spam emails in Gmail and predict which ones are likely false positives? With this list of misclassified emails, we could automatically move these emails to the inbox or generate a report for manual review.





Solutions Spotlight


File Management: Import CSV data into a Google Sheet 

The script runs daily on a time-driven trigger. It iterates through CSV files in a designated folder and adds the data from each file to a Google Sheet. By default, the script removes the header row of each CSV dataset before adding the data to the last row of the sheet. The script sends a summary email listing the files that were imported and moves the files to a different folder to prevent duplicate processing.




No code apps with AppSheet and Google Cloud AI

In this video, dive into streamlining AI-powered application creation using AppSheet, Google’s no-code platform, and Google Cloud AI's capabilities. Explore practical integrations, techniques, and best practices to accelerate the development of intelligent, data-driven applications.