skills.rest
shantum
shantumCOMMUNITY
Explore all skills by this author →
GitHub

google-sheets

Synchronize Google Sheets and ERP inventory transactions with batch processing and deduplication.

Updated Aug 27, 2026
Search Tags:#google-sheets#inventory-management#data-synchronization#erp-integration#buffer-tabs#order-fulfillment
One-click install
npx skills add https://github.com/shantum/COH-ERP2 --skill google-sheets-shantum
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/shantum/COH-ERP2/tree/main/.claude/skills/google-sheets
Command: npx skills add https://github.com/shantum/COH-ERP2 --skill google-sheets-shantum

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

The Google Sheets Hybrid System bridges operations between Google Sheets (used by the ops team) and the ERP database. It handles three core flows: Move Shipped → Outward, Ingest Buffer Tabs, Write Balances Back. The system is designed so that ingestion never changes the displayed balance due to the combined view formula.

Core Features & Use Cases

  • Ingest Inward (Live): Reads Inward (Live) and creates ERP InventoryTransaction records, then updates balances and deletes ingested rows.
  • Move Shipped → Outward: Copies shipped rows from the Orders from COH tab to Outward (Live) for ERP ingestion.
  • Ingest Outward & Balance Sync: Reads Outward (Live), creates OUTWARD transactions, links to OrderLines, and updates both Inventory and Balance Final sheets.
  • Use Case: Ops teams maintain inventory buffers across Sheets and ERP with a single source of truth, enabling automatic reconciliation and reduced manual data handling.

Quick Start

Enable the Sheet Offload feature, configure your Mastersheet IDs and tab mappings in server/config/sync/sheets.ts, and start the offload scheduler. Then monitor the OffloadMonitor UI for status and buffer counts.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I synchronize inventory data between Google Sheets and an ERP system?▼

Inventory data synchronization between Google Sheets and an ERP system is automated by orchestrating inward and outward transactions, balancing updates, and managing buffer tabs to maintain a single source of truth for operations teams.

What is the best way to prevent double counting during ERP data ingestion from Sheets?▼

To prevent double counting during ERP data ingestion, the system applies a single-view balance invariant and uses reference IDs for batch deduplication, ensuring ingestion never changes the displayed balance due to the combined view formula.

How do I automate order fulfillment by moving shipped rows for ERP ingestion?▼

Order fulfillment is automated by copying shipped rows from the Orders tab to the Outward tab, creating linked OUTWARD transactions in the ERP, and updating both Inventory and Balance Final sheets.

How do I configure Google Sheets tab mappings for ERP integration?▼

Tab mappings for ERP integration are configured by defining Mastersheet IDs and specific tab mappings within the server configuration file, enabling the scheduler to process inward and outward data flows.

Can I use batch processing for Google Sheets inventory transactions?▼

Batch processing is supported for Google Sheets inventory transactions, allowing operations teams to handle bulk data synchronization, apply reference ID deduplication, and maintain real-time balance visibility across Sheets and the ERP.

When should I not use Google Sheets for ERP inventory buffer management?▼

Google Sheets for ERP inventory buffer management is not ideal when operations require complex relational queries beyond tab synchronization, as the system relies on specific sheet structures and combined view formulas to prevent balance changes during ingestion.

Related Skills

Explore More Software Engineering Skills→
etendosoftwareetendosoftware
1

/etendo:window

Automate Etendo ERP window, tab, and field creation with SQL validation.

Official
Advanced
statesetstateset

commerce-orders

Automate order lifecycle management across stateset-orders and stateset-direct workflows.

Official
Intermediate
glideappsglideapps
10

api

Manage Glide Big Tables data via REST API v2 and @glideapps/tables.

Official
Intermediate
Tres-Finance-PublicTres-Finance-Public

tres-invoice-bill-matching

Match TRES ledger transactions to ERP invoices or bills.

Official
Intermediate