Sheets / Drive

Sheet Cleanup ToolkitGive Sheets users one-click cleanup actions from a side panel.

A starter add-on for spreadsheet hygiene workflows such as trimming whitespace, normalizing headers, and preparing ranges before export.

SheetsDrivetemplate
Understand the WorkflowOperations teams that maintain imported CSV data, lead lists, and recurring reporting sheets.
Review the ImplementationApps Script implementation files are stored in plugins/sheet-cleanup/appscript.
Continue SetupUse the README and setup steps to finish configuration before publishing to Workspace.

Product Flow

From document image to clean revision

Operations teams that maintain imported CSV data, lead lists, and recurring reporting sheets.

Select an image and start marking

Choose the image you want to edit from Google Docs, or upload a local image directly. The editor keeps every note anchored to the current image, so you do not need a separate instruction document.

Original image
Choose an image and start marking

Use visual markup instead of long explanations

Circle an area with freehand marks, point to issues with arrows, frame important regions with boxes, and add short text notes. Reviewers can understand the requested change by looking at the image.

Clarify this area

Keep both the annotated handoff and the clean version

Download the annotated PNG as the review artifact, then generate a clean revision when you need the final image without visible markup.

Annotated PNGClean revision

Setup and development steps

1

Configure Scripts

Open the appscript folder with clasp or copy files into Apps Script.

2

Connect Services

Test in a spreadsheet bound to your Google account.

3

Test the Add-on

Add cleanup functions gradually and keep each action idempotent.

Apps Script

Script Directory and Feature Structure

plugins/sheet-cleanup/appscript
Sheets homepage card
Range cleanup action scaffold
Toast feedback after script actions
Manifest prepared for editor add-on behavior

Frequently Asked Questions

What is the current status of Sheet Cleanup Toolkit?

Current status: template.

Which Google Workspace hosts are supported?

Current hosts: Sheets, Drive.

Where is the Apps Script implementation?

The Apps Script directory is plugins/sheet-cleanup/appscript.