Introducing Firetable: simplicity of spreadsheets meets the power of Firestore

Harini Janakiraman
Sep 5 · 5 min read
Image for post
Image for post

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 🙏

Use the Firetable CLI to get setup or use manual clone of the app

Image for post
Image for post
Image for post
Image for post
Firetable CLI

Hit the ground running on your existing datasets, using our simple step by step guided setup wizard screens.

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Table Setup Wizard

👉 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:

Image for post
Image for post

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.

Image for post
Image for post
Image for post
Image for post

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

So if this is you and would like to try out or have any questions, please connect with us at engineering@antler.co or my twitter DMs are always open 🙌

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 👈

Antler is a global early-stage VC firm that builds and…

Harini Janakiraman

Written by

Global Head of Technology @Antler. Prev: VP - Engineering @BlackRock. Started #100DaysOfCode #WomenInTech

Antler Global

Antler is a global early-stage VC firm that builds and invests in groundbreaking technology companies.

Harini Janakiraman

Written by

Global Head of Technology @Antler. Prev: VP - Engineering @BlackRock. Started #100DaysOfCode #WomenInTech

Antler Global

Antler is a global early-stage VC firm that builds and invests in groundbreaking technology companies.

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store