ConditionalVisibility

new-products-promo

connect-firebase-google-sheets-01-trigger-setup

connect-firebase-google-sheets-02-query

connect-firebase-google-sheets-03-trigger-test

connect-firebase-google-sheets-04-action-setup

connect-firebase-google-sheets-05-select-worksheet

connect-firebase-google-sheets-06-firebase-data

connect-firebase-google-sheets-07-firebase-data-entered

connect-firebase-google-sheets-08-successful-test

Zapier tutorials

connect-firebase-google-sheets-00-hero

Google Sheets

Firebase

Learn how to connect Firebase with Google Sheets to better analyze your app data.

How to connect Firebase to Google Sheets

When you have new documents added to your collection, you may want the details organized in your spreadsheet. This integration makes it easy. Set it up to automatically create a row in a Google Sheets spreadsheet when there is a new document within a Firestore collection. It's never been easier to organize your document details!

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.

Firebase / Firestore

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

New Child Object in a Firebase Realtime Database

Triggers when a [Structured Query](https://cloud.google.com/firestore/docs/reference/rest/v1beta1/StructuredQuery)
      returns new documents within a Cloud Firestore collection.

New Document Within a Firestore Collection

Finds a child object using a custom query that you provide.

Find Firebase Realtime Database Record

Finds a document using a [Structured Query](https://cloud.google.com/firestore/docs/reference/rest/v1beta1/StructuredQuery)
      within a collection.

Find Cloud Firestore Document

Creates or replaces a child object within your Firebase Realtime Database.

Create or Replace Firebase Realtime Database Record

Creates a new document within a Cloud Firestore collection.

Create Cloud Firestore Document

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

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

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

New Spreadsheet Row (Team Drive)

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

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

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

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

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

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

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

Update Spreadsheet Row(s)

Create Google Sheets rows for new documents in Firebase / Firestore collections

When you have new child objects added to your realtime database, you may want the details organized in your spreadsheet. This integration makes it easy by automatically creating a row in a Google Spreadsheet when there is a new child object in a realtime database in Firebase. It's never been easier to organize your database object details.

Create Google Sheet rows for new child objects in a Firebase / Firestore realtime database

If you have info on your spreadsheet that belongs in your database, this integration can help. Once active, it will automatically create/replace realtime database records in Firebase / Firestore with info from new/updated Google Sheet rows. You won't have to copy and paste to update your database anymore.

Create or replace Firebase / Firestore database records for new or updated Google Sheet rows

When you have info being added to a spreadsheet that also belongs in a document, this integration can connect your tools. Once active, it will automatically create a Firebase / Firestore document with info from a new row in a Google Sheet. You won't have to copy and paste to create documents again.

Create Firebase / Firestore documents for new Google Sheet rows

When you have important info being added to a spreadsheet, you may want the details saved to a cloud doc. This integration helps by automatically creating a Firestore cloud document when there are new or updated rows in a Google Sheet. You won't have to manually create docs again.

How to connect Firebase to Google Sheets

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.