Firebase / Firestore + Google Sheets

Create Firebase / Firestore documents from new spreadsheet rows (team drive) in Google Sheets

Effortlessly update your Firebase Firestore database whenever there's a new row added in your Google Sheets spreadsheet on Team Drive. With this workflow, each new spreadsheet row is instantly turned into a Cloud Firestore document, ensuring your information is up-to-date and easily accessible. Say goodbye to manual data entry and keep your Firestore records accurate and organized.

Effortlessly update your Firebase Firestore database whenever there's a new row added in your Google Sheets spreadsheet on Team Drive. With this workflow, each new spreadsheet row is instantly turned into a Cloud Firestore document, ensuring your information is up-to-date and easily accessible. Say goodbye to manual data entry and keep your Firestore records accurate and organized.

  1. When this happens...
    Firebase / FirestoreFirebase / Firestore
    Create Cloud Firestore Document

    Creates a new document within a Cloud Firestore collection.

    ActionWrite
  2. automatically do this!
    Google SheetsGoogle Sheets
    New Spreadsheet Row (Team Drive)

    Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

    TriggerScheduled
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