Firebase / Firestore + Google Sheets

Update Google Sheets rows with new child objects in Firebase / Firestore database

Keep your Google Sheets updated in real-time by setting up this seamless workflow with Firebase / Firestore. When a new child object is added to your Firebase Realtime Database, this automation instantly updates relevant rows in your selected spreadsheet on Google Sheets. This results in immediate, accurate database reflections in your spreadsheets without manual intervention, saving you significant time and effort.

Keep your Google Sheets updated in real-time by setting up this seamless workflow with Firebase / Firestore. When a new child object is added to your Firebase Realtime Database, this automation instantly updates relevant rows in your selected spreadsheet on Google Sheets. This results in immediate, accurate database reflections in your spreadsheets without manual intervention, saving you significant time and effort.

  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.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Update Spreadsheet Row(s)

    Update one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • PathRequired

    • Order

    • Location of newest objects

    Trigger
    Scheduled
    Try It
    • PathRequired

    • Convert Numerics

    • New Id

    • Data

    Action
    Write
    • HTTP MethodRequired

    • URLRequired

    • Query String Parameters

    • Headers

    • Additional Request Headers

    • Body

    Action
    Write
    • CollectionRequired

    • QueryRequired

    Action
    Search
    • CollectionRequired

    Trigger
    Scheduled
    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
    Scheduled
    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.
Learn more

Related categories

  • Databases

Similar apps

MySQL integrationsMySQL integrations

MySQL

Databases
PostgreSQL integrationsPostgreSQL integrations

PostgreSQL

Databases
SQL Server integrationsSQL Server integrations

SQL Server

Databases
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.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets