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

trigger automated meeting invite reminders using apps script

send a follow-up email to all undecided participants of a meeting that you’ve scheduled via google calendar using apps script.

here’s a piece of code that you could schedule for every morning (preferably before your official work hours start) to be triggered, such that the script could iterate through every single meeting event that you’ve scheduled (i.e. where you’re the “organiser”) for the day and send an email to all those invitees who’ve neither accepted nor declined (even excluding the maybe’d ones too) to said invites.

Nice post from Sourabh Choraria which covers interacting and using data from your Google Calendar.

Source: trigger automated meeting invite reminders using apps script

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

TeslaGAS is a Google Apps Script library that helps writing scripts for your Tesla car

Photo by Afif Kusuma on Unsplash

Photo by Afif Kusuma on Unsplash

TeslaGAS is a library that helps writing scripts that communicate with your Tesla – Zzapps/teslagas

Riël Notermans from Zzapps has published the beginnings of a nice little Google Apps Script library that you can use to communicate with your Tesla car.

Source: Zzapps/teslagas

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

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

SHEETSCON 2020 – Free Online Conference for Google Sheets Users, 11-12 March, 2020 

SHEETSCON 2020

Come and celebrate Google Sheets at SheetsCon 2020, the world’s first, dedicated online conference for Google Sheets users.

Listen to world-class experts talk about how they craft solutions using Google Sheets and G Suite.

Over the course of two jam-packed days, you’ll hear everything from deep-dive tutorials on specific topics to cutting-edge solutions across different industries. You’ll have the chance to network with other professionals and meet vendors at the forefront of the Google Sheets movement.

Looks like a great event being hosted by Ben Collins for Google Sheets users. Click through to the SheetsCon 2020 website for the full agenda and free registration

Source: SheetsCon 2020

 

Bulk add unique data to an SQL Table in Apps Script

The following code combines Google Apps Script and SQL to bulk insert a Google Sheet of data into an existing SQL Table, but only after checking the record does not already exist so that it can be safely re-run.

Source: The Gift of Script: Bulk add unique data to an SQL Table in Apps Script

Subscribe to Apps Script Pulse...