Canonical reference forpip install g-gremlin

Gremlin CLI Reference

Complete command catalog for g-gremlin. Every command grouped by function with impact ratings and usage examples.

66 commands and namespaces across 12 functional groups covering Sheets, transforms, enrichment, CRM automation, docs sinks, and operational tooling.

Install Quick Start

Sheets Core Data Transform Sheet Analysis Sheet Repair Enrichment CRM Integrations Sales Engagement BI & Analytics Visualization Docs & Sinks Ops & Auth Autopilot

Quick Start

Three common workflows for getting value from the CLI quickly. Use the command groups below as the canonical catalog, then drill into namespace help when you need subcommand detail.

Pull -> Transform -> Push

Sheets workflow

# Export a Sheet tab to CSV
g-gremlin pull

# Rename, calculate, or reshape columns locally
g-gremlin transform

# Review the diff before applying it
g-gremlin diff

# Push approved changes back with ETag safety
g-gremlin push

Enrich Contacts

FullEnrich

# Check provider health and credentials
g-gremlin enrich-doctor

# Run the FullEnrich waterfall
g-gremlin fullenrich doctor
g-gremlin fullenrich enrich
g-gremlin fullenrich status

HubSpot Snap -> Plan -> Deploy

HubSpot admin workflow

# Baseline the portal
g-gremlin hubspot snapshot

# Review the planned changes
g-gremlin hubspot pack plan

# Apply when the plan is approved
g-gremlin hubspot pack apply --yes

Impact Legend

Read the badge before you run the command. Mutating and external workflows are clearly marked.

[R]read-only, safe to run anytime

[W]writes to local files or Sheets

[X]external side effects (CRM writes, API calls)

[NS]namespace — run subcommand for details

Sheets Core

Core Google Sheets workflows for exporting, writing, syncing, and chaining Sheet-native jobs.

g-gremlin pull

[R]

Export Google Sheet data to local CSV file.

g-gremlin write

[W]

Write a CSV into a Sheet tab (overwrite or append).

g-gremlin push

[W]

Apply changes from diff.json back to the Sheet with ETag safety.

g-gremlin copy-tab

[W]

Copy a tab within a spreadsheet (preserves cross-sheet references).

g-gremlin chain

[X]

Chain pull -> enrich -> transforms -> write in one command.

g-gremlin sync

[W]

Sync multiple sheet tabs from CSV files using YAML configuration.

Data Transform

CSV-first utilities for diffing, matching, transforming, validating, and querying local datasets.

g-gremlin diff

[R]

Diff utilities for comparing data.

g-gremlin merge

[R]

Merge multiple CSVs by key, unioning columns and keeping source flags.

g-gremlin fuzzy-match

[R]

Fuzzy-match names between two CSVs using normalization + similarity.

g-gremlin transform

[R]

Apply simple transforms: rename columns, add blank columns, calculated columns.

g-gremlin filter

[R]

Filter a CSV by evaluating a Python expression against each row.

g-gremlin validate

[R]

Validate a CSV. If --rules is provided, runs YAML rules. Otherwise runs formula pre-flight checks.

g-gremlin dedup

[R]

Deduplicate CSVs (engine-first; local fallback with --local).

g-gremlin query

[R]

Run a read-only DuckDB query against local CSV/Parquet files.

Sheet Analysis

Read-only diagnostics for structure, formulas, references, schema compliance, and dependency tracing.

g-gremlin inspect

[R]

Analyze a sheet's structure, column types, and formulas.

g-gremlin inspect-formulas

[R]

Show formulas within a range without pulling values.

g-gremlin lint

[R]

Scan Google Sheet formulas for errors, broken references, and style issues.

g-gremlin check-bands

[R]

Verify that column bands reference the correct sheets.

g-gremlin generate-lag

[R]

Generate IFERROR(OFFSET()) formulas for lagged waterfalls.

g-gremlin find-refs

[R]

Find all cells that reference a given cell.

g-gremlin schema-validate

[R]

Validate a spreadsheet against a YAML schema.

g-gremlin trace

[R]

Trace formula dependencies for a cell.

Sheet Repair

Repair and maintenance helpers for spreadsheet structure, formatting, formulas, names, and tab operations.

g-gremlin repair

[W]

Repair broken spreadsheets.

g-gremlin rescue

[W]

One-shot rescue: scan all tabs, fix what can be fixed.

g-gremlin style

[W]

Apply simple styling (headers, stripes, fonts) to a sheet range.

g-gremlin formula

[NS]

Formula helpers.

g-gremlin names

[NS]

Named range management.

g-gremlin sheets

[R]

Google Sheets tab operations (inventory, delete, rename).

Enrichment

Provider-backed enrichment workflows with health checks, waterfalls, OAuth helpers, and extraction namespaces.

g-gremlin enrich

[X]

