When this happens...
Google SheetsNew Spreadsheet Row
Then do this...
FirebaseCreate Child Record

Using a Google Sheets spreadsheet is the quick and easy way to collate contact data from different sources. Zapier can automatically add this data into your Firebase application as you capture the data. You must have a row of column headers and at least one entry in your spreadsheet when you set up the integration. So to get started, simply create a spreadsheet with a row of column headings to match your data needs, and at least one row of data.

Once you set up this integration, new Google Sheet spreadsheet rows added from that point forward are individually added to your Firebase application as new records.

Note: This Zapier integration doesn't create Firebase records from Google Sheets spreadsheet rows that already exist in the spreadsheet, only rows added to the bottom of the spreadhsheet after you've set it up.

How It Works

  1. A new spreadsheet row is added to the bottom of the Google Sheets spreadsheet
  2. Zapier adds the data in that row to Firebase as a new record

What You Need

  • A Google Apps account
  • A Firebase application

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,000+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

It's easy to connect Firebase + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
Google Sheets
New or Updated Spreadsheet Row

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

Firebase
Create Child Record

Add a new record to Firebase using the push() API (https://www.firebase.com/docs/javascript/firebase/push.html)

Google Sheets
New Spreadsheet Row

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

Firebase
Update/Set record by ID

Calls update() on the path provided. Will create the record if it does not already exist or update it if it does.

Google Sheets
New Worksheet

Triggered when you create a new worksheet in a spreadsheet.

Firebase
Delete record by ID

Remove a record from Firebase

Google Sheets
New Spreadsheet

Triggered when you create a new spreadsheet.

Google Sheets
Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Google Sheets
Update Spreadsheet Row

Update a row in a specific spreadsheet.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

Firebase is a real-time data persistence layer, which stores data and also pushes updates to any client listening on the updated records, scaling to hundreds of thousands of users automagically.

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