Skip to content
  • Firebase / Firestore logoFirebase / Firestore logo
  • Google Sheets logoGoogle Sheets logo

Firebase / Firestore + Google Sheets

Update Google Sheets rows with new child objects from Firebase / Firestore in real time

Keep your Google Sheets up-to-date with the latest data from your Firebase Realtime Database. Once set up, each time a new child object is created in your Firebase or Firestore app, the corresponding row in a selected Google Sheets will be promptly updated. It's a streamlined solution for maintaining accurate real-time information and ensuring seamless data management across your databases and spreadsheets.

Keep your Google Sheets up-to-date with the latest data from your Firebase Realtime Database. Once set up, each time a new child object is created in your Firebase or Firestore app, the corresponding row in a selected Google Sheets will be promptly updated. It's a streamlined solution for maintaining accurate real-time information and ensuring seamless data management across your databases and spreadsheets.

  1. When this happens...
    Firebase / FirestoreFirebase / Firestore
    New Child Object in a Firebase Realtime Database

    Triggers when a new child object is discovered within a specific path.

    TriggerPolling
  2. automatically do this!
    Google SheetsGoogle Sheets
    Update Spreadsheet Row

    Update a row in a specific spreadsheet.

    ActionWrite
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

    • PathRequired

    • Order

    • Location of newest objects

    Trigger
    Polling
    Try It
    • PathRequired

    • Convert Numerics

    • New Id

    • Data

    Action
    Write
    • Api Docs Info

    • Stop on errorRequired

    • HTTP MethodRequired

    • URLRequired

    • Query string parameters

    • Additional request headers

    • Body

    Action
    Write
    • CollectionRequired

    • QueryRequired

    Action
    Search
    • CollectionRequired

    Trigger
    Polling
    Try It
    • CollectionRequired

    • Convert Numerics

    • Document ID

    • Data

    Action
    Write
    • PathRequired

    • Child keyRequired

    • Search valueRequired

    • Wrap search value in quotes

    • Location of best match

    Action
    Search
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Polling
    Try It
firebase logo
firebase logo

About Firebase / Firestore

Firebase Realtime Database and Google Cloud Firestore are flexible databases that give you the ability to easily store and sync app data at global scale.

Related categories

google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Related categories