Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi all,

I have an app that stores records in a Cloud Firestore using Firebase, I’m trying to get the information submitted into the app onto a Google Sheets spreadsheet using Zapier.

I created a new Zap and set it up as follows:

  1. New Document within a Firestore Collection
  2. Chose Account
  3. Customise Record with the follow query
        "orderBy": y{
            "field": {
                "fieldPath": "`Operative Name`"
            },
            "direction": "DESCENDING"
        }]
  4. Create Spreadsheet Row in Google Sheets
  5. Chose Account
  6. Chose Spreadsheet, then worksheet then added fields
  7. Sent test successfully

My concern is how can I have my spreadsheet update automatically each time the submit button is tapped on the app and have it added as a new row?

Right now I get the initial row I set it up with, but tapping submit in the app does nothing.

Really hope someone can help, it would be greatly appreciated!

I’m currently on the free plan.

Hi @NiallASD 

 

Just to double check that I’ve understood this correctly - when you tap submit in the app it adds a new document, is that right?

 

If that’s the case then the first thing that I would ask is how long you waited between tapping the submit button and waiting for the new row to be added? The New Document Within a Firestore Collection trigger isn’t instant. It’s a polling trigger, which means that it can take up to 15 minutes to trigger the Zap (depending on your plan). Have you tried turning on the Zap, submitting a document and then waiting to see if triggers the Zap?

 

The next thing to check is whether your Zap is triggering at all, or if it is being triggered but then running into and error.  You can check this by going to your task history. If you don’t see any tasks even though you know your trigger events have been happening, then it means that your Zap isn’t triggering. This guide has some troubleshooting steps that you can follow if your Zap isn’t triggering: Zap isn’t being triggered

 

I hope that all makes sense, let us know if you have any questions!

Hi Danvers,

Sorry I haven’t replied earlier, but I was unable to.

Thanks for the reply.

In Cloud Firestore, each time submit is tapped in the app it overwrites the previous data (unless it’s from a different signed in user).

I was able to create a Google Sheets API that lets me populate a spreadsheet (seen here), but I can’t get it to work with Firebase.

Basically, I’d like what the API allows - only through Zapier so that it will work with Firebase.

Hi @NiallASD - Thanks for following up with Danvers! I’m stepping in quickly here and wanted to escalate your topic to Zapier Support so they can take a deeper dive into what may be the issue. Please reply to the ticket that I have set up for us to continue to work on this together. Thanks!

Hey @NiallASD - It seems like we don’t trigger on Collections, but only Documents at this time. I’m glad that Support was able to help figure out what was going on and to be able to add you to the feature request interest list. We’ll contact you directly should this feature become available in the near future. Thanks so much!

Terms & Conditions