Firebase / Firestore + Google Sheets

Update sheet properties in Google Sheets for new documents within a firestore collection in Firebase / Firestore

With this workflow, as soon as there's a new document in your Firebase / Firestore collection, the properties of a selected sheet within Google Sheets become updated. This helps to save time and effort by streamlining your data management process, keeping everything up-to-date and synchronized across platforms. Ideal for those who frequently work with documents on Firestore and need those changes reflected in their Google Sheets.

With this workflow, as soon as there's a new document in your Firebase / Firestore collection, the properties of a selected sheet within Google Sheets become updated. This helps to save time and effort by streamlining your data management process, keeping everything up-to-date and synchronized across platforms. Ideal for those who frequently work with documents on Firestore and need those changes reflected in their Google Sheets.

  1. When this happens...
    Firebase / FirestoreFirebase / Firestore
    New Document Within a Firestore Collection

    Triggers when a Structured Query returns new documents within a Cloud Firestore collection.

    TriggerPolling
  2. automatically do this!
    Google SheetsGoogle Sheets
    Change Sheet Properties

    Update Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.

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

Supported triggers and actions

    • 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.
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