Enrich CSV using Apollo/ZoomInfo/Apify/FoundryGraph providers with caching.

g-gremlin enrich-doctor

[R]

Check provider health and credential status.

g-gremlin fullenrich

[NS]

FullEnrich waterfall enrichment commands (doctor, enrich, status).

g-gremlin fg

[NS]

FoundryGraph company enrichment commands.

g-gremlin apollo

[NS]

Apollo OAuth connection commands (backend-held tokens).

g-gremlin nimbleway

[X]

Nimbleway web search & extraction helpers.

CRM Integrations

CRM and support-system namespaces for schema management, admin automation, and signal ingestion.

g-gremlin sfdc

[NS]

Salesforce helpers.

g-gremlin hubspot

[NS]

HubSpot admin CLI.

g-gremlin dynamics

[NS]

Dynamics 365 / Power Platform admin CLI.

g-gremlin zendesk

[NS]

Zendesk helpers.

Sales Engagement

Sequencer and outreach namespaces for campaigns, enrollments, and sales activation workflows.

g-gremlin outreach

[NS]

Outreach.io sales engagement commands (doctor, sequences, enroll).

g-gremlin sequencer

[NS]

Sales sequencer integrations (Instantly, Smartlead, Apollo).

g-gremlin heyreach

[NS]

HeyReach activation helpers (doctor, campaigns, enroll).

g-gremlin amplemarket

[NS]

Amplemarket commands (doctor, whoami, sequences, enroll).

g-gremlin justcall

[NS]

JustCall integrations (SMS, WhatsApp, call logs).

BI & Analytics

Analytics platform namespaces for dashboards, semantic layers, and downstream reporting queries.

g-gremlin tableau

[NS]

Tableau Cloud helpers.

g-gremlin looker

[NS]

Looker helpers for dashboards and queries.

Visualization

Visualization helpers for charts in Google Sheets and Plotly-powered chart generation.

g-gremlin chart

[NS]

Google Sheets chart helpers.

g-gremlin viz

[NS]

Plotly visualization helpers.

Docs & Sinks

Publishing, storage, messaging, and notification sinks for moving outputs into downstream systems.

g-gremlin docs

[NS]

Documentation sinks (Notion, Outline, Confluence, Word).

g-gremlin gdocs

[NS]

Google Docs commands (create, read, update, append).

g-gremlin gslides

[NS]

Google Slides commands (read, export, create).

g-gremlin sink

[NS]

Land CSV data to external systems (BigQuery, S3, GCS).

g-gremlin pubsub

[NS]

Pub/Sub helpers (publish, pull).

g-gremlin notify

[NS]

Job-level notifications (webhook/Slack/email).

g-gremlin webhook

[NS]

Manage webhook profiles and test connectivity.

Ops & Auth

Operational guardrails, authentication, licensing, support, snapshots, recipes, provenance, and agent helpers.

g-gremlin doctor

[R]

Diagnose environment, auth, and connectivity.

g-gremlin auth

[NS]

Manage authentication and credentials.

g-gremlin license

[R]

Manage signed CLI license files and entitlement status.

g-gremlin support

[NS]

Submit support tickets to FoundryOps.

g-gremlin snapshot

[NS]

Snapshot management - the Time Machine.

g-gremlin recipe

[NS]

Data recipes built on top of core primitives.

g-gremlin script

[NS]

Apps Script helpers (pull/push/run bound scripts).

g-gremlin google

[NS]

Google OAuth helpers (CI token generation).

g-gremlin provenance

[NS]

Provenance utilities.

g-gremlin mcp

[NS]

Model Context Protocol helpers.

Autopilot

Pre-built workflow recipes and diagnostic scouts for recurring RevOps automation.

g-gremlin autopilot

[NS]

Gremlin Autopilot - pre-built workflow recipes for RevOps.

g-gremlin scout

[NS]

CRM hygiene scouts (diagnostic checks).

Safety & Conventions

Gremlin follows explicit opt-in patterns for changes. Review the plan, then apply intentionally.

Execution Conventions

--dry-run

Preview what will happen without mutating local files, Sheets, or external systems.

--apply

Execute a planned or staged operation after you have reviewed the proposed changes.

--yes

Explicit confirmation gate for mutating workflows and namespace-level apply commands.

Exit Codes

0 = success

1 = lint/issues

2 = usage

3 = remote/API failure

For AI agents: run g-gremlin help <cmd> --json for machine-readable command schemas.

Explore Related Docs

Use this page as the canonical command catalog, then jump into product, integration, and namespace-specific references as needed.

Gremlin CLI

Product overview, install path, and positioning for the full CLI.

HubSpot Reference

HubSpot-specific commands, safety flags, and pack workflows.

Integrations

Provider coverage for CRM, enrichment, sequencing, and sink connectors.

Docs Hub

Quickstart, playbooks, API docs, and supporting operational references.