Bot Cookbook

Search the index

Search templates, recipes, and prompts.

Spreadsheet data audit and safe fixes

We looked this up in the docs; we have not run it in a bot yet.

Updated 15 Oct 2026.

Prompt

Open the attached spreadsheet or Google Sheet. Before any analysis, check it like a data scientist: list duplicates, blank cells, broken formulas, totals that don’t add up, and dates in the wrong format. For every problem, note the cell or range. Fix issues only in a copy of the file (never the original). Tell me exactly what each fix changed and return both the problem list and the cleaned copy.

Fill in

Nothing to fill in.

Connectors

Google Drive, Google Sheets, Browser

Expected result

A problem list with cell references plus a cleaned copy of the sheet.

Uses this feature

Use cases · Use cases

Credit

Idea from @@LimestoneHQ. Written here in our own words.

Also in the index

No related recipes or templates are published yet.