AppsScriptPulse

Create BigQuery tables with Google Sheets and Apps Script

Creating BigQuery tables using the GUI can be a hassle. This article describes an alternative way to create BigQuery tables

Source: Create BigQuery tables with Google Sheets and Apps Script

Roughly matching text – Desktop Liberation

When dealing with matching in sheets, you sometimes need to get close matches. This post shares the “Rough” namespace of the cUseful library

Source: Roughly matching text – Desktop Liberation

Google Apps Script Patterns: Writing custom formulas/functions and handling single and range inputs – MASHe

Custom functions have been in Google Apps Script since it’s public launch in 2009. These let you extend Google Sheets function list allowing you to create and share your own spreadsheet formula. This post provides some guidance on writing custom Google Sheet functions that can handle both single and range inputs

Source: Google Apps Script Patterns: Writing custom formulas/functions and handling single and range inputs – MASHe

Using Slack Slash Commands to Send Data from Slack into Google Sheets

Since I work from home, most of my daily work interactions happen through Slack. It’s my equivalent to the water cooler. A place to hang out and discuss ideas with friends. I’m part of a book recommendations channel. People share books all the time, but they disappear quickly, lost in a sea of messages. I […]

Source: Using Slack Slash Commands to Send Data from Slack into Google Sheets