AppsScriptPulse

Google Apps Script: Get Google Doc Text Based on Reference Characters – Yagisanatode

This simple tutorial should get you started with grabbing text from a Google Doc for other uses. You could certainly make a lot of changes to the code to introduce more search rules. Likewise, you could use regular expressions to search for some really cool stuff, but for a simple overview this should get you started.

This post provides a detailed how-to of getting a list of information from the document that you have noticed are between two sets of characters.

Source: Google Apps Script: Get Google Doc Text Based on Reference Characters – Yagisanatode

Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask

The problem: hyperlinks in Google Sheets can be in three different formats so if you have a script or add-on that relies on handling links in cells it can cause some headaches.

This article covers a thorough walkthrough of using Advanced Sheets Service to read hyperlinks from cells with different link formats.

Source: Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask

Using Google sheets to build a very simplistic Inventory Management solution for your small business.

Google sheets has Apps Script which extends its functionalities — allowing the automation of tasks, creation of UIs, webapps, add-ons, etc. This makes it a very powerful tool to create customized solutions for your needs.

A simple approach on dealing with complexities of managing inventory for small businesses using Spreadsheets and Google Apps Script.

Source: Using Google sheets to build a very simplistic Inventory Management solution for your small…

Make your own Dobble / Spot It game with Google Slides and Apps Script

Upload a few images to Google Drive, press a trigger to start a little Apps Script code and get your own Dobble game on Google Slides.

This tutorial will guide you into creating your own Dobble card deck with Google Slides, which you can easily print for use in your day to day life.

Source: Make your own Dobble / Spot It game with Google Slides and Apps Script

Google Apps Script Patterns: Writing rows of data to Google Sheets the V8 way

For some context for seasoned Google Apps Script developers like me until V8 we’ve been working in a bit of an old school JavaScript bubble. With V8 there is an opportunity to write less verbose and more succinct code. To see some of the differences below I’ve copied the Writing JSON data mapped to row headings example from my original post and updated this with a V8 version and will highlight the changes.

This post covers a range of techniques and includes a typical pattern for writing structured data like JSON responses from third party sources.

Source: Google Apps Script Patterns: Writing rows of data to Google Sheets the V8 way

How to Produce Quality Titles & Meta Descriptions Automatically

Here’s how you can produce quality titles and meta descriptions automatically in Google Sheets with minimal Python and JavaScript code.

A thoughtful implementation of custom functions in Spreadsheets using Google Apps Script.

Source: How to Produce Quality Titles & Meta Descriptions Automatically

Starting With Google Script

At the highest level, Google Apps Script (GScript for short), is a scripting platform for light-weight development across the entire Google Suite ecosystem. Each GSuite “app” (Sheets, Docs, Calendar, etc…) is referred to as a GScript service. Each service, such as the Google Sheets service we’ll strictly focus on throughout this article, is made up of multiple classes — each with the typical class structure of properties & methods.

You’re likely using Google Sheets already, so why not take a few minutes to learn how to customize & automate it to your particular needs? With Google Script, Google has made it extremely easy for anyone to extend Sheets.

Source: Starting With Google Script

React on Google Calendar change with Apps Script and EventUpdated trigger

It is really amazing how it is simple to make this script and have an app that run on each change perform in your Google Calendar.

A quick post to deal with a script that run when a new event or an event is updated in my Google Calendar. Hopefully in Apps Script we have an EventUpdated trigger.

Source: React on Google Calendar change with Apps Script and EventUpdated trigger

Import Data from Google Sheets to Firestore using Google Apps Script

Cloud Firestore is a fast, fully managed, serverless, cloud-native NoSQL document database that simplifies storing, syncing, and querying data for your mobile, web, and IoT apps on a global scale.

In this post, you will learn how to take the data from Google Sheets and store those records in Firestore using Google Apps Script

Source: Import Data from Google Sheets to Firestore using Google Apps Script

Understanding Macros and Apps Script

Macros are small programs that a Google Sheets user can create to complete repetitive tasks. In fact, macros are an excellent way for a user to become familiarized with Apps Script, as a snippet of code is saved in the script editor each time a macro is recorded. Recording a macro is as simple as going to Tools → Macros → Record macro.

Recording macros and assigning shortcuts to them is a great way to execute repetitive tasks and become a more efficient Sheets user. You can also import macros from other workbooks so you can perform the same tasks and assign the same shortcuts across all of your workbooks.

Source: Understanding Macros and Apps Script

Google Sheets: Get the Number of Words or Sentences in a Cell (Paragraph) – Yagisanatode

