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.
In a conversation with YourStory, top tech blogger Amit Agarwal shares the secrets to building a global content business from Bharat.
Many of you will no doubt seen and used Amit’s Google Apps Script contributions published on labnol.org. This interview with Amit is an opportunity to hear/read more about his background and motivations.
With Apps Script, you can do cool stuff like automating repetitive tasks, creating documents, emailing people automatically and connecting your Google Sheets to other services you use.
This Google Apps Script introductory post from Ben Collins has been around for a while, but worth keeping in the old link locker as it summarises lots of useful information and links. Click through to the source for more details.
In this episode of Totally Unscripted we are joined by Jay Lee, creator of Google Apps Manager (GAM). GAM is an open source command line tool for Linux, MacOS and Windows which allows administrators to easily manage domain and user settings in Google Workspace. GAM is particularly useful for running bulk operations running commands in parallel from a text or .csv file. This episode will be an opportunity to find out how you can start automating your Google Workspace administration as well as some of the newer GAM features including creating a GAM powered Google Chat Bot.
How google apps script has changed over the past 5 years. Episode 2 in a series of post covers the Properties Service and the Spreadsheet service
Bruce Mcpherson continues his look at changes in Google Apps Script over the last 5 years, this time looking at
. This post is worth a read just to check you’ve not missed any new methods for working with Google Sheets, because over the last 5 years there have been many!
It’s been over 5 years since my book ‘Going Gas‘ was published, and Apps Script evolution means that a number of sections of it is now pretty out of date. I don’t think I have the energy to do a rewrite – so I’m going to do a critique, chapter by chapter, of where it’s now wrong as a way to show how much Apps Script has improved (or otherewise) over the years.
We recently highlighted how you could preview excerpts from Bruce Mcpherson’s ‘Going GAS’ book. Bruce has now followed up by using the book contents from 2016 to highlight differences in the current version of Google Apps Script.
Whether you’re moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.
Over half a million people, including marketers, data analysts, and data engineers, use Supermetrics to move data from popular marketing platforms (such as Facebook, Google Ads, and HubSpot) to Google Sheets, Google Data Studio and other destinations. With 10% of global online ad spend reported through Supermetrics and a growing distributed product engineering team, management and testing of their Apps Script deployments is key. In this episode of Totally Unscripted we speak to Supermetrics founder, CEO (and Apps Script developer), Mikael Thuneberg, and Supermetrics senior software developer James Elderfield to find out about Supermetrics development infrastructure and approaches to testing and monitoring.
Find out how to developing a market leading Google Workspace Add-on at 1200 PDT / 1500 EDT / 2000 GMT+1 on Thursday 10 June 2021 and tune in live to join the conversation with our guest!
We are back and for the next episode of Totally Unscripted revisiting Google no/low code application development platform AppSheet. We are joined by Christian Schalk (Developer Advocate, Google Cloud) to look at the new AppSheet Automation, which uses Google AI to make it easier to automate business processes.
By making it easier to automate processes, AppSheet Automation helps users reduce IT overheads and save money. Automation also includes the ability to build and embed rich AppSheet views in Gmail to perform approvals on the go.
Tune in live to find out everything a Google Workspace developer needs to know about this and other new features in AppSheet.
Totally Unscripted is back on the 13 May at the usual time (1200 PDT / 1500 EDT / 2000 GMT+1) and in this episode we look at Managing Google Apps Script applications in large enterprise environments. In this episode we are joined by Niek Waarbroek (CTO & Partner at NextNovate) and Jasper Duizendstra (Google Cloud Architect at duizendstra.com) who will share their approaches for managing the design, development and support process for the applications they build for their customers. As part of this show Jasper will also demonstrate his fully serverless, continuous delivery pipeline based on the Cloud IDE, Cloud Source Repositories, Cloud Build, git and clasp.
I’ve noticed that several Google Apps Script users are looking for a secure way to restrict access to their Web App. In my case I am looking for a way to let everyone have access to some functions of the web app, while a control panel must be reserved for the administrator (me).
I wanted to share my approach that makes use of the novelty introduced in GAS on March 15, 2021.
Interesting thread in the Google Apps Script Google Group community discussing approaches to creating Web Apps with admin interfaces. Follow the source link for more information and the full discussion.
Last month Google announced the general availability of alternate runtimes for Google Workspace Add-ons. With alternative runtimes, developers can write Add-ons in any language and on any infrastructure, and then publish them to the Google Workspace Marketplace. In this episode we are joined by Riël Notermans, owner of Zzapps (and Google Developer Expert) and Steven Bazyl (Developer Relations, Google Cloud). Riël, whose teams have been developing on Google Workspace for over a decade, will share his team’s key takeaways on Alternate Runtimes and Steven will provide additional tips on getting started including the GWAO Card Builder.
In this episode we are going to delve into the topic of how you discover, learn and can share Google Apps Script projects, tips and tricks. We hope we can give you some useful advice if you, friends and colleagues are just starting out coding with Apps Script, or tips if you have been coding for a while and want to improve your Apps Script knowledge. For this episode we’ve got two great guest Chanel Greco – saperis (Founder & CEO) and regular Apps Script contributor Bruce Mcpherson, who’s recent work on the visual Google Apps Script explorer tool, scrviz, is providing developers with new ways to explore and replicate existing Apps Script projects.
In this episode of Totally Unscripted we are joined by Google Developers Experts Laura Taylor and Denis Valášek to talk about Google Chat and opportunities to develop Google Chat bots and conversational interfaces with Google Dialogflow. We’ll cover everything that you need to know to get started, opportunities and pitfalls.
I thought it might be useful if you are learning Apps Script to be able to pull in examples to play around with. This latest release adds the ability to configure and clone projects from github directly into the Apps Script IDE.
We’ve previously highlighted Bruce Mcpherson’s visual Google Apps Script explorer tool, ‘scrviz’. If you are not familiar with this it is Bruce has figured a way to search and identify Google Apps Script projects publicly shared on GitHub. In this latest update to the tool you can now clone public Google Apps Script projects from scrviz straight into the Apps Script IDE.
The source link explains more about how you can do this:
I intend this post for established Add-on developers who want to use Angular in Google Workspace editor Add-ons and Google Apps Script webapps. This does not attempt to show how to create Add-ons or Angular apps, but the tooling and build process to use Angular apps in Add-ons. I am also assuming familiarity with installing and using CLI tools in your development workflow.
With my published content I like to include useful code snippets. As I published on a self-hosted WordPress blog I’ve used plugins to help format the code to make it easier to understand and also aesthetically look nice. In this post I share a WordPress plugin I’ve developed for Google Apps Script syntax highlighting.
We all love the flexibility
gives us when developing Google Workspace Editor Add-ons, but what happens when you need to scale your production? Web application frameworks provide a way to deploy and develop your code in a structured way making it easier to maintain your code base. Angular is one open-source web application framework that can be used to modernize your Workspace Editor Add-on development. In this episode we are joined by Spencer Easton who will share how Amplified IT have adopted Angular for their Add-on development. As part of this we will explore the benefits using Angular including a component-based architecture, internationalization and performance.
Attackers are abusing Google’s Apps Script business application development platform to steal credit card information submitted by customers of e-commerce websites while shopping online.
Interesting report highlighting how Google Apps Script is being exploited as a vector to skim card data. The post is worth reading for more details but in short the script.google.com address for webapps is being used as a trusted domain to avoid detection. The post also mentions how Google Analytics is being used for a similar exploit. How this will all play out is yet to be seen.
Totally Unscripted is back on Thur 11 Feb at 1200 PST / 1500 EST / 2000 UTC and in this episode we we look at no-code solutions for Google Workspace automation. As part of this we are joined by no-code and automation experts Vahid Taslimi and Aravin Srinivasan from zenphi. Zenphi is a no-code business process automation platform, designed from the ground up for Google Workspace. With Vahid and Aravin we will see how zenphi can be used to automate processes such as Mail Merge to more advanced multi-step approval processes. As part of the show we will learn how they have approached the challenge to support users in taking more ownership of their business processes.
Tune in live to contribute to the YouTube live chat (recording immediately available).
Totally Unscripted is back on 04 Feb at the slightly earlier time of 0800 PST / 1100 EST / 1600 UTC.
In this episode we are joined by some of the team at Google behind the development of the Macro Converter. The Macro Converter is an add-on that makes it easier to convert Excel files that have Visual Basic for Applications (VBA) code to Google Sheets files and Apps Script. You can use the Macro Converter add-on to determine the compatibility of your files and automatically convert them.
This show is your opportunity to learn more about Macro Converter and get your questions in to the developers. Tune in live to contribute to the YouTube live chat (recording immediately available).
Totally Unscripted is back on Thur 28 Jan at 1200 PST / 1500 EST / 2000 UTC and in this episode we will explore how Google Apps Script is supporting educators around the world to become more productive and efficient. From grading quizzes to administering class rosters and everything in between, Apps Script can be used to help educators save time in the administration of teaching and learning and spend more time with their students.
For this episode we are joined by noted teacher and Apps Script creator Alice Keeler (alicekeeler.com) as well as Dave Abouav who is a Google Employee and part-time physics teacher and the creator of the popular grading tool Flubaroo. With Alice and Dave we will discover some of the opportunities for using Google Apps Script in education as an end user and developer.
Tune in live to contribute to the YouTube live chat (recording immediately available).
There are so many Apps Script projects out there where the source code is published on Github, but it’s hard to find what you want. Whether it’s a library, an example of an add-on, how to use an advanced service, or just see who is working on what. I figured it would be nice if we had a searchable visualization of everything that’s public.
Totally Unscripted is back again on Thur 21 Jan at 1200 PST / 1500 EST / 2000 GMT. This time we will be joined by Jon Harmer (Product Manager, Google Workspace) and Steve Bazyl (Developer Relations, Google Cloud) who will give an overview of how you can start using AMP with your Google Workspace Gmail users and beyond.
Unfamiliar with AMP for email? This “allows senders to include AMP components inside rich engaging emails, making modern app functionality available within email. This dynamic email format provides a subset of AMPHTML components for use in email messages, that allows recipients of AMP emails to interact dynamically with content directly in the message” [ref]
Tune in live to contribute to the YouTube live chat (recording immediately available)
Year vs. number of Questioners and Answerers. These all questions include the tag of “google-apps-script” in the tags
Trend of google-apps-script Tag on Stackoverflow 2021
Kanshi Tanaike returns with an updated look at trends in the [
] tag on Stackoverflow. A highlight from the report is the continued growth in new questioners, indicating that the Google Apps Script community is continuing to grow.
The cloud giant is offering 30 days of free training and routes to certification.
Budding learners can access all of these through a set of ‘skills challenges’ which give participants greater knowledge of each subject and a chance to earn a Google skill badge to prove their competency.
Participants will have 30 days of free access to Google Cloud Labs to work their way through four skill challenges: ‘Getting Started’, ‘Data Analytics’, Hybrid and Multi-cloud’ and finally ‘Machine learning and Artificial Intelligence’.
The Data Analytics course is for more experienced participants to expand their skills into AI and machine learning with a chance to demonstrate an understanding of BigQuery. They can learn how to do everything from writing and troubleshooting SQL queries and using Apps Script, to building classification and forecasting models.
IT PRO has picked up on some free training from Google, which includes an opportunity to use your Google Apps Script knowledge in the Data Analytics course. To start the challenges you need to register by January 31, 2021, 11:59 PT.