AppsScriptPulse

TU4.6: Life After Apps Script – A chat with Eric Koleda (@erickoleda), Developer Advocate @ Coda Live TUESDAY 19 Oct. at 1200 PDT / 1500 EDT / 2000 GMT+1

In this episode of Totally Unscripted, we will catch up with Eric Koleda who has been a well known fixture to Google Workspace Developers for the better part of a decade. Now that his legendary career as a Google Workspace Developer Relations Engineer has come to a close, we will reminisce with Eric about the impact of Apps Script and how Workspace development has evolved. We will also take a look at the future and get some insights about his new role and the breakthrough technology at Coda, where he’s begun his new life after Apps Script.

This episode will be broadcast live TUESDAY 19 Oct. at 1200 PDT / 1500 EDT / 2000 GMT+1 and you can join the conversation in the YouTube Live chat.

Totally Unscripted: Introducing the new Google Workspace Forms API! – Live 13 Oct. at 1200 PDT / 1500 EDT / 2000 GMT+1

Google Workspace offers developers REST APIs to interact programmatically with nearly every product and feature within the suite. In this episode of Totally Unscripted, we are going to take a first look at a BRAND NEW API for Workspace that is being announced earlier in the day at Google Cloud Next. Curious what that API is? Tune in to the broadcast live where we are joined by guests Christian Schalk (Developer Advocate, Google) and Hannah Pho (Software Engineer, Google) along with early Forms API partners Charles Kemp (Strategic Alliances Manager, Zapier) and Charles Wiles (CEO, Zzish) to find out and you can join the conversation in the YouTube Live chat.

What is Google’s Dev Library––a new open-source platform for developers

Image credit: Google

Developers worldwide are creating open-source tools and tutorials; however, they have difficulty getting them discovered. The content published often spanned on many different sites—from GitHub to Medium. Therefore Google decided to create a space where the best projects related to Google technologies can be highlighted in one place—introducing the Dev Library, a curated archive of projects and articles built specifically using Google technologies.

For Google Apps Script community contributors here’s an opportunity to submit some of your work to be showcased in Google’s new Dev Library:

Not all the articles or projects submitted by you, get on the site! A team of Google experts look for accuracy and relevancy in each featured piece, so you know when you view the content on the site, it has the stamp of approval from Google.

Source: What is Google’s Dev Library––a new open-source platform for developers

Next ‘21: Must-see Google Workspace sessions for developers and creators #GoogleCloudNext

Image credit: Google

Google Workspace offers a broad set of tools and capabilities that empowers creators and developers of all experience levels to build a wide range of custom productivity solutions. For professional developers looking to integrate their own app experiences into Workspace, the platform enables deep integrations with frameworks like Google Workspace Add-ons and Chat apps, as well as deep access to the full suite of Google Workspace apps via numerous REST APIs. And for citizen developers on the business side or developers looking to build solutions quickly and easily, tools like Apps Script and AppSheet make it simple to customize, extend, and automate workflows directly within Google Workspace.

At Next ‘21 we have 7 sessions you won’t want to miss that cover the breadth of the platform. From no-code and low-code solutions to content for developers looking to publish in the Google Workspace Marketplace and reach the more than 3 billion users in Workspace, Next ‘21 has something for everyone.

Click through to the source to read more about the must-see Google Workspace sessions for developers and creators.

Source: Next ‘21: Must-see Google Workspace sessions for developers and creators

Totally Unscripted: Never lost for Words – The art of building Google Workspace Developer Documentation – Live 06 Oct. at 1200 PDT / 1500 EDT / 2000 GMT+1

Imagine trying to be a successful developer without good documentation? Yet as developers, we often don’t admit how lost we would be without it. Truth is, creating and maintaining developer documentation is an art; Developers demand content that is concise, but thorough; simple to find and up to date, while covering every obscure feature ever released. If developing a solution is a journey for developers, it’s technical writers who are the unsung heroes who guide us to success with their thoughtful art. In this episode of Totally Unscripted, Kara Ireland and Nathan Gammie will join us from the Google Workspace Developers documentation team, who will give a glimpse into how their team creates the content that keeps Workspace developers on a journey to success. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

This episode is a great opportunity to find out how to develop clear and concise documentation. As well as discovering some of the processes behind the scenes of the Google Workspace Developers documentation you can join the live show YouTube chat to ask questions and become a better technical writer.

DocuSign Developer Conference – 26-27 October 2021 [online]

DocuSign Developer ConferenceLearn, share and create the future of agreements at DocuSign’s first developer conference.

