Google Workspace Marketplace

Sheet Audit Pack Free Google Sheets Audit Add-on

Find spreadsheet risks before they become business problems.

Sheet Audit Pack is a free Google Sheets add-on that audits a whole workbook from the sidebar: formula errors and broken references, hidden sheets, rows and columns, external links, protections, and named ranges. It writes a clear audit report back into your spreadsheet, so you can fix issues before you share or hand over the file.

Free to use No subscription No external account required Built for Google Sheets

Get it from the Google Workspace Marketplace

View Privacy Policy

Spreadsheet content is not sent to external CloudNetix servers. Reports are generated inside your Google Workspace environment.

The Sheet Audit Pack sidebar in Google Sheets, with the output folder, scope, and audit checks

Why it matters

Spreadsheets often hide risk.

Important workbooks grow over time without documentation. Hidden sheets, broken formulas, external references, and undocumented protections make workbooks difficult to trust, maintain, or hand over. Sheet Audit Pack turns an unknown workbook into a structured review.

Hidden structure

Hidden sheets, rows, columns, and protections can make workbooks difficult to review, audit, or safely modify.

Formula risk

Broken references, inconsistent formulas, and volatile functions reduce confidence in results and increase the chance of silent errors.

Poor handoff readiness

Without documentation, inherited spreadsheets are hard to maintain, explain, or improve — leading to costly mistakes during transitions.

Simple to use

Run a workbook audit in minutes.

Sheet Audit Pack is a sidebar add-on. No installation beyond the Marketplace, no account needed — just open your sheet and start.

Open your Google Sheet

Launch Sheet Audit Pack from the Google Sheets Extensions menu. The sidebar opens inside Google Sheets.

Choose what to scan

Select the workbook areas and checks you want to include. Toggle individual checks on or off, and choose your output format.

Review the report

Generate structured outputs — an Audit Summary, Issues Log, Formula Map, and optional Google Doc report — directly in your workbook.

What it checks

Sheet Audit Pack checks what matters.

Configurable checks cover the most common spreadsheet risks, from formula quality to governance readiness.

Formula quality

Detect formula errors, broken references, inconsistent formulas, volatile functions, and risky calculation patterns.

Workbook structure

Review hidden sheets, hidden rows and columns, sheet protections, frozen ranges, filters, and structural complexity.

External dependencies

Identify external links, imported data, cross-workbook references, and other external dependency risks.

Named ranges

Find named ranges and review whether they are clear, valid, and useful for workbook maintainability and documentation.

Governance signals

Surface indicators that help with handoff readiness, auditability, and workbook documentation quality.

Configurable scans

Choose which checks to run, which sheets to include, and where reports should be generated.

Audit outputs

Clear reports you can act on.

Generated outputs give you a structured view of workbook health, individual findings, and formula coverage — ready for handoffs, client delivery, or internal review.

Audit Summary

A high-level overview of workbook health, key findings, risk score, and recommended next actions — generated as a sheet in your workbook.

Issues Log

A structured list of findings with severity, sheet location, category, and notes. Filterable and reviewable inside Google Sheets.

Formula Map

A review-friendly map of formulas across sheets to support workbook investigation, maintenance, and documentation.

Google Doc Report

An optional document export for client handoffs, deliverables, or internal documentation. Saved to a Google Drive folder you choose.

Who it is for

Built for spreadsheet reviews, handoffs, and audits.

Sheet Audit Pack is useful for anyone who works with spreadsheets they did not build themselves — or needs to document and hand over the ones they did.

Freelancers & consultants

Review client workbooks faster and deliver structured audit reports as part of your engagement.

Finance & operations teams

Find spreadsheet risks before they affect reporting, forecasting, or decision-making.

Agencies & partners

Document workbook condition before handoff or migration. Provide clients with a clear review of what was delivered.

Anyone inheriting a workbook

Understand what is inside a spreadsheet before making changes. Identify risks you did not create.

Privacy & trust

Designed with privacy in mind.

Sheet Audit Pack is designed to run inside your Google Workspace environment. Spreadsheet content is used only to perform the audit and generate the reports you select.

No external spreadsheet storage

Spreadsheet content is not stored on CloudNetix servers. Processing is performed within Google's infrastructure.

No selling user data

User data is not sold, shared for advertising, or used for purposes unrelated to the add-on's core functionality.

No external account required

Users do not need to create a CloudNetix account. The add-on works entirely within your existing Google Workspace.

Reports stay in your workspace

Generated reports are created in your Google Sheets workbook or your chosen Google Drive folder — they remain in your Google account.

Limited permissions

