AppsScriptPulse

Snippet, Solutions, Drive, Sheets

Bulk create Google Drive folders from a Google Sheet

Tags:
| |

The following Google Apps Script code was developed to bulk create Google Drive folders with data from a given spreadsheet (eg to name the folders and add permissions). It uses the Module Name and Marker to form the folder name as it iterates through each row in turn. At the same time it takes the Marker Email Address and uses the ‘DriveApp’ to provide edit access to the folder. Finally it creates another sub-folder in each folder as an extra.

Source: The Gift of Script: Bulk create Google Drive folders

Solutions, Gmail, Sheets

Creating dummy data for Gmail using Google Apps Script

Tags:
| | 0 Comments |

Nice little helper script from Eric Koleda using a model you might want to use in other projects to testing/debugging.

Solutions, Sheets, Web App

The simplest OAuth2 server in 120 lines using Google Spreadsheet and Apps Script

Tags:
| | 0 Comments |

oauth2

Explore how to setup your own OAuth2 server using Google Spreadsheet and App Script.

Source: The simplest oauth2 server in 120 lines : Google Spreadsheet and App Script

Solutions, Gmail, Sheets

Bulk Gmail Label Manager (made with Google Apps Script)

Tags:
| | 4 Comments |

Use this spreadsheet to manage your Gmail labels in bulk! To get started, follow the steps below:

  1. Make a copy of this spreadsheet.
  2. Wait a few moments for the “Bulk Labels” menu to appear.
  3. Click “Bulk Labels > Pull labels”.
  4. When prompted, grant the script authorization to your account.

You can then use the spreadsheet to create, rename, and delete labels. You can also merge labels, which deletes a label but also moves all of it’s messages to another label.

When ready, click “Bulk Labels > Perform actions” to make the updates.

Solutions, Sheets

Accessing Cloud SQL from AppsScript to plot data from IoT Core

Tags:
| | 0 Comments |

In my last post, I wrote about publishing device telemetry from Cloud IoT Core to Cloud SQL. The natural thing to want to do after this is to plot that data and I have found using Apps Script with Google Sheets to be a great way to get this working quickly.

In this post you’ll find some helpful advice on connecting to Google Cloud SQL server with Google Apps Script.

Source: Accessing Cloud SQL from AppsScript to plot data from IoT Core

Solutions, Sheets

Google Sheets: Code Adding Content to Multiple Tabs – Teacher Tech

Tags:
| | 0 Comments |

Coding Google Apps Script is easier than you think it is. Learning to code can increase your productivity significantly. One thing I frequently code is adding the same piece of information to multiple tabs in a spreadsheet…

This article presents the building blocks for performing the same action to each sheet in your workbook to eliminate time and mistakes.

Source: Google Sheets: Code Adding Content to Multiple Tabs – Teacher Tech

Solutions, Sheets

Google Script Automation: Create New Sheets Tabs Automatically

Tags:
| | 0 Comments |

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

Solutions, Sheets

Building a Deep Neural Net In Google Sheets

Tags:
| | 0 Comments |

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

Add-on, Community News, Sheets

QUERYX allows you to use SQL queries in sheets

Tags:
| | 0 Comments |

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

Solutions, Sheets

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

Tags:
| | 0 Comments |

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