Episode 5: Welcome to the Google Workspace Developer News! Find out what’s new on the Google Workspace Platform.
Here are the latest Google Workspace developer updates compiled by Chanel Greco. The standout feature is the integration of Google’s Dialogflow CX (a powerful natural language understanding platform) with the Google Chat API. This lets developers build chat apps that truly converse with users. Access is currently available through the Google Workspace Developer Preview Program.
The video spotlights more exciting updates to the Google Chat API. Interactive widgets (like thumbs up/down icons) can now be placed at the bottom of messages, boosting user interaction. Additionally, the formattedText field supports bulleted list markup, making it easier for apps to organize information.
Finally, Google Apps Script gets a boost too! The new LinkPreview Class in the Card Service grants control over link titles, visuals, and how they’re displayed within smart chips.
Click the source link for a deeper dive into these updates and find helpful resources in the video description!
Totally Unscripted* returns live on 03 April, 2024 at 1200 PDT / 1500 EDT / 1900UTC / 2000 BST!
The shift to hybrid work models presents unique challenges for businesses. How do you create a seamless, productive experience for employees in this new environment?
These challenges also create opportunities for third parties like Comeen to develop solutions that surface new functionality for Google Workspace customers with deep integrations into services like Google Meet and Google Chat, as well as other platforms like Slack.
Join this exclusive session with Comeen’s CTO, Simon Cleriot, to discover the potential of Google Workspace APIs. He’ll share insights into Comeen’s philosophy toward API integrations and how they build solutions that transform the hybrid workplace.
In this blog we are going to find out who exactly has access to my Google Drive files, be it a Google Sheet, Google Doc, Form and more. To do this we are going to be using the DriveApp and Google Apps Script.
Recently Aryan Irani shared this post which shows how you can get the file permissions on a Google Drive file using DriveApp. This uses the DriveApp methods for .getEditors()and .getViewers(), which left me wondering about commenters???
The answer is file commenters are included in the .getViewers() response and as pointed out by TheMaster you can filter out commenters with .getAccess().
Another approach is to use the Advanced Drive Service:
The advanced Drive service lets you use the Google Drive API in Apps Script. Much like Apps Script’s built-in Drive service, this API allows scripts to create, find, and modify files and folders in Google Drive. In most cases, the built-in service is easier to use, but this advanced service provides a few extra features, including access to custom file properties as well as revisions for files and folders.
Learning about the Advanced Drive Service can be useful as it open up more opportunities to interact with Google Drive content and can also help you get file properties.
In the case of permissions there is a dedicated Permissions Resource that allows access to all the file permissions. For example, if I wanted to see what accounts had access to a file in MyDrive you can use:
Using the Advanced Drive Service does require a step up in understanding how to call the Drive API and the response you get but once you begin understanding it can come with huge benefits with more efficient code.
The Slides Advisor project is an open source, Google Workspace Add-On that uses artificial intelligence (AI) technology to review and give feedback on your presentations, whenever you need it. The project uses Google’s Gemini API image and text processing features to analyze your Google Slides against a set of guidelines and lets you know how you are doing against those guidelines. Even better, you can customize those guidelines to follow your organization’s recommendations, or remind you to improve your presentations based on rules you define for yourself.
We’ve all been there: scrambling to cram too much information onto a single slide. But what if you had an AI assistant to give your presentations a once-over?
The Slides Advisor is a free, open-source Google Workspace Add-on for Google Slides that uses the power of AI to analyze your presentations. It checks your slides against customisable guidelines, helping you ensure they’re clear, concise, and visually appealing.
Everything you need to get started is covered in the source post by Joe Fernandez and Steve Bazyl. One of the highlights for me is seeing how you can setup a service account to access the Gemini AI API with Google Apps Script. The post also covers how you can modify the prompt you use to get different responses from Gemini.
Welcome to the Essential Apps Script course. This guide is designed so you can work through an introductory course in Google Apps Script, designed so you do not need any knowledge of coding to get started.
As part of our latest episode of Totally Unscripted we chatted to Phil Bainbridge about the work he does at the University of York supporting and creating Google Apps Script projects.
One of the resources the University has developed is the Essential Apps Script course which is designed to lead beginners through the first steps in learning Google Apps Script. The guide is shared under a Creative Commons CC-BY-NC-SA which allows anyone to reuse course materials for non-commercial use if shared with the same licence and attributing the University of York.
This course is a perfect starting point for both beginners and those tasked with helping others learn Google Apps Script. Its step-by-step approach and beginner-friendly language make it easy for anyone with no prior coding experience to grasp the fundamentals. For those supporting others, the course provides a clear and structured resource to guide colleagues through the process, saving valuable time and ensuring everyone is on the same page from the beginning.
Totally Unscripted* returns live on 20 March 2024 at 1200 PST / 1500 EST and because of the crazy daylight saving time in the United States will be for many non-US viewers the earlier time of 1900 UTC/GMT.
Join us as we explore how Google Apps Script is being used to make a real impact in productivity. Our guest speaker, Phil Bainbridge, is an experienced IT specialist at the University of York and author of ‘The Gift of Script’ and regular contributor to AppScriptPulse.
Phil will share his insights on how Google Apps Script can be used to automate tasks, create custom solutions, and enhance your workflow. As part of this episode we will also discover how Phil and other members of York’s Digital Inclusion, Skills & Creativity team support digital literacy development in Google Workspace and Apps Script as well as the solutions they have created to improve productivity.
So if you are asking yourself how can you supercharge your productivity with Google Apps Script? Then this episode of Totally Unscripted is hopefully for you!
Google Next is only a few short weeks away and as of this morning, the Agenda builder is live. In this video I walk through how I choose which sessions to attend, and my recommended Google Workspace sessions.
Jesse Nowlin, tabGeeks founder and Google Workspace Admin expert, has complied this great video with tips on how to get the most out of Google Cloud Next ’24. Jesse has highlighted a number of Google Workspace related sessions which are linked from the video description.
Jesse has included the session Charles Maxson, Kara Ireland and myself (Martin Hawksey) will be doing on Day 3 April 11, 2024 at 11:00 AM – 11:45 AM PDT on Apps Script and Gemini: Build custom AI-powered Google Workspace solutions. Kara and I have already started discussing tactics for getting the mic off of Charles. The session is demo packed and hopefully full takeaways that can help with your own Gemini API powered Google Workspace solutions.
The entire Totally Unscripted crew will actually be at Next ’24 with Alice Keeler giving a Lightning Talk on Duet Your Data. If you are one of the anticipated 40K attendees (⊙＿⊙’) please come and say hello. Finally, if you haven’t registered yet Jesse has a referral link in his video description.
Episode 4: Welcome to the fourth edition of the Google Workspace Developer News! Find out what’s new on the Google Workspace Platform.
Another great summary of Google Workspace Developer News put together by Chanel Greco from the Google Workspace DevRel team. The update includes information on:
Google Meet API and Google Workspace Events API now generally available:Â These APIs enable developers to programmatically create and manage meetings, and subscribe to meeting events.
Google Chat apps now support Google Apps Script’s Card Service:Â Developers can now use Card Service to build user interfaces for Chat apps.
Subscribe to Google Calendar changes: you can now get push notifications for a specific calendar events, such as working location, focus time, or out-of-office events
Google Apps Script automates tasks (even offline) and builds web apps using spreadsheets as databases. This report presents a basic dining reservation system to illustrate key aspects of web app development with Apps Script, HTML, and Javascript.
One of my first Google Apps Script projects was an event booking system. It was a great way to learn about integrating with the various services like Google Calendar. Roll forward 14 years and it is a topic that Kanshi Tanaike has revisited with a dining reservation system built on Google Sheets with a web app frontend.
All the code is published on GitHub and even if you don’t need a reservation system a great opportunity to see how one can be coded and there could be lots of juicy little snippets that you can use in your own projects.
If you want to publish your Google Apps Script project on the Google Workspace Marketplace, or if you already have an add-on or app on this marketplace and are using authorization scopes which are now restricted, you will have to go through a TIER 2 CASA security assessment.
If you would like an overview of the process from a developer’s perspective you are in luck as Kelig Lefeuvre (Product Engineer at Scriptit & Folgo) has shared a guide specifically with Apps Script developers in mind. The article includes a number of useful tips and information about the review process which you won’t find in the official documentation.
As part of the CASA process Kelig recommends using the option to you can submit bypass the Fortify scan and submit your own results. those results Kelig has also provided a second article with a step-by-step guide on ‘how to scan your Google Apps Script project for CASA’.
