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.
Source: How to Scrape Reddit with Google Scripts – Digital Inspiration
Great overview from Amit Agarwal on some of the changes in the Google Apps Script runtime. Amit provides some very useful tips for things you can and can’t do using V8 as well as listing some resources if you are interested in learning about what’s possible now that you can use Arrow Functions, Classes, Array Destructuring, Template Literals and more.
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
Learn how to use a Google Sheet to track product prices on Amazon shopping websites and get email alerts when the prices go down or up.
Always interesting to see the projects Amit Agarwal comes up with. This post includes a link to the free version of the Google Sheet.
Source: Amazon Price Tracker – Monitor Price Drops on Amazon with Google Sheets
Amit Agarwal has a great tutorial and boilerplate code for developers interested in locally Google Apps Script development.
Source: Google Apps Script for Developers