Rowy

Rowy is an open-source, self-hosted web app and server that provides a spreadsheet interface for managing databases. It functions as a low-code platform for creating backends, specifically designed for users of Firebase and Google Cloud Platform. The software allows teams to manage their data visually while maintaining the ability to write custom logic.

The software is deployed as a Cloud Run instance within a user's own Google Cloud project. This architecture ensures that data and cloud functions remain on the user's own Firestore and GCP infrastructure rather than being stored on external servers. This deployment model allows for direct interaction with the database while providing a user friendly administrative layer for non-technical team members.

Key features

• CMS interface for Firestore with CRUD operations
• Bulk data import and export via CSV, JSON, and TSV
• Cloud function workflows triggered by field level data changes
• Pre-built connectors for SendGrid, Algolia, Twilio, and BigQuery
• Diverse field types including JSON, Markdown, and rich text editors
• Action fields that serve as clickable triggers for cloud functions
• Aggregate fields to populate values from sub-tables
• Role based access controls for table and field level permissions
• Built in user management with customizable views for different roles

Rowy is built for developers and teams who need a visual way to manage Firestore data without sacrificing the ability to write custom TypeScript code. It allows for the integration of any NPM module or API directly within the browser, enabling the creation of complex automations. The platform supports complex data relationships through connector fields and can fetch data from any HTTP endpoint via connect service fields. Users can lock, freeze, resize, hide, and rename columns to organize their workspace, and create multiple views for the same collection to suit different operational needs.

It is a backend-as-a-service tool that bridges the gap between a no-code spreadsheet and a fully programmable cloud backend.