Imagine this, you are building a startup and have a small engineering team focused on the product. As you build and grow, you probably run into some of the following challenges and requirements.
⚙️ Operational Portal — Interface to allow for easy access to database for non-technical/operational users — who has used the most recent feature, who is your most valuable customer, custom KPIs tracking etc
🙅🏻♀️ Access Control — Setup and maintain access control to the data to different internal/external user groups — CRUD tasks, data perms and protection rules, user groups management
👾 Automation Tasks — Build automation tasks and cloud functions on the data to trigger events such as slack messages on new customer signup, send emails alert for bugs… and maybe woof ;)
📈 Data Validation — Validate data manual data entered for errors, alerts because they cause production errors
Do you invest your precious engineering resource to build internal tools and automation tasks or invest in growth of your product? The answer is obvious: everything takes a backseat compared to your revenue driver.
We saw this pattern of problem emerge at Antler (a global early stage VC, with investments in 180+ companies) and repeatedly amongst many of our portfolio companies. We researched and did not find a compelling solution focused on Google Firestore as the core infrastructure, so we decided to built it and make it available to the world 🤗
Introducing Firetable, an open source self hosted platform that allows you to leverage the scalable infrastructure of Google Firestore with the ease and simplicity of a spreadsheet. Powered with accessible UI based Google cloud functions, Webhooks, automation, integrations with popular tools to enable you to ship faster!
I know there will be a lot of questions, so let me try answering them preemptively here 🙏
How to get started?
Hit the ground running on your existing datasets, using our simple step by step guided setup wizard screens.
How are we different?
👉 From other spreadsheet like UI products (Google Docs, Airtable, and similar)
In terms of UI, Firetable is highly accessible and intuitive similar to other platforms. However,
📲 Where it shines is in its LIVE nature. Firetable is connected to your data source on Firebase and any changes to the data on the UI is reflected on your data store directly. Say goodbye to emailing “FINAL” Excel sheets. This gives immense power in terms of a true operational dashboard to your non-technical teams. But as they say with great power comes great responsibility, you do not want to mess up your production data! Firetable has data validation controls in form of cloud functions/scripting capability along with user access controls to enable checks.
👉 From other products in internal tools space
We are super focused on Google Firebase and optimised for it. Unlike other internal products out there that offer a wide array of data connections and thereby diluted in feature richness of the product. Highlighting some below:
Wide range of unique data columns ranging from as JSON, Images, Single/Multi selects to connected tables, subtables, trigger scripts, derivative functions, users ids (created by, updated by), action buttons and more! With over 25 different field types and intuitive UIs, you can monitor and update just about any data type you can imagine.
Fully functioning cloud functions and scripting support with code action column — run and undo support. You can allow specific user groups with power to run scripts with customizable confirmation pop ups.
Integrations: typeform, sendgrid, algolia, apis, webhooks, CSV import/export, big query and more coming soon
We are also open-source 🤗 That means you can manage and self host it yourself and no worry about data snooping concerns, you fully own and control your data! Try out the DEMO.
Who are our users?
Developer: Build and ship products fast. Firetable enables developers to setup data infrastructure quickly.
Ops: Take actions on day to day operational tasks with spreadsheet like interface.
Editor: Monitor and update data to allow for high control on your product
Admin: Super users who can create data tables and control access
You can also be the first to get Firetable Cloud beta access, sign up here.
If you are launching a product and hungry to build your next company, we at Antler would love to hear from you. We are accepting applications all across the world! Apply here 👈