AppsScriptPulse

Add-on, Official News, Sheets

Build Apps Powered by Language with Semantic ML with the new Semantic Reactor Google Sheets Add-on

Tags:
| | 0 Comments |

In this post, I’ll show you how to use beginner-friendly ML tools–Semantic Reactor and TensorFlow.js–to build an app that’s powered by natural language.

NEW: Semantic Reactor has been officially released! Add it to Google Sheets here.

We’ve previously highlighted how TensorFlow.js can be used in Google Apps Script. In this latest example the new Semantic Reactor Google Sheets Add-on published by Google Research is highlighted. Semantic Reactor is designed to make it easier to start exploring Natural Language Understanding (NLU) and with this tutorial you can learn how you can deploy your model to code.

Source: Build Apps Powered by Language with Semantic ML

Official News, Solutions, Google Analytics, Sheets

How to build a Google Analytics Dashboard with Apps Script and Google Sites – Sheets to Apps

Tags:
| | 0 Comments |

Using Google Analytics and looking for a new way to aggregate, store, and efficiently organize the data from your website in a Google Sheet? In this episode of Sheets to Apps, we show you how to combine the Google Analytics add-on with Apps Script, resulting in the automation of cohesive data summaries that are compatible with Google Sites.

In this latest episode Alexandrina Garcia-Verdin demonstrates how the Google Analytics Add-on can be combined with macros to automate regular reporting. The video description has links to all the resources you need to set this up.

Whilst ‘Sheets to Apps’ videos are targeted at low/no coders as an Apps Script Developer I always find it useful to have a look at the code to see how it is done, as more often than not there will be a technique or method I’ve not come across. In the case of this example my new discovery was the .autoFill() and after browsing the documentation, .autoFillToNeighbor() methods in SpreadsheetApp. These methods allow you to replicate the auto-fill functionality users have in Google Sheets.

Another discovery was the various .setOption() calls when building the charts. I’ve used .setOption() in projects in the past and the issue I’ve had is navigating the long list of options you can use for various chart types. Using the macro recorder seems like a great way to capture all the options you want to add to your script project.

Official News

First look at the new Google Apps Script Integrated Development Environment (IDE) Script Editor – MASHe

Tags:
| | 0 Comments |

As part of Next OnAir week 2 the focus was on ‘Productivity and Collaboration’ Charles Maxson from the G Suite DevRel team not only provided some highlights from the week, but he also premiered the new Google Apps Script IDE.

This post includes a recording to a live demo of the new Google Apps Script editor. No news on when the new Script Editor will be generally available, but from the demo it looks like Google have focused on making it easier for developers to code and debug scripts.

Source: First look at the new Google Apps Script Integrated Development Environment (IDE) Script Editor – MASHe

Official News, Solutions, Sheets

How macros can be used to build Apps Scripts for cleaning data – Sheets to Apps

Tags:
| | 0 Comments |

Cleaning up data from downloaded accounting reports or from other systems can take up valuable time and resources. In this episode of Sheets to Apps, we’ll walk you through adding automation to your monthly Excel accounting data that records your steps into a script that you can run repeatedly with Google Sheets macro recorder.

From the video description you’ll find all the links you need to the example Google Sheet, instructions and more

Official News, Solutions, Web App

Getting started with the Google Vision API from G Suite | Google Cloud Blog

Tags:
| | 0 Comments |

The Google Cloud Vision API is a powerful tool that helps developers build apps with visual detection features, including image labelling, face and landmark detection, and optical character recognition (OCR). Getting started building with these services is relatively simple with Apps Script, as it uses simple REST calls to interact with the API directly, eliminating the need to set up SDKs or to download client libraries.

In this post Christian Schalk, Google Cloud Developer Advocate, provides details for setting up a Google Apps Script project with the Google Vision API, using this service to perform optical character recognition on a user selected image.

Source: Getting started with the Google Vision API from G Suite | Google Cloud Blog

Official News, Solutions, Forms, Gmail

Auto respond to feedback via Apps Script – Sheets to Apps

Tags:
| | 0 Comments |

Course evaluations can be a bit overwhelming when receiving mass amounts of feedback, but thanks to Apps Script this is a problem of the past. In this episode of Sheets to Apps, we’ll show you how to create and use an Apps Script for Google Sheets that allows you to respond to feedback on Google Forms via email.

In a recent episode of Sheets to Apps Ben Collins’ clever ‘Respond to feedback from students in a course’ in the G Suite  Solutions Gallery is featured. See the YouTube video description for related links.

Official News, Solutions, Groups, Sheets

Streamline access to resources for vendors via Google Sheet – Sheets to Apps

Tags:
| | 0 Comments |

Need to share a variety of documents with vendors? Don’t want to share access one by one? In this episode of Sheets to Apps, we’ll cover how to use an Apps Script in a Google Sheet to automatically add members to a Google Group, helping you share documents at a large scale that will save you time.

We’ve previously shared the Medium post that provides more details for setting up this solution. If you missed that post or were unclear Alexandrina Garcia-Verdin, better known in the community as AGV, provides a very useful overview.

The code and other resources presented in this episode are available from the video description.

Official News

Overview of the power of Apps Script – Apps Script in a Snap

Tags:
| | 0 Comments |

In this first episode of Apps Script in a Snap, Joanna Smith will go over what exactly Apps Script is and how you can use it to tailor any of G Suite’s productivity apps – such as Google Drive, Google Sheets, Google Docs, and Google Drive – to match and streamline your workflow.

The G Suite DevRel team have been busy. As well as AGV’s excellent Sheets to Apps series, some new videos are coming out from Joanna Smith in ‘Apps Script in a Snap!’. Currently these are very top level intro videos and it will be interesting to see where they go with this series.

Official News, Solutions, Forms, Sheets

Automate onboarding of company resources from a Google Sheet – Sheets to Apps

Tags:
| | 0 Comments |

In this episode of Sheets to Apps, we cover how to give newcomers access to resources via Google Forms and an Apps Script that lives in a Google Sheets, making on-boarding new employees simple and easy.

The code and other resources presented in this episode are available from the video description.

Official News, V8

Apps Script’s new V8 runtime | Google Cloud Blog

Tags:
| | 0 Comments |

This update to Apps Script lets users take advantage of modern JavaScript features and enhances new or existing scripts with less verbose, more standardized code.

This post from Alexandrina Garcia-Verdin, better known in the community as AGV, highlights some of the benefits of the new Google Apps Script V8 runtime including succinct syntax and data processing operations: map(), filter() and reduce(). As part this AGV also highlights some of the resources from Ben Collins and Amit Agarwal put together to support the community transition to V8. A nice feature of this post from AGV is side-by-side comparisons of old and new JavaScript syntax:

Image source: Google

Source: Apps Script’s new V8 runtime | Google Cloud Blog