AppsScriptPulse

How to Scrape Reddit with Google Scripts – Digital Inspiration

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

Write Google Apps 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.

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.

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

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

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

Amazon Price Tracker – Monitor Price Drops on Amazon with Google Sheets

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

Subscribe to Apps Script Pulse...