skills.rest
usecompai
usecompaiOFFICIAL
Explore all skills by this author →
GitHub

sell-through-dashboard-sync

Sync sales and inventory metrics from Shopify and POS into a Google Sheet with Slack alerts.

24|8|Updated Mar 9, 2026
Search Tags:#Google Sheets#sync#sales analytics#Slack#inventory management
One-click install
npx skills add https://github.com/usecompai/compound-operations-model --skill sell-through-dashboard-sync
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sell-through-dashboard-sync
Source: https://github.com/usecompai/compound-operations-model/tree/main/skills/sell-through-dashboard-sync
Command: npx skills add https://github.com/usecompai/compound-operations-model --skill sell-through-dashboard-sync

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires shopify, pos, google-sheets, slack, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automatically syncs sales and inventory metrics from Shopify, POS, and ROS/WOS/ST/Dispuesto by SKU, updates a Google Sheet, and sends Slack alerts for actionable changes.

Core Features & Use Cases

  • Sales and Inventory Sync: Integrates data from Shopify sales, POS/inventory system stock, and ROS/WOS/ST/Dispuesto metrics.
  • Google Sheet Update: Updates a designated Google Sheet with calculated metrics.
  • Slack Alerts: Sends Slack alerts for changes in key metrics or sync failures.
  • Use Case: Use this Skill to stay informed about inventory levels and sales performance, receive timely alerts for stockouts or low stock situations, and keep track of your sales trends.

Quick Start

Use the 'sell-through-dashboard-sync' skill to sync and alert on the dashboard metrics.

Frequently Asked Questions about sell-through-dashboard-sync

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I sync Shopify and POS inventory data into Google Sheets?▼

This Skill synchronizes sales and inventory metrics by pulling Shopify sales data and POS inventory data into a central Google Sheet, organizing everything by SKU with ROS, WOS, ST, and Dispuesto calculations.

Can I send Slack alerts when inventory drops below a certain threshold?▼

Yes, this Skill sends Slack alerts via the Slack API when inventory thresholds are crossed, helping you stay informed about stockouts, low stock situations, and changes in key sales metrics.

Does this approach require both Shopify and POS APIs to calculate sell-through metrics?▼

Yes, the Skill requires both the Shopify API for sales data and the POS API for inventory data to accurately calculate and sync ROS, WOS, ST, and Dispuesto metrics by SKU into your Google Sheet.

What is the best way to automate sales analytics reporting for stock levels?▼

Automating sales analytics reporting is best achieved by syncing Shopify and POS data into a central Google Sheet, which automatically calculates ROS, WOS, ST, and Dispuesto metrics by SKU and sends Slack alerts for actionable changes.

What happens if the Google Sheets sync fails during an inventory update?▼

If the Google Sheets sync fails, the Skill sends a Slack alert to notify you of the sync failure, ensuring you are immediately aware of any data discrepancies or connection issues with the Shopify or POS APIs.

Related Skills

Explore More Data & Analytics Skills→
ProyectoG007ProyectoG007

api-gateway

Call native endpoints of over 100 third-party APIs via managed OAuth connections.

Community
Advanced
nicolasnortonnicolasnorton
1

data-analysis

Analyze CSV or JSON datasets to generate charts and summary reports.

Community
Basic
mahmoud20138mahmoud20138
10

real-time-risk-monitor

Monitor live portfolio exposure and drawdown with threshold-based alerts and kill switches.

Community
Advanced
usecompaiusecompai
24

shopify-inventory-sync

Synchronize inventory data across Shopify, POS systems, and 3PL providers.

Official
Intermediate