The script is designed to bulk create folders from a Google Sheet and to arrange them into alphabetised folders within Google Drive, by extracting the first letter of a user’s surname.
If a suitable alphabetised folder does not exist in Google Drive, then one is created. The script also adds the created folder to an ‘Everybody’ folder so that there is a single area with all the folders listed in.
This is designed to automate bulk renaming of multiple files within a single Google Drive folder. It has been developed as a Google Sheet with flexibility towards entering your own search pattern and replacement string as you see fit.
This is designed to loop through each row of a Google Sheet and send an email containing information from it. This means you can send personalised emails with ad-hoc information for each recipient quickly.
It has been developed so that it is easily expandable for you to add further columns/rows. The script has a number of features to achieve this:
A menu option for easily selecting to send email, with a confirmation dialogue popup.
A timestamp as confirmation for when an email was sent.
A check that an Email Address is present and there is no current value in the Email Sent column – to prevent repeat email sending but also allow ad-hoc emailing by clearing this column for those you wish to send again.
A try/catch to help automatically deal with problematic emails that may break the script – an error message will be written into the Email Sent column and the script will continue on to the next row.
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.
For my Next session earlier this year I needed to show the Gmail inbox of my test account, but didn’t want it appear empty. So I throw together a quick #appsscript to create dummy emails, using data generated in @mockaroodev. Now you can too! https://t.co/CgEQU5WnJJpic.twitter.com/Y8tHb6Ynch
After 10 years at Google I had accumulated a lot of labels in Gmail, most of them unused for years. Managing them in the UI was too tedious, so I put together a Sheet + Apps Script to allow me to manage them in bulk. Now you can too! https://t.co/YTLVNFgbKdpic.twitter.com/p0NX8hJpRe
Use this spreadsheet to manage your Gmail labels in bulk! To get started, follow the steps below:
Make a copy of this spreadsheet.
Wait a few moments for the “Bulk Labels” menu to appear.
Click “Bulk Labels > Pull labels”.
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.
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.
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.
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.
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.