As part of our next Totally Unscripted episode we’ll be joined by Jeremy Glassenberg (Product, DocuSign) and Nima Poulad (Senior Software Engineer, DocuSign) to talk about how to Create your approvals hub by bringing DocuSign into Google Workspace (Broadcast live 29 Sept. at 1200 PDT / 1500 EDT / 2000 GMT+1).

If building on the DocuSign platform is something that you want to find out more about, there is a great opportunity to learn more at the DocuSign Developer Conference 26-27 October. The agenda includes a range of sessions where you can learn about integrations, including a session from TU regular Christian Schalk, on Building a DocuSign Apps Script Library. Follow the source link for more details and how to register for free!

Source: DocuSign Developer Conference

Totally Unscripted: Create your approvals hub by bringing DocuSign into Google Workspace – Live 29 Sept. at 1200 PDT / 1500 EDT / 2000 GMT+1

If you have had to electronically sign a document before you are likely to be one of the 200+ users who have used DocuSign. DocuSign provides a suite of services to support the entire contract lifecycle from eSignature to automation to analysis. Whilst DocuSign has its own full range of services and integrations DocuSign developers and partners build the customized and integrated experiences that account for roughly 60% of all of DocuSign’s transactions. In this episode of Totally Unscripted we are joined by Jeremy Glassenberg Product Leader, APIs at DocuSign. Jermey will provide an overview of DocuSign APIs and opportunities to integrate with Google Workspace. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

Show Live/Recording link – https://www.youtube.com/watch?v=EtSSzTH6yLc

Totally Unscripted – Automating your workflows with Document AI – 22 September at 1200 PDT / 1500 EDT / 2000 GMT+1

We are back with another episode of Totally Unscripted this time joined by Anu Srivastava, Senior Developer Programs Engineer, Google Cloud. As part of this show we are looking at Document AI, one of the latest Google services that lets you do magical things with scanned document images:

Document AI uses machine learning on a scalable cloud-based platform to help your organization efficiently scan, analyze, and understand documents. Manually inputting invoices, receipts, and expenses can be time-consuming, but it doesn’t have to be. The Procurement Document AI is a tool that allows you to digitize unstructured content into structured data. This is just one of the many scenarios where Document AI can be used to develop smart workflows. In this episode of Totally Unscripted we are joined by Anu Srivastava, Senior Developer Programs Engineer, Google Cloud, who will show how Document AI can be used to automate a range of workflows. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

We ‘air’ at 1200 PDT / 1500 EDT / 2000 GMT+1 on Wednesday, with the recording immediately available – https://youtu.be/_KeRNBcz_4w .

Totally Unscripted – Wholly Sheets: Tips for building productivity solutions with Google Sheets 15 September at 1200 PDT / 1500 EDT / 2000 GMT+1

The Google Workspace developer community show, Totally Unscripted, is back this Wednesday! We’ll be broadcasting live at the usual time 1200 PDT / 1500 EDT / 2000 GMT+1 with Wednesday’s targeted as our new ‘day’.

For our return we’ll be bringing you an episode on ‘Wholly Sheets: Tips for building productivity solutions with Google Sheets’. Tune in live to ask questions or immediately watch the recording on demand.

Full show description below:

Spreadsheets are the swiss army knife of productivity tools where they are used (and sometimes misused) as databases, workflow engines, project management tools, custom calculators, and oh yeah… spreadsheets. In this episode of Totally Unscripted, we will chat with Jonathan Butler, Software Engineer at Viriya Consulting, and Spencer Farris, a Google Sheets & Apps Script Consultant, about how they are build spreadsheet solutions that range from small problem-solving automations to full blown critical applications.

Guests:

Mergo – Mail Merge for Gmail – A free lifetime subscription for Google Workspace for Education users

As teachers gear up for the new school year, we’re glad to offer a free lifetime subscription to your school, college or university. 🥳

I’m sure many of you have come across Romain Vialard who has been contributing to the Google Apps Script community since the product was in beta.

Mergo, Mail Merge for Gmail, is one of the latest products to be developed by Romain and for Google Workspace for Education users the great news is that until the 20 September 2021 there is an offer for a free lifetime subscription! Follow the source link for more details.

Source: Mergo – Mail Merge for Gmail – Back to school

Google Workspace Developers can now connect in the Google Cloud Communities

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.

Source: Google Workspace Developers 

Top tech blogger Amit Agarwal on building a global content business for over 15 years

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.

Source: Top tech blogger Amit Agarwal on building a global content business for over 15 years

Google Apps Script: A Beginner’s Guide

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.

