AppsScriptPulse

EncodeApp by tanaike (The Thinker)

EncodeApp is a GAS library for retrieving the encoding set (charset) and doing URL encode with the specific encoding set using Google Apps Script (GAS). – tanaikech/EncodeApp

Library’s project key: 1DsJdRQ9D6nXgbxVVvOroM3EYJOcB197Isvt2Sl4sziW3m9IqqeB9YoWy

Source: tanaikech/EncodeApp

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.

Manage Gmail with Google Apps Script

Ever had a messy inbox full of mails? Does it bother you to skip the inbox? Luckily, Google has provided many services that we can harness its utilities to organize the mail using personal preferences or workflow.

You will able to make an auto email archiver/remover after following the steps. This will be done by using Google Apps Script and setting the schedule trigger. The code is pretty simple and straightforward since Google has already provided us with ready-to-use objects for managing Gmail.

Source: Manage Gmail with Google Script

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 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…

Apps Script – Adding and removing Drive files and folders

In case you didn’t know, Google Drive has the ability to store files and folders in more than one place at a time. So, you could have a file in a folder for a particular company and have the same file in a different folder which is where you store all the reports. It’s something you can’t do in a traditional computer folder system.

Source: Apps Script – Adding and removing Drive files and folders

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...