aurora-sheets-sync

Name: aurora-sheets-sync
Availability: InStock
Author: Avvale

Synchronize Aurora YAML schemas bidirectionally with Google Sheets.

1|Updated Jun 20, 2022

Search Tags:#synchronization #CLI #yaml #spreadsheet #nodejs #google-sheets #module-context

Ready to run

npx skills add https://github.com/avvale/aurora-front --skill aurora-sheets-sync

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: aurora-sheets-sync
Source: https://github.com/avvale/aurora-front/tree/main/.claude/skills/aurora-sheets-sync
Command: npx skills add https://github.com/avvale/aurora-front --skill aurora-sheets-sync

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill keeps Aurora YAML schemas and Google Sheets in sync, eliminating manual duplication and drift between design definitions and spreadsheet data.

Core Features & Use Cases

Bidirectional Sync: Push YAML schemas to Google Sheets and pull updates back into YAML.
Idempotent Pulls: Only modify YAML when there are actual changes; preserves formatting and fields not represented in the sheet.
Module-Oriented Workflows: Operates on bounded contexts (e.g., a module like business-partner) with per-module sheets and automatic mapping rules.

Quick Start

Use the aurora-sheets-sync skill to synchronize your YAML schemas with Google Sheets by running push and pull commands, for example:

npx ts-node src/index.ts push --bc business-partner-portal
npx ts-node src/index.ts pull --bc business-partner-portal

Frequently Asked Questions about aurora-sheets-sync

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

FAQPage Schema

How do I sync YAML schemas with Google Sheets automatically?▼

You can sync YAML schemas with Google Sheets using a Node.js CLI that executes bidirectional push and pull operations. This automation maps bounded module contexts to specific spreadsheets, eliminating manual duplication and keeping design definitions aligned.

How does pulling Google Sheets updates affect existing YAML formatting?▼

Pulling Google Sheets updates into YAML uses idempotent operations that only modify files when actual changes are detected. This process safely preserves existing YAML formatting and retains fields not represented in the target spreadsheet.

Can I synchronize Google Sheets for a specific module context?▼

Yes, you can synchronize Google Sheets for a specific bounded module context by passing the module name as a CLI argument. The tool applies automatic mapping rules to push and pull operations for that individual module context.

Does the YAML to spreadsheet synchronization handle arrays and complex mapping rules?▼

Yes, the YAML to spreadsheet synchronization handles arrays and complex mapping rules across module contexts. It safely manages field preservation and applies specific mapping logic during bidirectional push and pull operations.

Do I need Node.js to run the Google Sheets and YAML synchronization commands?▼

Yes, you need Node.js to run the synchronization commands because the CLI is built on it. The push and pull operations are executed via TypeScript Node commands like npx ts-node src/index.ts.