AppsScriptPulse

Totally Unscripted: How SADA builds on Google Workspace – 3rd November at 1200 PDT / 1500 EDT / 1900 GMT

Totally Unscripted returns on 03 November at 1200 PDT / 1500 EDT / 1900 GMT (earlier time for those not watching in North America), this time joined by guests Kelly Wright (Director of Google Workspace, SADA) and Kevin Tuuri (Solutions Architect, SADA):

SADA is a Google Cloud Premier Partner that focuses on Google Cloud consulting, migration and deployment, custom development, user adoption, and change management services. As an industry leader in helping organizations implement Google Workspace, SADA has developed a practice area that builds custom solutions as unique as their customers. In this episode of Totally Unscripted, we will hear from Kelly Wright, Director of Google Workspace, and Kevin Tuuri, Solutions Architect, about how they help customers get more out of Google Workspace by customizing they way they use it. This episode will be broadcast live and you can join the conversation in the YouTube Live chat. – https://youtu.be/b_wiI8InwC0

Totally Unscripted: The Pulse of the Google Apps Script Community WEDNESDAY 27 October at 1200 PDT / 1500 EDT / 2000 GMT+1

The AppsScriptPulse website was launched in 2019, providing a curated collection of the latest Google Apps Script contributions from both Google, but focusing on community contributions. The site now has over 600 solutions, snippets, tutorials and resources updated almost daily. In this episode of Totally Unscripted we are joined by Romain Vialard, Phil Bainbridge and Scott ‘Yagi’ Donald who have individually provided the top 3 Pulse contributions for 2021.

We will discuss the solutions they have created which range from offline Apps Script development with VS Code/clasp to document automation to creating games in Google Slides. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

Celebrating 1,000 posts by Bruce Mcpherson (@brucemcpherson)

Google Apps Script Meetup at Google Cloud Next '18
Google Apps Script Meetup at Google Cloud Next ’18

I’m sure many in the Google Workspace developer community will know the name Bruce Mcpherson and his website https://ramblings.mcpher.com/. There are very few people who can say they have written the book on Google Apps Script and Bruce is one of them with his O’Reilly publication ‘Going GAS’.

At Pulse we recently discovered that Bruce was getting close to his 1,000th post. This milestone has now been reached with Bruce’s latest contribution ‘Creating a connector for Data Studio‘. To help mark this achievement we got in touch with some of the many ‘Bruce fans’ to reflect on Bruce’s work to date and the impact it has had on their own work.

If you would like to add your own comment feel free to use the comments section.


Laura Taylor – Google Workspace GDE

Bruce Mcpherson is one of the most prolific technical writers I’ve ever encountered.  His intricate systems knowledge along with his unique writing style make for very fascinating and helpful reading.  Not only is Bruce a prolific writer but also a prolific developer, contributing a number of open source libraries many of which are used daily in the Apps Script ecosystem.  A great debt of gratitude is owed Bruce as he has shared his knowledge with so many.  Thank you, Bruce, for your service to the Apps Script community.

Ben Collins – Google Workspace GDE

When I moved from the Microsoft world to the Google world, around 2014, there was one site I kept landing on… and that was Bruce’s! I remember early in my Google Workspace and Apps Script journey, when I was in over my head with a client project, I emailed Bruce to ask if I could use one of his many libraries in the project. He quickly replied “of course!” and proceeded to help me with a few questions I had too. I had the great pleasure of meeting Bruce in person at Next 2019 and he’s a wonderful character with many great stories. We’re lucky to have Bruce as our talisman in the Google Workspace developer group. Cheers to the next 1,000!

Eric Koleda – Former Google Developer Relations

Bruce has been a pillar of the Apps Script community for years, and hitting 1000 posts is but one sign of his love and dedication to the productivity space. My favorite post of Bruce’s ( although it’s so much more than a post) is about cGoa, an OAuth2 library for Apps Script. When the Apps Script engineering team released the /usercallback endpoint they imagined many developers building their own OAuth2 code, but I think Bruce may have been the only person not employed by Google to wade into the murky waters of implementing an authorization library. Throughout this project and others Bruce has always focussed on usability and making sure that users could get to working code quickly. Congratulations Bruce!

Chanel Greco – Google Workspace GDE

I really appreciate how Bruce actively shares his Apps Script knowledge with others through his blog, his books or by answering questions on the different community platforms. 

