Spreadsheet Tidy-up
Normalises messy rows into a clean workbook with a change log, dropping nothing.
Productivity · produces a Spreadsheet · built in, ready to run
What you give it
Whatever the job is about — a block of text, a URL, a name. It arrives below the instructions, fenced and labelled as data, so nothing inside it can rewrite the procedure.
Tools it uses
Restricted to these, and nothing else:
read_documentcreate_spreadsheet
Fewer tools means fewer ways to do the job, which is what makes the result the same next week. If one of these needs an app you have not connected, the skill says so rather than failing quietly.
What it reads
This skill carries material of its own. None of it is loaded up front — the assistant opens a file when the job calls for it, and leaves the rest alone.
| File | What it holds |
|---|---|
references/normalisation-rules.md |
Normalisation rules by column type |
The procedure it follows
This is the skill, in full. Add it to your own skills to change any of it.
Read the data (read_document for an attachment), count the rows, and decide what one row is, which columns identify it and which are required. Normalise one rule per column: Title Case names, lower-case emails, E.164 phones, YYYY-MM-DD dates, full country names, numbers without currency symbols, blanks left blank. Never drop, merge or guess: keep every row, mark duplicates in a "Duplicate of" column, missing required fields in "Missing", and suspect values you did not change in "Check". Build the workbook with create_spreadsheet writing the cells yourself in `sheets`: a Clean sheet, a Change log sheet (Row, Column, Before, After, Rule, one line per changed cell) and a Summary sheet with the counts. Reply with the counts and the most common changes only.
How to run it
| Where | How |
|---|---|
| Chat | "Run my Spreadsheet Tidy-up skill", or pick it from the + menu |
| Skills page | Find Spreadsheet Tidy-up under Library and press Add & Use |
| Automations | Invoke it on every trigger |
| API | POST /v1/skills/{id}/run — add it to your own skills first, then take the id from GET /v1/skills |
In chat, on the Skills page and in automations you do not have to add it first — a library skill runs as it is. Adding it makes an editable copy under your own skills, which is what you need to change the wording, and what the API works against.
New to skills? Start with what a skill is.
Open App