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.
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
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
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 💥
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%
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.
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
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
Source: Create an Apps Script web app to collect phone numbers to text message customers updates 📟
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