AppsScriptPulse

Google Apps Script & IoT

Google Apps Scripts are very powerful yet relatively unknown. In this post Fran Galarza shows us what we can do with them & IoT as a use case.

You could have a sensor regularly measuring the humidity of your garden’s soil and posting that value to your GAS (yes, you can make POST requests). Then your GAS could log that measurement in a Google Sheet and send you an email if the soil is too dry. It can even set an event in your calendar to remind you to water your garden.

Source: Google Apps Script & IoT

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

Building a Deep Neural Net In Google Sheets

I want to show you that Deep Convolutional Neural Nets are not nearly as intimidating as they sound. And I’ll prove it by showing you an implementation of one that I made in Google Sheets.

Source: Building a Deep Neural Net In Google Sheets

QUERYX allows you to use SQL queries in sheets

QUERYX allows you to use sql queries in sheets.

Those familiar with Google Sheets will probably want to know how this is different to the built-in QUERY() function, the answer is this is add-on enables a full SQL. Following the source link gives information on how to access this add-on.

Source: [PROMO] QUERYX allows you to use sql queries in sheets. – Google Groups

Are small errors like worldwide targeting draining your budget? This Google Ads script can help

The script emails you a customized report to flag issues with your chosen account settings, preventing potential Google Ads catastrophes.

[Editorial note: Google Ads script is a variant of Google Apps Script designed to let you control your Google Ads. Google Ads script uses it’s own online IDE but is similar in terms of being an authenticated environment and able to connect with other Google products as well as external data.]

Source: Are small errors like worldwide targeting draining your budget? This Google Ads script can help

Semrush API Library in Google Sheets (Google Scripts) – Open Source SEO

SEMrush API

Semrush.com in my opinion, is one of the best SEO tools on the market. I especially love their API and the data they provide. I also live in Spreadsheets, so I decided to combine the two in this project.

From now on, you’re only an Excel (Google sheets) formula away from some of the best data in the industry.

Source: Semrush API Library in Google Sheets (Google Scripts) – Open Source SEO

Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets

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

Write Apps Script Offline with clasp

🗺️ Develop Locally: clasp allows you to develop your Apps Script projects locally. That means you can check-in your code into source control, collaborate with other developers, and use your favorite tools to develop Apps Script.

Source: google/clasp

The Apps Script IDE is great, but with larger projects, I know I’ve wanted to be able to use a more powerful IDE. clasp (Command Line Apps Script Projects) is a CLI that allows you to start, write, test, and deploy Apps Script projects from any text editor you want.

The classic Halloween dilemma: how to visit as many homes as possible solved by Eric Koleda with a little Apps Script

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

Subscribe to Apps Script Pulse...