AppsScriptPulse

Automating Academic Reviewer Finding With Microsoft Academic and Google Apps Script

One of the big problems today is finding reviewers. Editors are limited by their own knowledge and various publicly-available datasets (such as Google Scholar, Web of Science, and discipline-specific tools like philpapers.org or thephilosophypaperboy.com), and while especially these latter are useful, they are not tailor-made for reviewer finding. This setup presents a way to speed up peer-review by partially automating finding reviewers for academic papers.

The aim here is to make something that is tailor-made for reviewer finding, that works by taking data from one publicly available dataset (namely that of Microsoft Academic, which is basically Google Scholar but Microsoft), extracting from it a list of possible reviewers, creating a database from that, and letting one query this newly created database to find reviewers for a paper under your editorship.

Source: Automating Academic Reviewer Finding With Microsoft Academic and Google Apps Script

Storing data from the Flutter app → Google Sheets 📊

In this article, we’ll create a sample app which stores Feedback of user from the Flutter app into Google Sheets using Apps Script.

Source: Storing data from the Flutter app → Google Sheets 📊

How to use GCP service accounts with Google Apps Script projects to automate actions in G Suite

A Google Apps Script and Google Cloud Platform tutorial to learn how to use GCP Service Accounts to scale and protect automations

Examples of Google Apps Script being used in an enterprise setting tend to be few and far between which means this tutorial by Jeffrey Daube is an interesting insight to how script projects can be setup to serve the entire company. In particular, Jeffrey details how the use of service accounts can be used so that G Suite documents can be created with a non-human user allowing you to make calls to Google APIs without the usual authentication flow.

Source: How to use GCP service accounts with Google Apps Script projects to automate actions in G Suite

Get updated with 2019-nCoV (or any) real-time statistics with Google Sheets

What if you want to catch up with the numbers regularly, say, in particular areas? Of course you can keep scrolling your phone for it, but there are chiller ways to do so.

In this 3-part series, Claire Chung explores the spread of pneumonia outbreak and explains how you can import & track data with Google Sheets, organize it & send notifications.

Source: Get updated with 2019-nCoV (or any) real-time statistics with Google Sheets.

GGvulnz — How to check your domain and groups settings

This article will highlight how you have to be careful about settings when you make some content available publicly, like Groups or Drive file.

The original article describe how an external person of the domain can subscribe to your Slack company channel by using a Google Groups that is publicly accessible. Stéphane Giron’s article helps answer the question – how to prevent and how to identify if some groups are concerned.

Source: GGvulnz — How to check your domain and groups settings

How to get that inactive Twitter handle you really want using Google Apps Script

You may have seen in the news that Twitter will begin deleting inactive accounts of users who hadn’t logged in within the past 6 months before Dec. 11, 2019.

This is bad news if you happen to be @qwerty123, but great news if — like me — you’ve found the perfect username but some clueless bovine has been accidentally hoarding it for the past 8 years.

In this post Sean Cann shows you how you can use Google Apps Script to detect when your preferred new Twitter handle becomes available.

Source: How to get that inactive Twitter handle you really want

TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥

In my previous post, I outlined the power of Google document URLs to perform “Simple, Powerful, Work” and promised to share several tools I’ve developed to aid in building them.

Source: TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥

How Deliveroo invented Virtual Neighbourhoods in order to grow Paid Search by 166% with the help of Google Apps Script

We created a series of Google Apps scripts to group together the coordinates of every restaurant within a given neighbourhood. Next, we developed a formula to calculate the mid-point of that group of restaurants and determine the distance between the furthest apart restaurants in that neighbourhood.

This post was highlighted by Tim Leighton-Boyce and while no Apps Script code is included it’s a useful usecase of how Apps Script is helping businesses deliver.

Source: How Deliveroo invented Virtual Neighbourhoods in order to grow Paid Search by 166%

How marketing teams can use Google Apps Script to automate tasks and expand their JavaScript skills

Whether it’s event planning, research aggregation, budgeting, report creation, or reaching out to customers for campaigns; it’s helpful to be able to automate tasks using a script in Google Sheets for example.

Source: How marketing teams can use Google Apps Script to automate tasks and expand their JavaScript…

Follow the trend of Apps develop in your org with a Dashboard of the default Cloud SQL App Maker Instance

Adoption dashboard

Image credit: Jérémy Dessalines https://link.medium.com/yqklXl2p22

Monitoring Google App Maker adoption in our Organisation. For this I realized an Apps Script project calling the Cloud SQL Admin API, a REST API for administering your instances programmatically in order to Lists instances under a given project in alphabetical order by instance name.
Data will be displayed on a DataStudio dashboard.

Source: Follow the trend of Apps develop in your org with a Dashboard of the default Cloud SQL App Maker Instance