Welcome to the developer form for Google Workspace. … I am hoping this will become a great space for sharing developer tips and tricks amongst each other.
Google Cloud Communities is a space hosted by Google designed to allow people using Google Cloud technologies to “meet industry peers, ask questions, collaborate to find answers, and connect with Googlers who are making the products you use every day”. There is now a new Google Workspace Developers space where you can:
“Connect with other Google Workspace Developers, the Google Workspace Developer Experts (GDEs) and the Google team to share and learn from each other”
The new discussion space includes an area to highlight relevant events and will be run to supplement discussions and connections in existing forums.
Last September, Tables launched in Area 120, Google’s internal incubator for experimental projects, with the goal of proving market demand for a solution to help teams organize and track work, and it was a success! Google Cloud has committed to investing in this product area long-term. Moving forward, the beta version of Tables will still be available until we release a fully-supported Google Cloud product – which we expect to complete in the next year.
If you are not familiar with the Tables Beta it is a collaborative data platform designed to make it easier for no/low coders to create workflows and automations. If you would like to see the Tables beta in action Co-founder & Product Lead, Carlin Yuen, joined us on Totally Unscripted in New workflow solutions with Tables and Google Apps Script.The Tables beta has so far been limited to users in the US. The source link provides more details about timelines and how non-US users can join the beta. [HT Ivan Kutil]
Join this Ask Me Anything Session to get answers from the Google Workspace Development Platform and Google Workspace Developer Relations teams about how to integrate with your own solutions.
As part of Google I/O several of the Google team are hosting a Google Workspace developers ‘ask me anything’ session. The session panel includes Matt Izatt (Google Workspace Product Manager), Olaf Hubel (Google Workspace DevRel Manage), Charles Maxson (Google Developer Advocate and Totally Unscripted co-host) and Steven Bazyl Google Workspace Developer Relations Engineer. Follow the link to sign-up and follow the session.
Today we are pleased to announce that building Google Workspace Add-ons has evolved once again, this time to offer developers an alternative to using Apps Script for building add-ons with the general availability of Alternate Runtimes for Google Workspace Add-ons.
While Alternate Runtimes enables the same functionality that Apps Script does for building add-ons, the flexibility and the freedom to choose your dev environment plus the opportunity to decouple from Apps Script will likely yield greater developer productivity and performance gains for future projects. This commonly requested feature by Google Workspace solution developers has finally become a reality.
As part of this post there is an example from Riël Notermans, owner of Zzapps (and Google Developer Expert), highlighting some key takeaways on Alternate Runtimes development and deployment.
Meet the Google Workspace Developer Experts, a global network of experienced technology experts, thought leaders, and influencers who actively support developer communities around the world.
If you are starting out on a new product, environment or beginning to learn to code finding people to connect with within an existing community can often be a challenge. Thanks to the efforts of Charles Maxson hopefully those connections are made a bit easier.
The new Apps Script IDE features the same rich integration with Google Workspace as it did before, allowing you to get started building solutions without having to install or configure anything. If you are working on a standalone script project application, you can use the Apps Script Dashboard to launch your project directly, or if you are working on a container bound project in Sheets, Slides or Docs, you can do so from selecting Tools > Script editor from their top menus.
Charles Maxson, Developer Advocate Google Cloud, has highlighted some features Google Apps Script developers new and old should keep an eye out for. I think one of the big ones for experienced Apps Script developers who work mostly in the online editor is going to be the context menu options and the Command Palette. Find out more in the source post.
In this episode of Sheets to Apps, we show you how you can easily build a payroll app that makes approving timesheets easier and communication with management seamless. Watch to learn how you can build a timesheet application with zero code!
Click through to the YouTube page and check the video description for all the resources to replicate this solution.
Complete the steps on this page to create a Google Sheets add-on that tracks attendance for Google Classroom courses delivered using Google Meet conferencing.
Nice spot via @barrielroberts/@alicekeeler for an official Google Apps Script quickstart which combines Google Sheets, Google Classroom and Admin Reports which lets you create an automated Google Meets attendance roster tool. The quickstart has all the code and instructions you need to get this working.
Google Workplace Add-ons are now available for Google Docs, Sheets, and Slides. Google Workspace Add-ons are already available for Calendar, Gmail, and Google Drive.
There have been Editor Add-ons for a number of years, with Google Workspace Add-ons developers can tap into a new integrated user experience. One of the main differences with Workspace Add-ons is the use of the Card service rather than custom HTML (HTMLService). The benefit of switching to a Card service is cross platform support including integration into Google’s Workspace mobile apps.
Follow the link to the source post for links to all the relevant developer documentation.
Millions of users know G Suite as a collection of communication and productivity apps that enables teams to easily create, communicate, collaborate, and discover content to supercharge teamwork. Beneath the surface of this well-serving collection of apps is also an extensible platform that enables developers to build targeted custom experiences and integrations utilizing these apps, allowing G Suite’s vast user base to get even more value out of the platform. At first glance, it may not be natural to think of the tools you use for day-to-day productivity and collaboration as a developer platform. But consider what makes up a developer platform; Languages, APIs, runtimes, frameworks, IDEs, ecosystem, etc; G Suite offers developers all of these things and more. Let’s take a closer look at what makes up the G Suite developer platform and how you can use it.
Nice overview of the G Suite developer platform from Charles Maxson. I always find it useful to see how others pitch the platform and from this piece useful to see how Apps Script is put in context with other G Suite development options.
Did you know that you can send text messages via Google Sheets? In this episode of Sheets to Apps, we show you how to easily send text messages with Google Sheets via Twilio – an online communications provider.
Let’s talk about the basics of G Suite Add-ons. G Suite Add-ons simplify how users get things done in G Suite by bringing in functionality from other applications where you need them. They provide a persistent sidebar for quick access, and they are context-aware — meaning they can react to what you’re doing in context. … Up until recently, G Suite Add-ons leaned on Apps Script to build Add-ons, but choice is always a good thing, and in some cases you may want to use another scripting language.. So let’s talk about how to build Add-ons using additional runtimes.
Google recently announced the ability to develop G Suite Add-ons using other frameworks other than Google Apps Script. This post on the Google Developers Blog introduces how you can develop G Suite Add-ons with something other than Google Apps Script.
In this post, I’ll show you how to use beginner-friendly ML tools–Semantic Reactor and TensorFlow.js–to build an app that’s powered by natural language.
NEW: Semantic Reactor has been officially released! Add it to Google Sheetshere.
We’ve previously highlighted how TensorFlow.js can be used in Google Apps Script. In this latest example the new Semantic Reactor Google Sheets Add-on published by Google Research is highlighted. Semantic Reactor is designed to make it easier to start exploring Natural Language Understanding (NLU) and with this tutorial you can learn how you can deploy your model to code.
Using Google Analytics and looking for a new way to aggregate, store, and efficiently organize the data from your website in a Google Sheet? In this episode of Sheets to Apps, we show you how to combine the Google Analytics add-on with Apps Script, resulting in the automation of cohesive data summaries that are compatible with Google Sites.
In this latest episode Alexandrina Garcia-Verdin demonstrates how the Google Analytics Add-on can be combined with macros to automate regular reporting. The video description has links to all the resources you need to set this up.
Whilst ‘Sheets to Apps’ videos are targeted at low/no coders as an Apps Script Developer I always find it useful to have a look at the code to see how it is done, as more often than not there will be a technique or method I’ve not come across. In the case of this example my new discovery was the
and after browsing the documentation,
. These methods allow you to replicate the auto-fill functionality users have in Google Sheets.
Another discovery was the various
calls when building the charts. I’ve used
in projects in the past and the issue I’ve had is navigating the long list of options you can use for various chart types. Using the macro recorder seems like a great way to capture all the options you want to add to your script project.
As part of Next OnAir week 2 the focus was on ‘Productivity and Collaboration’ Charles Maxson from the G Suite DevRel team not only provided some highlights from the week, but he also premiered the new Google Apps Script IDE.
This post includes a recording to a live demo of the new Google Apps Script editor. No news on when the new Script Editor will be generally available, but from the demo it looks like Google have focused on making it easier for developers to code and debug scripts.
Cleaning up data from downloaded accounting reports or from other systems can take up valuable time and resources. In this episode of Sheets to Apps, we’ll walk you through adding automation to your monthly Excel accounting data that records your steps into a script that you can run repeatedly with Google Sheets macro recorder.
From the video description you’ll find all the links you need to the example Google Sheet, instructions and more
The Google Cloud Vision API is a powerful tool that helps developers build apps with visual detection features, including image labelling, face and landmark detection, and optical character recognition (OCR). Getting started building with these services is relatively simple with Apps Script, as it uses simple REST calls to interact with the API directly, eliminating the need to set up SDKs or to download client libraries.
In this post Christian Schalk, Google Cloud Developer Advocate, provides details for setting up a Google Apps Script project with the Google Vision API, using this service to perform optical character recognition on a user selected image.
Course evaluations can be a bit overwhelming when receiving mass amounts of feedback, but thanks to Apps Script this is a problem of the past. In this episode of Sheets to Apps, we’ll show you how to create and use an Apps Script for Google Sheets that allows you to respond to feedback on Google Forms via email.
In a recent episode of Sheets to Apps Ben Collins’ clever ‘Respond to feedback from students in a course’ in the G Suite Solutions Gallery is featured. See the YouTube video description for related links.
Need to share a variety of documents with vendors? Don’t want to share access one by one? In this episode of Sheets to Apps, we’ll cover how to use an Apps Script in a Google Sheet to automatically add members to a Google Group, helping you share documents at a large scale that will save you time.
We’ve previously shared the Medium post that provides more details for setting up this solution. If you missed that post or were unclear Alexandrina Garcia-Verdin, better known in the community as AGV, provides a very useful overview.
The code and other resources presented in this episode are available from the video description.
In this first episode of Apps Script in a Snap, Joanna Smith will go over what exactly Apps Script is and how you can use it to tailor any of G Suite’s productivity apps – such as Google Drive, Google Sheets, Google Docs, and Google Drive – to match and streamline your workflow.
The G Suite DevRel team have been busy. As well as AGV’s excellent Sheets to Apps series, some new videos are coming out from Joanna Smith in ‘Apps Script in a Snap!’. Currently these are very top level intro videos and it will be interesting to see where they go with this series.
In this episode of Sheets to Apps, we cover how to give newcomers access to resources via Google Forms and an Apps Script that lives in a Google Sheets, making on-boarding new employees simple and easy.
The code and other resources presented in this episode are available from the video description.
This post from Alexandrina Garcia-Verdin, better known in the community as AGV, highlights some of the benefits of the new Google Apps Script V8 runtime including succinct syntax and data processing operations:
Two years ago, our team began building custom software to automate the multi-stage and highly manual team staffing process. Building internal software has allowed the same-size Staffing Operations Team (3 members!) to enjoy a 60x reduction in time spent staffing each role.
The Apps Script ecosystem has emerged as the most critical component in our toolkit for building this internal software, due to its versatility and ease of deployment. We want to share how one piece of the staffing process has evolved to become more powerful over time thanks to Apps Script. Ultimately, we hope that sharing this journey enables all types of teams to build their own tools and unlock new possibilities.
On the G Suite YouTube channel you’ll find a new playlist for “why organizations build with Google Apps Script” which contains contributions from Cleo Espiritu, Ivan Kutil, Niek Waarbroek and myself. Hopefully these clips are useful in encouraging users to look at Google Apps Script as a powerful and agile development solution.