Tutorial on how to build an Alexa Rank tracker in Google Sheets, using the powerful IMPORTDATA and REGEXEXTRACT functions and Apps Script.
Clever post from Ben Collins highlighting how Google Sheets functions can be used to scrape Alexa tracking data. As a bonus Ben includes a little snippet of Google Apps Script to let you archive data over time.
Source: Alexa Rank Tracker built in Google Sheets with formulas and Apps Script
Learn how to use Google Cloud’s Natural Language API to do sentiment analysis on tickets submitted to a Google Tables Support Issue Tracker. We’ll use Google Tables as the platform for our Support Tracker and Apps Script to connect to the Cloud Natural Language API.
Great example from Ben Collins building on the work of Alicia Williams which shows how you can interact with your Google Tables with Google Apps Script. As part of this solution Ben uses the new Tables Service, which is the latest Advanced Service to hit Google Apps Script, connecting to the Google Cloud Natural Language API. Click through to the source for all the details you need to get started.
Note: Google Tables beta is currently only available in the U.S.
Source: Sentiment Analysis For Google Tables Using Apps Script –
App Script comes with a JDBC Service that lets you connect to MySQL, Microsoft SQL Server, and Oracle databases.
This is a guest post from Mike Ritchie (on benlcollins.com), co-founder of Seekwell.io, which adds SQL to the apps you need it in.
Source: How To Connect Google Sheets To A Database, Using Apps Script
Source: Apps Script V8 Runtime Explained For Non-Professional Developers
Every Monday I send out a Google Sheets tip email and occasionally I’ll include a formula challenge…. It would have been too time consuming to reply to all 150 responses manually from my inbox. Since 95% of all my replies would be the same … it was a perfect case for automation.
Ben Collins expertly shares how he automates part of his Gmail inbox to review emails in Google Sheets and prepare draft replies to be sent as responses. As always Ben provides details of each step and the code.
PS Don’t miss Ben’s free Automation With Apps Script course – enrolment closes 31 January 2020.
Source: Gmail Mail Merge For A Specific Label With Apps Script – Ben Collins
Use Google Apps Script to create Google Sheets sort-by-color and filter-by-color features and replicate the functionality that Excel has.
Love the clever workaround Ben Collins uses to let you filter and/or sort a Google Sheet by cell colour. Ben’s post includes all the code you need and an explanation of how it works … or you can just make a copy of the sheet and start using yourself.
Source: Google Sheets Sort By Color And Google Sheets Filter By Color, With Apps Script
Learn how to use Goal Seek in Google Sheets. The Goal Seek feature enables you to change input values to make a formula result match the goal you specify.
We’ve highlighted the new Goal Seek Add-on previous in Pulse, but if you missed it or wanted to see some more practical use cases Ben Collins has expertly covered how to setup and use it.
Source: Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets
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
Lifelong tech enthusiast. Systems analyst and developer in the insurance industry. Podcast and audiobook connoisseur.
Step-by-step guide to connect to the Strava API with Google Sheets to retrieve athlete data and display it in a stunning Google Data Studio dashboard.
Source: How to connect the Strava API with Google Sheets and Data Studio
These 10 coding tips will help you develop good practices early in your coding journey.
Source: Coding Tips For Beginners With Google Apps Script