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.

Over time our collection format has changed and the test data/collections available are missing fields we would like to import to a google sheet doc. We have several thousand collections, but unable to “load more” test data. Is it possible to select a particular record?

 

Hi @wwwilsun , the only way I’ve been able to use particular test data is by making sure its been the latest trigger point in that zap. Eg: If I wanted a particular record I would make sure it’s the last record entered. This can differ between apps on whether or not this is possible. What apps are you using/trying to achieve? 

@Seun Debiyi Thanks for the response. Using firebase/cloud firestore. Unfortunately, the documents are sorted random IDs. Relatively new to Zap; are there any workarounds that you can think of? Much appreciated. -Eric

 

*Update I am trying to use the funnel function import (to google sheets) only the doccuments in the collection that have the field, that is only available in the newer format.

@Seun Debiyi guessing this is an obvious solution and that I didn't define my issue well enough for you to understand. The solution was simply to place a new order document and change my query to the following:

"orderBy": :{
        "field": {
            "fieldPath": "order_submit_date"
        },
        "direction": "DESCENDING"
    }]

 

This returned the order document in Zap’s test data.  Just wanted to follow up...sorry if I wasted your time.  -Eric

Terms & Conditions