Have you ever woken up in the middle of the night thinking – phawh! I’d really like to know how many words there are in a paragraph – Or stopped mid-chew on some arbitrary item carelessly left in the paddock by the boss and thought – geez! If there was only a way to count the number of sentences in a paragraph in a cell in Google Sheets!?

In this short tutorial, Yagisanatode will show you how to get the total count of words in a cell and the total count of sentences in a cell in Google Sheets. They even have a how-to on getting the average sentence length in a paragraph.

Source: Google Sheets: Get the Number of Words or Sentences in a Cell (Paragraph) – Yagisanatode

TSFormBot — A Google Form Hangouts Chat Bot powered by Google Apps Script

TSFormBot is an Apps Script powered Google Form Hangouts Chat Bot which creates form submission webhook notifications for Hangouts Chat Rooms.

Need a structured ping on your Hangouts chat whenever someone submits a form? Laura Taylor has built a perfect solution with an ever more easier workflow documentation on how to implement it.

Source: techstreams/TSFormBot

Merging two 2D arrays/datasets/tables with Google Apps Script – Andrew Roberts

Ever needed to merge two similar datasets and automatically get rid of any duplicates?

This article describes how to do that using the SsObjects Google Apps Script library.

Source: Merging two 2D arrays/datasets/tables with Google Apps Script – Andrew Roberts

Scrape and save data to Google Sheets with Apps Script

If you are looking for a way to get data that is displayed on a website and save it to a Google Sheet every <some time interval>—because a record number of cmd+x and cmd+v keystrokes aren’t really the stats that resonate with you and your friends—please, read on.

A detailed guide by Kamie Robinson on how to scrape data from a website, tabulate that on a Spreadsheet and a sweet tip to backfill your data!

Source: Scrape and save data to Google Sheets with Apps Script

Tuning your Google Apps Script experience (for Google Sheets on steroids)

Are you automating Google Sheets using Google Apps Script? Automation is awesome but doing it with the Google tools can be cumbersome.

Interesting article by José Miguel Gutiérrez that provides some amazing tips on how to improve your coding experience while working with Spreadsheets and Google Apps Script.

Source: Tuning your Google Apps Script experience (for Google Sheets on steroids)

Google Apps Script: Add and removed Google Sheets columns based on a search array

Have you ever wanted to delete or add columns in a Google Sheet, based on another set of Sheet data?

In this tutorial, we’ll show you how to use Google Apps Script to update your headers based on another sheets values. These sheets values can come from the current Google Sheet workbook or another one. We will also ensure that the data below the headers is migrated along with the new header location.

Source: Google Apps Script: Add and removed Google Sheets columns based on a search array

How to automatically pull Facebook Ads data into Spreadsheets

After seeing how to send your Google Ads campaign data to Spreadsheets we will do the same with Facebook Ads. Once again, the idea is to implement a data-driven strategy in campaign performance management. But in my opinion, monthly or even weekly reporting are not enough: it has to be daily. And so that it doesn’t take you 20 minutes a day to export your CSV files and format them, here’s how to automate the boring stuff.

Pretty thrifty approach by Henry-Paté Nicolas on tracking Facebook Ads on Spreadsheets using Google Apps Script.

Source: How to automatically pull Facebook Ads data into Spreadsheets

G Suite Solutions —  Apps Script Powered Workflow Automation

Laura Taylor recently spoke at SheetsCon on the topic of Automation with Apps Script. During the presentation, she walked through a simple approval workflow for a hypothetical small business to demonstrate the power of Apps Script to automate workflow inside G Suite. She also showcased modern ECMAScript features supported by the new Apps Script V8 Javascript runtime.

The article is an overview of the workflow covered in the author’s presentation along with install instructions for trying it out in your G Suite domain.

Source: G Suite Solutions —  Apps Script Powered Workflow Automation

Building your first Hangouts Chat Bot in Apps Script

The task of building a Google Hangouts chatbot can often seem daunting due to the diverse technology options and approaches. What is often not always known is how relatively easy it is to build chatbots by simply using Google Apps Script.

Here’s a step by step guide on how to build your first Google Hangouts chatbot using Apps Script.

Source: Building your first Hangouts Chat Bot in Apps Script

API Calls to ServiceNow from Google Apps Script with OAuth

Have you ever thought that it might be useful to connect a Google Apps Script to your ServiceNow instance? Perhaps you’d like a new way to quickly download a list of configuration items from your change management database to a sheet, or you’d like to upload a selected range of cells from a sheet as new records in SNOW, one record per row?

This guide is focused more on the coding than how to configure your identity provider and ServiceNow.

Source: API Calls to ServiceNow from Google Apps Script with OAuth

Subscribe to Apps Script Pulse...