AppsScriptPulse

Creating a Slackbot to Scan Google Ads URLs for Errors

As an agency dealing with tens of thousands of URLs, it’s inevitable that some of them are going to break without our knowledge.

Not only does sending traffic to a broken link waste ad spend, it also leads to a poor experience for the user. Redirecting links can also strip out tracking code, preventing us from accurately seeing the impact of our activity. In order to mitigate this, we’ve set up a Google Apps Script to automatically scan all active ads in our MCC account and send a notification to Slack (or via email) whenever it detects a problem.

Source: Creating a Slackbot to Scan Google Ads URLs for Errors

How to Force Reset GSuite Users’ Passwords with Apps Script – Digital Inspiration

Learn how the GSuite admin can change the Google account passwords of multiple users in their organization automatically with Google Apps Script.

You can use Google Apps Script to automatically reset the password of users in your GSuite domain. This script can only be executed under the Suite admin account. You also need to enable the AdminDirectory Advanced Service in your Apps Script Editor.

Source: How to Force Reset GSuite Users’ Passwords with Apps Script – Digital Inspiration

Automate Adding Members to Google Group from Google Sheets — Google Apps Script

I added a script to Google Sheets that auto added new email addresses to the Google Group every time the sheet was edited.

The author was using Google Group to provide access to their dashboard in Google Data Studio. The members kept adding and the process became tedious. They were already keeping/adding all emails in a Google Sheet for some mapping. So this is what they did.

Source: Automate Adding Members to Google Group from Google Sheets — Google Apps Script

ES 6 Features for Google Apps Script: Template Literals – Jeff Everhart

In this post, I look at using template literals, an ES6 feature now available to Google Apps Script developers, to create dynamic multiline strings.

Source: ES 6 Features for Google Apps Script: Template Literals – Jeff Everhart

Now Write your Google Scripts using Modern JavaScript ES6 – Digital Inspiration

Google Apps Script has made the switch to Chrome V8 JavaScript Engine. You can now write your Google Scripts and GSuite addons directly in ES6 but with a few caveats.

Source: Now Write your Google Scripts using Modern JavaScript ES6 – Digital Inspiration

Keyword Suggestions using the Google Suggest API and Google Apps Script

For a company looking to improve its online presence, the keywords they rank for online, and their position, are crucial. Knowing which keywords to target can be difficult, especially for a smaller business that may not yet rank for many, or established businesses looking to find additional terms they may be overlooking.

One basic tool to hunt for new keywords to rank for is Google autocomplete – the process of simply beginning to type in the Google search box and letting Google suggests possible search terms based on what you’ve input. These suggested terms are based on what other people are searching for using your input term and therefore may provide useful keyword suggestions. This is an introductory blog post on how to utilise the Google Suggest API for keyword suggestions using google apps scripts to pull the data.

Source: Keyword Suggestions using the Google Suggest API and Google Apps Script

Parsing JSON in Google Sheets with Zendesk and Google Script

For the most part, using ImportJSON works well—it’s a low effort way of pulling data from any API’s GET endpoint and storing that data in a sheet for further parsing and filtering. But, there was a flaw: Zendesk’s API calls are paginated and limited to 100 results per page. That meant that we needed to add a new ImportJSON() formula every 100 rows to get all of our data.

This follow-up guide goes the extra step—not to feed a big JSON file into ImportJSON, but to write a script that does everything, including pagination. And, as an added bonus, is easier on your API rate limit.

Source: Parsing JSON in Google Sheets with Zendesk and Google Script

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

Free Web-Based Paging System with Google Apps Script and Hangouts Chat

If you use G Suite for Education or Business and have five minutes to spare then you’ve got everything you need to make a web-based paging system for FREE.

In essence, it’s a doorbell. But one that can reach you wherever you are.

Source: Free Web-Based Paging System with Google Apps Script and Hangouts Chat

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 📊

Subscribe to Apps Script Pulse...