google-sheets-sync

Synchronize Ganttlet task data with Google Sheets using OAuth2 and three-way merge.

Updated Feb 28, 2026

Search Tags:#oauth2 #task-tracking #google-sheets #data-sync #real-time-collaboration #sheets-api #three-way-merge

Ready to run

npx skills add https://github.com/IMBurbank/ganttlet --skill google-sheets-sync

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Google Sheets is used as the single source of truth for project data. Ganttlet uses a Y.Doc-based live session state to enable bidirectional synchronization between Sheets and the app, reducing manual data entry and ensuring consistent task data across platforms.

Core Features & Use Cases

SheetsAdapter, SheetsMapper.ts, and sheetsClient.ts coordinate bidirectional sync with a three-way merge to resolve conflicts.
OAuth2 flow handles authentication and token management for Google Sheets access.
Real-time collaboration and two-way sync allow updates in Sheet to reflect in Ganttlet and vice versa.

Quick Start

Connect Google Sheets to Ganttlet and start syncing tasks bidirectionally.

Frequently Asked Questions about google-sheets-sync

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

FAQPage Schema

How do I sync Google Sheets with project task data bidirectionally?▼

Bidirectional sync between Google Sheets and project tasks is achieved using a live session state that updates both platforms in real time. This maintains a single source of truth and reduces manual data entry across teams.

How does three-way merge handle conflicting edits during real-time collaboration in Google Sheets?▼

Three-way merge resolves conflicting edits by comparing the current Sheet state against the base version and recent task updates. This mechanism ensures data integrity when multiple users modify project plans simultaneously across platforms.

Do I need OAuth2 to connect Google Sheets API for data synchronization?▼

Yes, OAuth2 is required to handle authentication and token management for Google Sheets API access. This secure flow authorizes the application to read and update spreadsheet data during the synchronization process.

Can I import a project plan from Google Sheets and update progress automatically?▼

Importing project plans from Google Sheets allows you to update progress directly within the spreadsheet. The two-way synchronization reflects any Sheet modifications in your application and vice versa, ensuring consistent task tracking.

What is the best way to maintain a single source of truth for project data across teams?▼

Using Google Sheets as the single source of truth ensures project data consistency across teams. A dedicated adapter coordinates the mapping and synchronization process, automatically resolving conflicting edits to maintain accurate records.

Why are my Google Sheets updates not reflecting in real-time collaboration sessions?▼

Real-time collaboration relies on a continuous live session state to sync Google Sheets updates. If the connection is interrupted or the three-way merge encounters unresolved conflicting edits, updates may fail to reflect immediately.