AppsScriptPulse

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

Build a Google Analytics dashboard 🖥️ with an Apps Script, a Sheets add-on, and Google Sites

If you help manage websites for your organization, and use Google Analytics, you can have data synced directly into a Google Spreadsheet on a routine basis (aka daily at 9am), by installing the Google Analytics add-on in your Sheet.

In addition to using the add-on, you can record your steps using a macro recorder and convert that into a custom menu that automates the setup of your report and creates a summary in chart form.

In this article I walk you through how to build a process to gather unique pageviews for this week, last week, this year, last year, regional location of audience, and top browsers used.

Source: Build a Google Analytics dashboard 🖥️ with an Apps Script, a Sheets add-on, and Google Sites

Create an Apps Script web app to collect phone numbers to text message customers updates 📟

In this article the author elaborates on how to create a basic interface using a standalone Apps Script (based on JavaScript and HTML) in order to collect phone numbers on your website, email signature, or wherever you can embed a URL of this web app and have the phone numbers input, delivered to your Google Sheet.

Source: Create an Apps Script web app to collect phone numbers to text message customers updates 📟

Auto-calculate rooms needed for a conference in a Google Sheet via an Apps Script

Although Google Sheets has more than 400+ built-in functions, I love to show folks how you can create custom functions that you can write for custom problems.

Source: Auto-calculate rooms needed for a conference in a Google Sheet via an Apps Script

Subscribe to Apps Script Pulse...