Source: Google Apps Script: A Beginner’s Guide

Totally Unscripted – Automation for Admins: Command line management for Google Workspace with GAM Thur 15 July at 1200 PDT / 1500 EDT / 2000 GMT+1

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.

Join the conversation on Thursday 15 July 2021 at 1200 PDT / 1500 EDT / 2000 GMT+1 – https://youtu.be/7lPGbScRNk8

For previous episodes, information and resources visit https://tu.appsscript.info/

Google Apps Script – What a difference 5 years make – Episode 2 [Property Service and Spreadsheet Service updates] – Desktop Liberation

Image credit: Bruce Mcpherson

Image credit: Bruce Mcpherson

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 PropertiesService and SpreadsheetApp . 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!

Source: Google Apps Script – What a difference 5 years make – Episode 2 – Desktop Liberation

Google Apps Script – What a difference 5 years make – Desktop Liberation

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.

Source: Google Apps Script – What a difference 5 years make – Desktop Liberation

Going GAS – Book preview on Google Books

Image credit: O'Reilly

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.

Bruce Mcpherson the author of Going Gas has recently highlighted in the Google Apps Script Community that a chuck of his book is currently available for free in the Google Books preview (133 of the 456 pages are available). Bruce highlights that since publication in 2016 there have been a number of changes in Google Apps Script most notably the move to modern JavaScript syntax in the V8 engine, but much of the content may still be of interest.

Source: Going GAS

Totally Unscripted: Developing a market leading Google Workspace Add-on – Behind the scenes @Supermetrics Thur 10 June at 1200 PDT / 1500 EDT / 2000 GMT+1

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!

For previous episodes, information and resources visit https://tu.appsscript.info/

Totally Unscripted: Developing Google Workspace workflows with AppSheet Automation Thur 27 May at 1200 PDT / 1500 EDT / 2000 GMT+1

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.

For previous episodes, information and resources visit https://tu.appsscript.info/

Totally Unscripted: Managing Google Apps Script applications in large enterprise environments Thur 13 May at 1200 PDT / 1500 EDT / 2000 GMT+1

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.

You can tune in live to ask questions via https://youtu.be/N5zmeEsG2uw

For previous episodes, information and resources visit https://tu.appsscript.info/

A new approach for limiting access to a part of a Google Apps Script Web App

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.

Source: A new approach for limiting access to a part of a Google Apps Script Web App – Google Groups

Totally Unscripted: Hello Alternate Runtimes – How to build Google Workspace Add-ons without using Apps Script – Thur 22 April at at 1200 PDT / 1500 EDT / 2000 GMT+1

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.

Tune in live to ask questions via the YouTube chat https://youtu.be/zDZqENU4B6s

For previous episodes, information and resources visit https://tu.appsscript.info/

Totally Unscripted: Google Apps Script – Discover, Learn and Share Thur 15 April at at 1200 PDT / 1500 EDT / 2000 GMT+1

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.

Tune in live to contribute to the YouTube live chat (recording immediately available). – https://youtu.be/pvwwr2dLkdA

For previous episodes, information and resources visit https://tu.appsscript.info/

Totally Unscripted: Chatting with the community – Google Chat tips from GDEs Laura Taylor and Denis Valášek – Thur 08 April at at 1200 PDT / 1500 EDT / 2000 GMT+1

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.

Tune in live to contribute to the YouTube live chat (recording immediately available). – https://youtu.be/mtDsScbfRIU

For previous episodes, information and resources visit https://tu.appsscript.info/

🎂 Happy anniversary Google add-ons! 🎂 Long live MERGO the new mail merge add-on from @romain_vialard

Ain’t no party like a mail merge party and Romain Vialard knows how to celebrate!

Find and clone Apps Script projects from GitHub directly into the IDE with scrviz – Desktop Liberation

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:

Source: Find and clone Apps Script projects from github directly into the IDE with scrviz – Desktop Liberation

Modern Angular in Google Workspace Editor Add-ons

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.

We recently had the author of this post, Spencer Easton, on an episode of Totally Unscripted to talk about this topic. This companion post provides an overview of using Angular for Add-on development. There is a cost associated with this solution has separate hosting is required for the Webpacks, but as covered by Spencer the cost is low (for a 100K+ users add-on the cost is $8/month).

Source: Modern Angular in Google Workspace Editor Add-ons

A SyntaxHighlighter Evolved WordPress plugin for Google Apps Script contributors

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.

Source: A SyntaxHighlighter Evolved WordPress plugin for Google Apps Script contributors

Subscribe to Apps Script Pulse...