SheetScript

SheetScript is my OneScript Workspace Add-on for Google Sheets.

Installation

Features

  1. Easy Tabs – Delete, hide, color, and sort the tabs easier
  2. Google Map Image – Insert Google Map as an image

Easy Tabs

Delete, hide, color, and sort the tabs.

Delete – Choose action “Delete” and select the sheets to delete.

Hide – Choose action “Hide” and select the sheets to hide, unchecked sheets will be shown.

Color – Choose action “Color”, enter a hex color, then select the sheets to apply the tab color to them.

Sort – Choose action “Sort”, select a sort order then apply the sort.

Google Map Image

Insert a static Google Map as an image to the active cell  by using an address or coordinates.

  1. Select Type – the way to search
  2. Address – when “Address” type is selected
  3. Latitude – when “Coordinates” is selected
  4. Longitude – when “Coordinates” is selected
  5. Map Type
  6. Maker Size
  7. Maker Color
  8. Maker Label – a single letter from A-Z or 0-9
  9. Width (px) – size of the image to be created 
  10. Height (px) – size of the image to be created

SheetScript Playlist