SW gApps LLC is hosting a G Suite and automaton training conference for organizations who have invested in Google’s productivity software known as G Suite. Send your associates to be more equipped and productive!
SW gApps LLC which is run by long time Google Apps Script contributor Steve Webster is running a two day training event for anyone interested in G Suite. Speakers and trainers include James Ferreira (Google, G Suite Specialist), Alexandrina Garcia-Verdin (Google, G Suite Developer Advocate [remote]) Ben Collins (Google Developer Expert and Google Sheets Developer & Data Analytics Instructor) as well as Steve Webster and Eric Schwartz from SW gApps LLC. There is an early bird registration available until February for either attending in-person or a reduced fee for remote attendees. You can follow the source link for more details.
Source: G Suite Training & Automation
I finished my free book on Apps Script by a long chapter about “Google Assistant with Apps Script”.
I’m often asked for resources to help people with getting started in Google Apps Script. Noted French computer scientist Jacques Chazarain has published a free ebook which looks like an ideal resource and is available in both French and English.
Source: [Promo] Free book: “Introduction to Google Apps Script” – Google Groups
QUERYX allows you to use sql queries in sheets.
Those familiar with Google Sheets will probably want to know how this is different to the built-in
QUERY() function, the answer is this is add-on enables a full SQL. Following the source link gives information on how to access this add-on.
Source: [PROMO] QUERYX allows you to use sql queries in sheets. – Google Groups
Peter Whitehead is Head of Mathematics in a large Further Education College in London, UK and has started a blog sharing “Google Apps Script code that will make life easier for teachers, educational managers and educational IT support”.
You can follow Peter’s work at www.gas4edu.com
Guest post by Thomas Coudray, Amaury de la Vieuville, and Ahmed Bougacha. Thomas, Amaury, and Ahmed attended the Google Apps Script Hackathon in Paris, and in this post they are sharing their creative use of Google Apps Script to render a 3D scene in a Google Spreadsheet
An old project but hopefully something nice to delve into for the weekend…
Source: G Suite Developers Blog: Sheetcaster: 3D in Apps Script
The usual list of links to interesting resources for Google Apps Script – contributorpw/google-apps-script-awesome-list
Alexander Ivanov has been curating this amzing list of Google Apps Script related resources for a number of years. The list includes links to a number of useful resources, cool Apps Script code projects, libraries and more. If you have a suggestion for the ‘awesome list’ you can open an issue ticket.
Summary of posts by other G Suite GDEs highlighting announcements from Google Next ’19
Source: G Suite, Apps Script and App Maker posts from Google Next ’19 – MASHe
Stéphane Giron provides a useful list of G Suite related beta programs announced at Google Next 19
Source: All Google G Suite Beta programs from Google Next ’19 to Now
What’s been happening in Apps Script … The modernization of the Sheets API and the Calendar API, the release of the Slides API and most recently the Docs API have all opened up many new capabilities for Apps Script regular and advanced services. The Docs API does not yet have an advanced service so you need to go to the API directly, but as with Sheets and Slides, over time you’ll probably see one arriving along with some of the more advanced features being integrated into the regular Apps Script service. Let’s look at a few of the new goodies (and not-so goodies).
Source: 2018 – yet another year in and out of Google Apps Script | Desktop Liberation