Learn how to scrape data from any subreddit on Reddit including comments, votes, submissions and save the data to Google Sheets
Here’s Google script that will help you download all the user posts from any subreddit on Reddit to a Google Sheet. And because it’s using pushshift.io instead of the official Reddit API, the script will no longer be capped to the first 1000 posts. It will download everything that’s ever posted on a subreddit.
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.
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.
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.
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.
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.
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.
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.
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.