When searching for something Apps Script related, sooner or later, you’ll land on one of Bruce’s many resources. Many of us have developed our own Apps Script skills thanks to his contributions.

Thank you Bruce!

Charles Maxson – Google Developer Relations

Congratulations on 1,000 posts Bruce! (and THANK YOU from everyone who’s ever tried to use Apps Script – your work has no doubt been discovered and essential for all!)

I myself ‘met’ Bruce through his book “Going GAS: From VBA to Google Apps Script” where he became my personal interpreter in translating my years of Office VBA knowledge into Google Apps Script. As one of the original pioneers who started building solutions on Google Apps G Suite Workspace, what’s amazing is how Bruce has continued to give back to the community by sharing posts, libraries, videos, insights and expertise for such a long time. Having the privilege to work with Bruce now as a Google Developer Expert, he continues to amaze me how much knowledge he’s amassed and still humbly shares as regularly as ever.

Looking forward to you rambling on for another 1,000 Bruce!!!

Anu Srivastava – Google Developer Relations

Thank you so much for all your content! Especially for helping out the Apps Script community!

Clark Lind – Google Apps Suite Workspace GDE Hack

Thank you Bruce for all you have done for the GAS community. You have had worldwide impact and influence and continue to do so. I hope you continue influencing the next generation of scripters coming along. I’ve copied  learned so much from you over the years, it has helped me in my own work and career. You have shown me just how much there is to learn, and how much I don’t know. ;)

Thank you!

Adam Morris — Google Developer Expert & Integrations Director @ Faria Education Group

I like writing libraries, but what I like even more is not having to write them. It’s a grand world indeed that we live in our current universe where we can run into problems and challenges in code, and embark on a journey that leads us to individuals such as yourself, who by their very prolific endeavours establish an even grander world. Thank you.

Andrew Roberts – Freelance Dev and Google Wordspace GDE

One of the true stalwarts of the Apps Script community, Bruce has been an inspiration and endless source of knowledge for the many years I have been involved in Apps Script. Back in my early days of having to Google for how to do most things, Bruce’s site was inevitably the site I’d end up at. The guy literally wrote the book! Almost getting to 1000s posts is an amazing achievement.

Bruce publishing a list of his libraries inspired me to trawl the web and compile an automatically updating list of other Apps Script libraries I could find. Although Bruce’s still make up the vast majority of those available.

The post that particularly stands out for me, and I had lots of fun deploying, was on parallel processing with Apps Script to get around the execution limit. It even displays a funky little graph you can watch.

Thanks again Bruce for your continued support and contributions. 

Riël Notermans – Google Developer Expert and company owner of Zzapps, a Workspace reseller

Me, Martin and Bruce.

There are some people that I always look forward to seeing and to spend time with. Bruce is well in that list ;) Actually it has been for too long. 

Hanging out in real life or virtually discussing some features that work great or not, or listening to what Bruce has to say about, well, anything, it is a great experience. Professionally I would not know where to begin the ‘thank you’s’, but one of the most recent is with Bruce ‘mentoring’ me on a Kubernetes project. I got a kickstart in understanding the concepts, together with Bruce pieces of great code and his well-known ramblings really got me going. Congrats Bruce and looking forward to meet again!

Amit Agarwal – Founder @ Digital Inspiration and Workspace GDE

Thank you Bruce for your amazing contributions to the Google community. You cannot imagine how much impact your work has had on the lives of so many developers worldwide. Personally, I have admired your coding style and learnt so much by looking at your work. Thank you again!

Martin Hawksey – University of Edinburgh and Google Workspace GDE 

It’s hard to say exactly when I started following Bruce’s work, but one of the first posts I reshared was Managing Libraries with Google Apps Script from June 2012. Managing libraries is a very fitting way to celebrate Bruce’s contribution to the Google Apps Script community. Using his own Github/AppsScript visualisation tool you can explore the 100+ Google Apps Script repos, including libraries, Bruce has shared

One library that I’ve used a lot in my own work is cGoa, which lets you do OAuth2 for Apps Script in a few lines of code. There are a couple of other OAuth2 libraries, but as someone also writing about Google Apps Script solutions, the cGoa setup is straightforward and easy for others to follow. From one post from Bruce it has featured in six of my own, an example of the value of Bruce’s ‘ramblings’ to the community.

Thank you Bruce!

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