AppsScriptPulse

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

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

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

How to edit a row in Google Sheets via ManyChat using Apps Script – Baloka

I’ve not come across ManyChat, a service to build chat bots on Facebook Messenger, but they have free account options. In this demonstration by Gilbert Mizrahi (@GilbertMizrahi) you can learn how ManyChat can be used with Apps Script to update data in a Google Sheet row.

Source: How to edit a row in Google Sheets via ManyChat using Apps Script – Baloka

Google Apps Script Physics Problem Database

Database

This post will be mostly about how to use GAS as a data-driven, responsive website, with the Physics Problem Database really just the example Andy Rundquist (@arundquist) put together to show things.

Source: Google Apps Script Physics Problem Database

Create a seat booking form with Google Forms, Google Sheets and Google Apps Script – Yagisanatode

In this tutorial, Yagisanatode (@LifeOfSpy) is going to build a simple seat booking Google Form that will contain a registeree’s name and the session that they wish to attend. Each time a registeree submits a request to book a seat for a session, that seat is taken from the list displaying only the remaining seats for that session for when the next user submits the form.

Source: Create a seat booking form with Google Forms, Google Sheets and Google Apps Script – Yagisanatode

Amazon Price Tracker – Monitor Price Drops on Amazon with Google Sheets

Learn how to use a Google Sheet to track product prices on Amazon shopping websites and get email alerts when the prices go down or up.

Always interesting to see the projects Amit Agarwal comes up with. This post includes a link to the free version of the Google Sheet.

Source: Amazon Price Tracker – Monitor Price Drops on Amazon with Google Sheets