AppsScriptPulse

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