Digital Inspiration: How to Add Options in Google Forms Questions from Google Sheets. “As with everything else in the world of Google Forms and Google Sheets, we can easily automate the process of adding question choices in Google Forms in bulk with the help of, you guessed it right, Google Apps Script.”
Digital Inspiration: How to Get Hidden and Filtered Rows in Google Sheets with Google Script. “You can hide entire rows in Google Sheets manually or use filters to hide any rows that matches the specified criteria. For instance, if you have a sheet containing orders from different countries, you can set up a country filter to hide all rows where the country is not the United States. If you have a Google Script that iterates through each row in the Google Sheet for performing actions on the row, like sending emails or merging documents, you can check for the hidden and filtered rows and easily skip them from the workflow.”
Digital Inspiration: How to Scrape Reddit with Google Scripts. “Here’s Google script that will help you download all the user posts from any subreddit on Reddit to a Google Sheet. And because we are using pushshift.io instead of the official Reddit API, we are no longer capped to the first 1000 posts. It will download everything that’s every posted on a subreddit.”
Amit Agarwal: Count the Number of Words and Characters in a Google Document. “If you were to count the nubmer of words and characters in a Google Document, open the document, go to the Tools menu and choose Word Count. That’s a good option for counting words in a single document manually but what if you have a folder of files in Google Drive, say student assignments, and wish to know the words or characters per document. That’s where Google Apps Script can help.”
MakeUseOf: 3 Impressive Google Docs Scripts to Automate Your Documents. “There are many good reasons you should be using cloud-based Google Docs rather than application-based word processing apps like Microsoft Word. One of the most important is that you can create some very useful automations using powerful Google Scripts. Here are three scripts that let you build a document from user prompts, import Google Analytics into a Google Doc report, and create a document from a Google Sheet file.”
MakeUseOf: What Is Google Script? How to Write Your First Google Apps Script. “If you use Google Apps like Google Sheets or Google Docs, Google Script allows you to accomplish things you could never could with a similar desktop application. Google Script (also known as Google Apps Script) is an application development platform that lets you integrate all of the Google Cloud services you use. Google offers a long list of APIs for each one of their cloud services. By writing very simple Google apps, you can open up an entire world of additional features in each one of Google’s many services.”
MakeUseOf: How to Send Email in a Google Sheet With Google Scripts. “Maybe you’re an employee hoping to send a monthly email out to your boss with automatically-calculated formulas in Google Sheets. Or maybe you’re a manager who spends far too much time emailing individual members of your team with things like performance data or status updates. The Google Scripts function you’ll learn in this article will help you accomplish these tasks and much more. With just a little effort one time, you’ll never have to manually send out data again. Let Google Scripts act as your own personal assistant, doing all of the work for you.”
MakeUseOf: 4 Google Scripts That Make Google Sheets Much More Powerful . “In this article I’m going to show you four fairly simple scripts that will let you customize your own functions (like a temperature conversion), auto-generate charts based on any data, customize your own menu inside of Google Sheets, and even automate the sending of monthly emails. All that in a single article? You bet!”
Hongkiat: 19 Google Apps Scripts for Pro Gmail Users. “Gmail, though known as the one of the most powerful mail services, isn’t free of pain points — especially for power users, who would want to save attachments in Drive, schedule mails, batch delete emails etc. Well, the good news is that now you can do all these and a lot more using Google Apps Scripts to ease your digi-life. Let’s take a look at these helpful scripts that Gmail users can benefit from.”
BetaNews: Hacking group uses Google services to control malware. “Carbanak, a powerful cyber-crime group, is using certain Google services as command and control for its malware and other malicious elements. The news was released by cybersecurity firm Forcepoint this week. Forcepoint uncovered a trojanized RTF document, which, once ran, will ‘send and receive commands to and from Google Apps Script, Google Sheets, and Google Forms services.'”
Hongkiat: 19 Useful Google Apps Scripts to Automate Google Drive. These scripts are from all over the place so please review carefully before using.
Are you an old-school computing nerd? Remember Conway’s Game of Life? Here it is in a Google Doc. Just wow.