Tuesday 28 February 2023

Delete Google Calendar Events by keyword and date range

The following Google Apps Script is designed to search a date range for Google Calendar events containing a given string (something to help target those events) and then delete them.

Search for and delete Google Calendar events

Tuesday 21 February 2023

Google Add-on: Bulk Rename Files update Feb 2023


What it does

Bulk rename Google Drive™ files quickly and easily with this Add-on. You define exactly what you want to search for in the file name and the text to replace it with. Along with options for handling special characters and append/prepend to the existing file name. Works across My/Shared drives.


  1. Special characters
    • The tool can handle: - [ ] / \ { } ( ) * + ? . ^ $ | # 
    • You could remove individual characters:
      • Original file name example: 'Archive backup (ready)'.
      • New file name example: 'Archive backup ready'.
    • You could replace these characters with others:
      • Original file name example: '.backup folder'.
      • New file name example: '_backup folder'.
    • You could both remove and replace them at the same time:
      • Original file name example: 'This experiment belongs to _[Sample]'.
      • New file name example: 'This experiment belongs to Phil'.
  2. Append / Prepend
    • You can add text/characters to the beginning and/or end of the existing file name.
    • In the search text enter '<<KEEPNAME>>' and in the replacement text enter 'Something before <<KEEPNAME>> something after'.
    • Original file name example: 'is my'.
    • New file name example: 'This is my Document'. So replacement text would be: 'This <<KEEPNAME>> Document'

Append / Prepend to the existing file name
Append / Prepend to the existing file name

Tuesday 14 February 2023

Google Add-on: Convert Drive Files

What it does

Bulk convert Google Drive files quickly and easily with this Add-on. Convert between Google, Microsoft Office, PDF, etc.

Point the Add-on at a Google Drive folder, select the file types you want to convert, select your destination folder and whether you want the original file to be deleted, then hit go!

Saves having to go into each file individually, selecting the file type to download and then selecting the save destination.

Convert File Types

Google Doc™ to PDF | Microsoft Word™ | OpenDocument Text | Rich Text Format | HTML

Google Sheet™ to PDF | Microsoft Excel™ | OpenDocument Spreadsheet

Google Slide™ to PDF | Microsoft PowerPoint™ | OpenDocument Presentation

Google Drawing™ to PDF | JPEG | PNG | SVG

Microsoft Word™ to PDF | Google Doc™ | OpenDocument Text | Rich Text Format

Microsoft Excel™ to PDF | Google Sheet™ | OpenDocument Spreadsheet

Microsoft PowerPoint™ to PDF |Google Slide™ | OpenDocument Presentation

Plain Text to Google™ Doc | Microsoft Word™


More being added ...

Find out more

Convert Drive Files Add-on webpage - includes instructions and a demo video.