Help needed: Setting up basic Firestore query in Zapier

I’m struggling to create a simple connection between Zapier and Firestore. When I run a test, it keeps saying ‘We couldn’t find a record’. I’ve played around with different path and field strings, but nothing seems to work.

Here’s what I’ve tried:

Collection: users
Where: email, equals, [email protected]

Am I missing something obvious? Maybe there’s a trick to formatting the query that I’m not aware of. Any tips or suggestions would be really helpful. I’m pretty new to this, so even basic advice is welcome.

Has anyone else run into similar issues when connecting Zapier to Firestore? How did you solve it?

I encountered a similar issue when setting up Firestore queries in Zapier. One crucial step that’s often overlooked is ensuring you have the correct permissions set up in your Google Cloud project. Make sure the service account Zapier is using has the necessary read access to your Firestore database. Additionally, verify that your Firestore database is in the same region as specified in your Zapier connection. These factors can cause silent failures that manifest as ‘record not found’ errors. If you’ve double-checked these and still face issues, consider using a more specific query or temporarily broadening your search criteria to isolate the problem.

I’ve been down this road before, and it can be frustrating. One thing that helped me was to double-check the data types in Firestore. Sometimes, what looks like a string might actually be stored as a number or vice versa. This can cause silent failures in queries.

Another tip: try using the Firestore console to run the same query manually. If it works there but not in Zapier, you know the issue is with the integration, not your data.

Lastly, make sure your Firestore rules aren’t blocking access. Even with the right permissions, overly restrictive security rules can prevent Zapier from reading the data.

If all else fails, start with a broader query and gradually narrow it down. This can help pinpoint where things are going wrong.

yo, I had the same issue! turns out, case sensitivity matters big time. make sure ur email in firestore matches EXACTLY with what ur putting in zapier. also, double-check that the collection name is spot-on. those little things can trip u up. good luck!