Query and manage data across 40+ marketing platforms from your terminal. Built for autonomous AI agents, usable by humans.
$ npm install -g insightfulpipeInstall globally, authenticate with your API token, and start querying.
# Install the CLI
$ npm install -g insightfulpipe
# Authenticate with your API token
$ insightfulpipe login
? Enter your API token (ip_sk_...): ********
✓ Authenticated as My Agency
# List connected platforms
$ insightfulpipe platforms
google-analytics Google Analytics 4 3 properties
facebook-ads Facebook Ads 2 ad accounts
shopify Shopify 1 store
# Query your data
$ insightfulpipe query google-analytics \
-b '{"action":"run_report","date_range":"last_30_days"}'
{ "sessions": 12847, "users": 9231, "bounce_rate": 0.42 }
Designed from the ground up to work with AI agents and programmatic workflows.
Structured JSON outputs designed for AI agents. Works with OpenClaw, Claude Code, and any LLM-based agent.
Query Google Analytics, Facebook Ads, Shopify, HubSpot, and dozens more from a single CLI.
API tokens stored securely in your system keychain. No credentials in environment variables.
Discover accounts, inspect schemas, then query — a workflow AI agents understand natively.
Not just reports — create posts, update records, and take actions across platforms.
Published on ClawHub as a skill. Any OpenClaw-compatible agent can discover and use it automatically.
A discover-schema-execute workflow that AI agents understand natively.
List connected platforms and accounts to find the data source you need.
$ insightfulpipe accounts \
--platform google-analytics
# Returns workspace, brand, and account IDs
Get the exact request structure, required fields, and available metrics.
$ insightfulpipe helper \
google-analytics
# Returns available actions & fields
Run read queries or write actions using the schema you discovered.
$ insightfulpipe query \
google-analytics -b '{...}'
# Returns structured JSON data
OpenClaw is an open-source AI agent ecosystem. InsightfulPipe is published on ClawHub as a skill — any OpenClaw-compatible agent can discover and use it automatically.
Agents discover capabilities through SKILL.md — no hardcoded integrations needed.
Works with any agent that can execute shell commands — Claude Code, OpenClaw, and more.
Agents can schedule recurring tasks, monitor metrics, and act on changes autonomously.
# Install InsightfulPipe as an OpenClaw skill
$ npm install -g insightfulpipe
# Set your API token
$ export INSIGHTFULPIPE_TOKEN=ip_sk_...
# Your agent can now discover and use InsightfulPipe
$ insightfulpipe doctor
✓ Token valid
✓ 12 platforms connected
✓ SKILL.md found — agent-ready
Claude Code can autonomously execute InsightfulPipe commands to pull reports, analyze data, and take actions.
# Ask Claude to analyze your marketing data
> Pull last month's Google Analytics report
> and compare it with Facebook Ads spend
# Claude autonomously runs:
$ insightfulpipe query google-analytics \
-b '{"action":"run_report","date_range":"last_month"}'
$ insightfulpipe query facebook-ads \
-b '{"action":"campaigns","date_range":"last_month"}'
✓ Reports fetched and compared. Here's the analysis...
| Command | Description |
|---|---|
| login | Authenticate with your API token |
| whoami | Show current authenticated user |
| platforms | List connected platforms and accounts |
| accounts | Get workspace and brand details for a platform |
| helper | Inspect available actions and schema for a platform |
| query | Run a read query against a platform |
| action | Execute a write action on a platform |
| doctor | Check configuration, token, and connectivity |
One CLI to rule them all. Query any connected platform with the same workflow.
Install the CLI, connect your platforms, and let your AI agents do the rest.