At a Glance:
Rowy is an open-source low-code platform that combines a spreadsheet-like UI for Firestore with the ability to build backend Cloud Functions, offering database management and automation for Google Cloud.
Overview:
Rowy is a low-code platform for managing Firestore databases and building backend automations on Google Cloud. It provides a spreadsheet interface for performing CRUD operations on Firestore, allowing users to import, export, sort, and filter data. Beyond data management, Rowy enables the creation of Cloud Functions triggered by field-level data changes, using any NPM module or API. The platform is deployed via a Cloud Run instance on a user's own GCP project, with all data and functions remaining within their own Firestore and Google Cloud environment.
Key Decision Points:
Data Stays on Your GCP Project: Rowy operates through a Cloud Run instance within your own Google Cloud project, meaning it does not access or store your data on its own systems.
Low-Code Backend Automation: Users can build workflow automations by writing Cloud Functions that trigger on Firestore data changes, using any NPM module or external API.
Target Users: The tool is built specifically for developers working with Firebase and Google Cloud, offering a managed UI for database interactions and function deployment.
Team Collaboration: Granular, role-based access controls are provided at the table and field levels, allowing customized views for different user roles.
Core Features:
Spreadsheet Interface for Firestore: A visual, Airtable-like UI for performing CRUD operations, with bulk import/export for CSV, JSON, and TSV files.
Cloud Function Workflows: Create backend automations that run in response to field-level data changes, with the ability to leverage any NPM module or connect to external services like SendGrid, Algolia, and Twilio.
Customizable Data Fields: Over 30 field types are supported, including basic text, custom UI pickers like date and multi-select, uploaders, and rich editors for JSON, Code, HTML, and Markdown.
Field-Level Logic and Connectivity: Includes an Action field to trigger any Cloud Function, an Aggregate field to populate cells from sub-tables, and a Connector field to link data across multiple collections.
Role-Based Access Control: Manage user permissions at a granular level to control access to specific tables and fields, with built-in user management.
Use Cases:
Developers can use Rowy’s spreadsheet interface as a lightweight CMS to manage Firestore database content quickly.
Users can build custom backend automations, such as triggering an email via SendGrid when a specific field in a document is updated, without leaving the browser.
Teams working on Firebase projects can manage their database and collaborate by setting custom data views based on user roles.
Data managers can use the Connector and Aggregate fields to link data across multiple collections and derive values from sub-tables without writing custom query logic.
Open-Source Alternative Value:
As an open-source tool, Rowy provides a self-managed interface for Firestore and backend automation that runs entirely on a user's own Google Cloud Platform account, ensuring data does not pass through a third-party service. Its value lies in combining visual database management with a low-code environment for writing and deploying Cloud Functions, which is directly tied to a project's existing Firebase/GCP infrastructure. This approach allows developers to use a spreadsheet-like UI to manage data and build automations while keeping all operations within their controlled cloud environment.
