Connect Google Sheets to ActiveCollab — manage tasks directly from your spreadsheet.
Русский · User guide · API · Deployment · License
SheetCollab integrates Google Sheets ↔ ActiveCollab using Google Apps Script and a Laravel backend. Select a spreadsheet row, request synchronization, and let the application create, update or skip the corresponding ActiveCollab task. Each sync attempt is recorded for inspection and recovery.
The project is designed for multiple spreadsheets, integrations and users, with scoped access and explicit administrative workflows.
| Area | What it provides |
|---|---|
| Task synchronization | Create or update ActiveCollab tasks from spreadsheet records |
| Multiple integrations | Configure connections and integrations for different spreadsheets |
| Access control | Manage users, roles, integration membership and individual tokens |
| Admin interface | Manage configurations, connections, exports and recovery in Orchid |
| Traceability | Record synchronization attempts and administrative changes |
| Recovery | Handle uncertain outcomes and conflicting task bindings explicitly |
| Deployment | Local Docker Compose workflow and a separate production configuration |
Google Sheets
│ Select row → ActiveCollab → Sync task
▼
Google Apps Script
│ Scoped integration token over HTTPS
▼
SheetCollab API (Laravel)
│ Validation → service → repository
▼
ActiveCollab tasks
The ActiveCollab API credentials stay on the SheetCollab server. Apps Script uses its own scoped integration token. Spreadsheet rows retain stable UUID identifiers; do not manually edit UUIDs.
Safety: an uncertain create response must be reconciled before another create attempt. The system must not blindly retry tasks with unknown outcomes.
| Layer | Stack |
|---|---|
| Backend | PHP 8.5.12+, Laravel 13 |
| Administration | Orchid 14 |
| Database | MariaDB (local runtime); SQLite (standard tests) |
| Frontend tooling | Node.js 26, Vite 8, Tailwind CSS 4 |
| Integration | Google Apps Script, ActiveCollab API |
| Infrastructure | Docker Compose / Laravel Sail for development; dedicated production image |
See composer.json and package.json for constraints and their lock files for pinned dependencies.
Requires Git, Docker Compose, PHP 8.5.12+ and Composer 2.
git clone https://github.com/Yatseck-k/SheetCollab.git
cd SheetCollab
composer install
cp .env.example .env
make up
make artisan CMD='key:generate'
make setupOpen http://localhost/admin (or the configured APP_PORT). Local seed credentials are for development only: never use them in production.
- Add an ActiveCollab connection and a spreadsheet integration in Orchid.
- Grant the intended users access and issue an individual integration token.
- Export the Apps Script from Orchid and configure
INTEGRATION_SERVICE_URLandINTEGRATION_SERVICE_TOKENin Script Properties. - Complete the documented spreadsheet UUID migration before synchronization.
- Select a row and run ActiveCollab → Sync task.
Apps Script requires a public HTTPS endpoint; it cannot call a server bound to localhost.
make up
make down
make test
make lint
make analyse
make check
make migrate
make artisan CMD='route:list'
make logsmake check runs the project's checks; see Development for test database isolation and safety requirements.
- User and administrator guide
- API reference
- Local development and testing
- Production deployment, migrations and recovery
Production upgrades require database backups and a controlled migration procedure. Follow the deployment guide; do not treat the local development setup as a production installation.
MIT.