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

Firebase / Firestore + Google Sheets

Create spreadsheets in Google Sheets for new documents within a Firebase / Firestore collection

Stay on top of your data entries with this streamlined workflow. When a new document is added to a Firestore collection within Firebase, a spreadsheet is instantly created in Google Sheets. This seamless integration allows you to efficiently manage documents while maintaining a detailed and organized record in Google Sheets. Keep your data organized and accessible, saving you precious time and effort.

Stay on top of your data entries with this streamlined workflow. When a new document is added to a Firestore collection within Firebase, a spreadsheet is instantly created in Google Sheets. This seamless integration allows you to efficiently manage documents while maintaining a detailed and organized record in Google Sheets. Keep your data organized and accessible, saving you precious time and effort.

  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
    Create Spreadsheet

    Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

    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