Digital Inspiration: How to Add Options in Google Forms Questions from Google Sheets

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

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 Encrypt and Decrypt Text Strings with JavaScript

Digital Inspiration: How to Encrypt and Decrypt Text Strings with JavaScript. “In one of my web projects, I require simple and easy-to-implement encryption and decryption JavaScript library that could encode a piece of text and then decode the encoded string on the server-side. The easiest option is the base64 encoding scheme that can be easily implemented in both native JavaScript and Google Apps Script.”

Digital Inspiration: How to Scrape Reddit with Google Scripts

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.”

Digital Inspiration: Write Google Scripts using Modern JavaScript ES6

Digital Inspiration: Write Google Scripts using Modern JavaScript ES6. “Google Apps Script has received a significant upgrade ever since it was first released to the public more than a decade ago. Apps Script now uses the V8 JavaScript Engine – it is the same runtime that is used inside the Google Chrome browser and the popular Node.js environment.”

Amit Agarwal: Count the Number of Words and Characters in a Google Document

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.”

Hack Your Gmail: A Quick Start For Google App Scripting (Hackaday)

Hackaday: Hack Your Gmail: A Quick Start For Google App Scripting. “Google provides a lot of features with all of its products, but however you slice it, all the code runs on their servers out of your reach. Sort of. If you know JavaScript, you can use Google Apps Script to add features to many Google products including Gmail. If you’ve used Office scripting, the idea is the same, although obviously the implementation is very different. With scripting you can make sophisticated filters that would be very hard to do otherwise. For example, monitor for suspicious messages like those with more than 4 attachments, or that appear to come from a contact between the hours of 2AM and 5AM. For our example today, I’m going to show you something that is easy but also highly useful.”

MakeUseOf: 3 Impressive Google Docs Scripts to Automate Your Documents

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

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

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

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

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

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.'”