AppsScriptPulse

JSJ 419: Google AppScript with Ben Collins

Today’s guest is Ben Collins, who creates online courses, writes tutorials, and teaches workshops around G Suite and App Script. Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform. It is an implementation of JavaScript with the express purpose of extending Google apps.

Ben Collins is the guest on episode #419 of the Javascript Jabber podcast to discuss using Google Apps Script with Google Sheets.

The conversation includes Ben’s usage of automated sentiment analysis of feedback from his courses.

Source: JSJ 419: Google AppScript with Ben Collins

5 Google Sheets Script Functions You Need to Know

Google Apps scripting is a background scripting tool that works not only in Google Sheets but also Google Docs, Gmail, Google Analytics, and nearly every other Google cloud service. It lets you automate those individual apps, and integrate each of those apps with each other.

Source: 5 Google Sheets Script Functions You Need to Know

Google Sheets: Code Adding Content to Multiple Tabs – Teacher Tech

Coding Google Apps Script is easier than you think it is. Learning to code can increase your productivity significantly. One thing I frequently code is adding the same piece of information to multiple tabs in a spreadsheet…

This article presents the building blocks for performing the same action to each sheet in your workbook to eliminate time and mistakes.

Source: Google Sheets: Code Adding Content to Multiple Tabs – Teacher Tech

Google Script Automation: Create New Sheets Tabs Automatically

Take it off your weekly to-do list — learn how to automatically create a new tab, clear a designated range, and delete an old tab in Google Sheets.

Source: Google Script Automation: Create New Sheets Tabs Automatically

Creating Calendar events using Google Sheets data with AppScript

Today I’m going to show you how to automatically add Meetings/Events data from Google Sheets into a Google Calendar. This trick came really handy for me so I hope this will serve you the same.

How to automatically add Meetings/Events data from Google Sheets into a Google Calendar.

Source: Creating Calendar events using Google Sheets data with AppScript

How to backup Google Photos to Google Drive automatically after July 2019 with Apps Script

Easy to configure apps script to continue backing up your Google Photos to Google Drive after the July 2019 change. You just need to change two lines of the script to get this running with your Google Photos account.

Source: How to backup Google Photos to Google Drive automatically after July 2019 with Apps Script

How to use Google Sheets and Google Apps Script to build your own blog CMS

Build a “Content Management System” (CMS) for an online blog using Google Sheets, Google Forms, and Google Apps Script.

Source: How to use Google Sheets and Google Apps Script to build your own blog CMS

Google Apps Script: A Beginner’s Guide To Learn Apps Script

Great article to help you get started using Google Apps Script. If you’re an experienced user, you’ll find something too.

Learn Google Apps Script with this Beginner guide. See how to extend Google Sheets, Google Docs and other G Suite apps with Google Scripts.

Source: Google Apps Script: A Beginner’s Guide To Learn Apps Script