Guides

Learn the add-on edition menus, Main screen, Database screen, Settings screen, and input features.

Create a self-hosted Apps Script library in your own Google Drive and add a shared snippet sidebar to Google Sheets, Slides, and Docs.

Install Ollama, recommended standard models, lightweight models, and check the local endpoint before using the local AI assistant.

Install PowerShell 7 on Windows and check the difference from Windows PowerShell 5.1, WinGet, MSI, and post-install commands.

Ask questions, process selected ranges, and create formulas with local Ollama from a Google Sheets sidebar.

Compare a baseline sheet against another sheet and create summary, comparison, and diff-only reports.

Build formulas such as IMPORTRANGE, QUERY, FILTER, and XLOOKUP from a sidebar with input assistance.

Merge selected or all sheets into one output sheet as fixed values or a formula-based combined view.

Split one source sheet into multiple sheets by key column values as fixed values or formula-based views.

Apply row heights and column widths from a selected base sheet to other sheets.

Add a sidebar operation panel for quick movement to the last data row, next empty row, A1, and the used range.

Use a lightweight layer panel for the current slide to select, reorder, temporarily hide, rename, and assist with locked objects.

Normalize phone number notation and output candidates to a review sheet.

Normalize postal code notation and output candidates to a review sheet.

Normalize company type notation while keeping source data unchanged.

Normalize mixed date strings and display formats into review candidates.

Learn setup steps and notes for one-way value sync with Apps Script.

Detect duplicate candidates by key columns and list them on a review sheet without deleting source data.

Learn how to add multiple generated scripts to one Apps Script project while avoiding duplicated functions, menus, and triggers.

Learn the basics of pasting, saving, first authorization, triggers, HTML files, and safe testing.

Learn how to read the input column, result column, code tab, setup steps, review points, JSON, and guide downloads.