The add-on requests only the permissions required to scan sheets and generate selected report outputs. No broad account access.

User-controlled execution

Audits run only when the user chooses to start them. The add-on does not run automatically or in the background.

Transparency

Why permissions are requested.

To audit a workbook, Sheet Audit Pack needs permission to read spreadsheet structure, formulas, and metadata. To generate reports, it may need permission to create or update files in your Google Workspace environment.

Google Sheets access

spreadsheets.currentonly

Used to inspect workbook structure, formulas, sheets, ranges, protections, and spreadsheet metadata in the currently active spreadsheet only. The add-on cannot access other spreadsheets in your account.

Google Drive access

drive.file

Used only when the user chooses to generate or store a Google Doc report. Limited to files and folders explicitly selected by the user, or files created by the add-on.

Sidebar & UI

script.container.ui

Permission to display the add-on sidebar and the Google Drive folder picker dialog within the Google Sheets interface. Required to show the audit controls to the user.

User action required

Manual trigger only

The add-on runs audits only when launched by the user. There are no background triggers, no scheduled runs, and no automatic data collection.

Product preview

See it in action.

Sheet Audit Pack runs as a sidebar inside Google Sheets. All outputs are generated directly in your workbook.

Sheet Audit Pack in one minute Watch on YouTube How to audit a Google Sheet, step by step Watch on YouTube

The Output section of the Sheet Audit Pack sidebar: Audit Summary sheet, Issues Log sheet, Formula Map sheet and Google Doc report, all switched on

Configure an audit

Choose the checks and the outputs in the Google Sheets sidebar: three report sheets, plus an optional Google Doc report.

The Audit Summary sheet showing a risk score of 100 out of 100, rated Severe, with sheets and formulas analyzed

Review the Audit Summary

See the risk score, key findings, and recommended next steps at a glance.

The Audit Issues Log sheet listing findings by severity, category, sheet and cell

Investigate the Issues Log

Review all findings by category, severity, sheet, and cell location. Filterable inside Google Sheets.

Learn more

Guides to auditing Google Sheets.

Practical, step-by-step guides on finding broken formulas, reviewing a workbook before you trust it, and taking over an inherited spreadsheet. Browse all guides.

How to Find and Fix Broken Formulas in Google Sheets

What #REF!, #NAME?, and #VALUE! really mean, how to find every broken formula across a whole workbook, and how to stop them coming back.

The Google Sheets Audit Checklist

A practical 12-point checklist for reviewing a spreadsheet before you trust it: formulas, references, external links, validation, protections, hidden tabs, and named ranges.

How to Take Over an Inherited Google Sheet Without Breaking It

A step-by-step playbook for inheriting a complex sheet: back it up, map the structure, find the hidden dependencies, and understand it before you change a thing.

Common questions

Frequently asked questions.

If you have a question not answered here, contact support@cloudnetix.de.

Is Sheet Audit Pack free?

Yes. Sheet Audit Pack is free to use. There is no subscription and no external account required.

Does Sheet Audit Pack send spreadsheet data to CloudNetix servers?

No. Spreadsheet content is not sent to external CloudNetix servers. The add-on is designed to process workbook information within the Google Workspace environment and generate reports selected by the user.

What is a Google Sheets workbook audit?

A workbook audit is a structured review of a whole spreadsheet file rather than a single sheet: its formulas, structure, external dependencies, named ranges, and protections. Sheet Audit Pack runs these checks automatically and records every finding in an Audit Summary and Issues Log, so you can see what to fix first.

What does the add-on check?

It can check formula issues, workbook structure, hidden sheets, hidden rows and columns, sheet protections, external links, named ranges, and other workbook governance signals.

What reports are generated?

Depending on the selected options, Sheet Audit Pack can generate an Audit Summary, Issues Log, Formula Map, and an optional Google Doc report exported to a Drive folder you choose.

Why does the add-on request Google permissions?

The add-on needs permission to inspect spreadsheet content and structure so it can perform the audit. If report exports are enabled, it may also need permission to create or update report files in Google Drive. Only the minimum required permissions are requested.

Can I choose what to scan?

Yes. Sheet Audit Pack is configurable — users can choose which checks and outputs to include, and which sheets or areas to analyze.

Is this an official Google product?

No. Sheet Audit Pack is an independent add-on developed by CloudNetix. Google Sheets and Google Workspace are trademarks of Google LLC. Sheet Audit Pack is not affiliated with or endorsed by Google LLC.

Get started

Ready to audit your next workbook?

Use Sheet Audit Pack to review workbook structure, formula risks, and handoff readiness — directly inside Google Sheets. Free, with no subscription.

Contact support