Get Support Have a question? Let's get you an answer!
Other Help Resources Wait, there's more! Check out these Community sourced spaces for additional resources.
Learning Resources All of our best learning resources can be found here.
Share your knowledge Give back to the Community by sharing your automation wins and helping to answer questions.
Other Learning Resources Some of our favorite additional ways to upskill your Zapier knowledge.
Product Updates Check out what is new and upcoming with Zapier with our regular product updates.
Early Access Program Want to join Early Access? Learn more here.
This post was split from the topic: What will be the Path for Firebase Real Time Database for Trigger as each path is saying unable to pull records - 404 not found? Sorry to hear you’re now running into a 404 error here, @Fsl. I did some checking and it looks like we’ll sometimes see a 404 when the account connection to Firebase/Firestore was added with the Project ID and it needs to use the RTDB (Realtime Database) Project ID instead. Can you reconnect your app account and use the projectId in the following format: projectId-default-rtdb. For example, if your projectId was project123 you’d use: project123-default-rtdb After it’s reconnected with the RTDB Project ID, could you try pulling in a new test record and confirm whether that works? Hi, I have used this new format and the connection is failing. “Unable to verify that your connection has access to the Firebase/Firestore project "edexia-default-rtdb””
Below is a screenshot of my process. The JavaScript code goes through each Shopify order line item & calculates a sum of the total number of items orders. (Output = {Sum}) I then loop through the rest of the process from 1 to Sum (num of items) In this loop: I query a Google Sheet to get all values in column A Retrieve the last value in the column Delete that value from the sheet Create a Firestore document with the following fields: Buyer Name Buyer Email Buyer Address The retrieved value from the Google Sheet This is the problem in a case study: The new order has a total quantity of 4 items 4 Documents are created in Firestore/Firebase The first document has the correct retrieved value from the Google Sheet Documents 2-4 all have the same retrieved value from the Google Sheet. Different from the first, but the same from 2-4. It is as the Google sheet actions are only triggered one time. The rest of the loop iterations just use the same retrieved value as document 2.
Hi all, Is it possible to update an specific Firestore document with Zapier?
Hey Everyone, I created this question because I could not find an existing post and thought there must be others running into this same issue or others that have run into it in the past. Thanks for your help! High Level Goal: Listen for new updates to a Firestore Collection, extract the email, add to a mailchimp list. Problem: Using the below query, I receive an error that certain filters are not supported in Firestore v1beta1. It says to upgrade to v1. What I need help with: I know that I have to somehow upgrade to use Firestore v1, however, I cannot for the life of me figure out where to do this. My best guess is that v1beta1 is the internal Zap endpoint being used and I’ll likely just have to wait until they update Firebase to use the latest version. Details on my Zap Query "where": { "fieldFilter": { "field": { "fieldPath": "email" }, "op": "NOT_IN", "value": { "stringValue": "" } } }, "orderBy": [{ "field": { "fieldPath": "followedUp?" }, "direction": "DESCENDING" }] Error receive
I want to automate a trigger, that for a new user on my firestore database I create a new customer on bitrix 24. But it always shows me a query error of “unable to pull records” or that “Error code: Error while retrieving: The setting "orderBy" is required. Please help.
Unable to pull records.When I try to connect firebase to zoho crm.what path I should define in the trigger?Every time it says Unable to pull records.
Hi, I´m looking for an example of a firestore query to select a single record. I know the doc ID I want to select. Please only real examples, and no suggestions to read the documentation - its “poor” (being really polite). "where": { "fieldFilter": { "field": { "fieldPath": "__name__" }, "op": "EQUAL", "value": { "referenceValue": "projects/adventure-hunt-323xxx/databases/(default)/documents/CollectionName/xxxxxxxxxxx } } }, xxxxxxxxxxxx is the value I want to search for.
Hello, I'm trying to connect Firebase/Firestore to Zapier to automate data transfer from Google Sheets to Firestore. However, I'm encountering an issue during the connection process. The error message I'm receiving is: "Unable to verify that your connection has access to the Firebase/Firestore project 'personalgrowthautomation'". Here are the steps I've taken so far to troubleshoot the issue: Checked that my Google account has "Owner" permissions for the Firebase project. Verified that I'm using the correct Firebase Project ID. Tried disconnecting and reconnecting Firebase to Zapier. Checked that the Firestore database is set up correctly and accessible through the Firebase console. Checked Google Cloud Platform permissions and ensured my account has the necessary permissions. Enabled the Cloud Firestore API in the Google Cloud Platform console. Tried connecting Firebase to Zapier in a different browser and in incognito mode. Despite these steps, I'm still encountering the same error.
Hi, when the action zap is create firestore document, I want to be able to specify the data type of a particular field if it is not string. Or if there's an option to pass data as json. This has been requested many times I just wanted to add my vote to it being built! Other requests: (tried formatter and code in some of these responses, data still gets put in as string)
Can I please be added to the list of people who will be notified when this is available?
My goal is to write Typeform answers to Firebase. I'm getting the following error, "Failed to create a record in Firebase / Firestore Error code 404: 404 Not Found". I’ve posted screenshots of my Typeform, Zapier, and Firebase configurations below. Can you see what I’m doing wrong? My setup in Typeform: My setup in Zapier: Inputs. Note: the placeholder answer is different here as I deleted it on the Typeform side when testing. I also set the Data key to “textQuestion” below (and in Cloud Firestore), given this help article: https://help.zapier.com/hc/en-us/articles/8495993033997#my-form-responses-stopped-sending-to-the-other-app-s-in-my-zap-0-0 Testing action Error message shown My setup in Firebase (Cloud Firestore, not the Realtime Database):
The Firebase transfer allows to create new records in Firestore database. But, there is no way to update a record. It only allows to create and update selection on Firebase Realtime Database. Will there be support to not only create but update documents in Firestore Database ?
order : Top of Result and Bottom of Result both Option are try but seeing same error My Selected event is here… i try to read “employeeName” in Firebase and create new post in tribe application
I have done data integration for postgresql and firestore.. Is it possible - if i update a field in postgres or firestore will it reflect in another db..?
Hi, I have a firestore database and I want to connect it with zapier. Above is the database structure. I want to fetch the data of all breaks, how can I write structured query for the above data. This is the query I wrote but it is giving error.
I want to ask about firestore trigger, related to this zapier article https://zapier.com/help/doc/common-problems-firebase#creating-a-firestore-structured-query-for-a-search , I have Firestore collection “users”, and it has multilanguage status. like this. users { “language”: “en”, “foo”: “foo”, ,,,, } I could make zap to watch just new document in “users”, but I don’t know how to watch new document in “users” with having language as “en”. I don’t know how to write this. Could you anyone help me with this?
Hi, I have created a connection between the firebase and squarespace. I want to move the real time database from the squarespace to the firebase. I got all APIs from the squarespace, but I don’t know how to use Zapier to show all the database on the firebase. After the connection, nothing happens, the firebase cloud database doesn’t update automatically. I don’t know how to operate it. Best wishes, H
Im Trying to connecgt google sheets to firebase firestore. Im trying to combine multiple columns to form an array in the db. But I dont see an option to choose the datatype of the data being store. All the fields are stored as string. In the below example, I want to store imag_url as an array.
Hi, The zap that I am trying to create has Cloud Firestore as a trigger. Once a new document is created in the Cloud Firestore it triggers the Zap. The collection is test and it has fields named name, address, and so on. I need to use these fields values in the action. The action is creating a customer in the Zoho Books using the fields received from the trigger. My doubt is how do I read the field and use it in the Zoho Books? I tried Fields Name String Value and it is considers Fields Name String Value as the customer name instead of the value in the Firestore field name which will be different.
Hi Everyone, I have been trying to tweak Zapier for the last couple of hours but without success. And I thougt I might ask around before giving up. I have a firebase collection with several documents inside it. I’m looking for a way to send the fields from each documents to excel rows. Exemple: In Firestore I have a collection named People which contains several documents: Document 1 name: John age: 34 city: London Document 2 name: Laura age: 27 city: Paris And I want to get every document in Excel: name age city John 34 London Laura 27 Paris Is Zapier able to do that ? Many thanks for reading :) Jul
Creating a Firestore Structured Query for a TriggerWhen using a Zap to trigger on new documents within a Firestore collection, it's important to build a Structured Query that returns the selected documents in the correct order, otherwise your Zap may never see the new documents.The orderBy property in your query needs to ensure that the new documents are at the "top" of the search results, so that the Zap can see those documents. In most cases, you'll want to use DESCENDING, like this: "orderBy": [{ "field": { "fieldPath": "someKeyOfYourChoice" }, "direction": "DESCENDING" }]If your field has spaces in it, you will need to surround it with backticks. For example: "orderBy": [{ "field": { "fieldPath": "`a field with spaces`" }, "direction": "DESCENDING" }]You can learn more about the correct syntax/structure here: https://cloud.google.com/firestore/docs/reference/rest/v1beta1/StructuredQuery#OrderCreating a Firestore Structured Query for a SearchWhen using a Zap to search for a specific document within a Firestore collection, it's important to build a Structured Query that contains the appropriate where clause, like this: "where": { "fieldFilter": { "field": { "fieldPath": "whenPlayed" }, "op": "EQUAL", "value": { "stringValue": "some-compare-to-value" } } }In your Zap, the "compare to" value is probably something that you'll want to connect with a previous step within your Zap, using the "plus" button on the right-hand side of the input field within the Zap Editor.You can learn more about the correct syntax/structure here: https://cloud.google.com/firestore/docs/reference/rest/v1beta1/StructuredQuery#FilterInvalid data error (Couldn't parse JSON object)Sometimes you will see an error that says "Invalid data; couldn't parse JSON object, array, or value. Perhaps you're using invalid characters in your key names."This error occurs when the fields you are trying to send to Firebase contain invalid characters. Firebase prohibits key names from containing: . (period) $ (dollar sign) [ (left square bracket) ] (right square bracket) (hash or pound sign) / (forward slash) To get around the error, you will need to manually assign names to the keys. See the Customizing Fields to Store section for details.My Firebase Zap isn't triggering when I add new recordsNew records need to appear at the top of your data so the Zap can see the most recent records. If you aren’t using push IDs, your records need to be ordered lexicographically or by priority so new records appear at the top.A simple way to accomplish this is by calling setWithPriority and using Firebase.ServerValue.TIMESTAMP to order by timestamp.Error: Empty key in "Path to data". Probably tried to use a field which was empty as part of the pathMake sure you remove the beginning and ending / from the Path field.For example, /customers/new/ becomes customers/new.I'm getting "Firebase paths/keys cannot contain the characters $ # . [ ]" but there are no invalid characters included in the path/keysUsers sometimes encounter this error if anything that is being supplied in the value has a pipe ( | ) character in it. For example: This has to due with the way our system encodes key/value pairs. The recommend solution is to not include invalid characters in the value that is included or use a Formatter step to remove the characters.
About Firebase's Integration Paid/versioned account: Their plans start from free, more info here: https://zapier.com/apps/firebase/pricing Partner’s Documentation: https://firebase.google.com/support Connecting with Firebase Note Currently, the integration supports only US-hosted databases. If your database is in a different region, please contact Zapier Support to request this feature. To get started with Firebase on Zapier, connect your Firebase project/account to your Zap. To find your Project's ID, please follow these steps: Visit your Firebase/Firestore Cloud Console: https://console.firebase.google.com. Copy the Project's ID, which is the line of text below the project's name. Finally, you will be asked to give Zapier permission to access your account. Click Allow to continue.If all details were entered correctly, your Firebase account will be successfully connected.
Beta API Request actions is a beta feature. It is available for use, but is still in active development and may change. Advanced feature To use this feature, you’ll need familiarity with sending HTTP requests, APIs, and reading API documentation. If the app’s API changes, you may need to update your API Request actions. Our Support team can provide basic troubleshooting for this feature, but they can't troubleshoot the API you use. Currently, you can create API Request actions with: ABC GymSales Actionstep ActiveCampaign Acuity Scheduling AdRoll Agendor Airtable Amazon Seller Central Asana Assignar Autotask awork Azure Active Directory Azure DevOps BambooHR Big Cartel BigCommerce Bigin by Zoho CRM Brevo Browse AI Bullhorn CRM Campaign Monitor Capsule CRM Chargebee Chargify ChatGPT (OpenAI) Cin7 Core Inventory ClickFunnels Classic ClickSend SMS ClickUp Clio Close Cloudbeds Cloze Coda Cognito Forms Confluence Server ConnectWise Manage Constant Contact Content Snare ConvertKit Copper Cvent Deel Dialpad Discord Discourse Docusign Drip Dropbox Dropbox Sign Drupal Dubsado Earth Class Mail eBay Escala Esendex Eventbrite Expensify Facebook Custom Audiences Filevine Firebase / Firestore Flutterwave Follow Up Boss Formidable Forms Formstack Frame.io Freshdesk Freshservice Front Gainsight Customer Communities GetResponse GitLab GoCardless Google Ads Google Analytics 4 Google BigQuery Google Business Profile Google Calendar Google Contacts Google Docs Google Drive Google Forms Google Groups Google Sheets Google Slides Google Tables Google Tasks Google Vertex AI Google Workspace Admin Greenhouse Harvest HOVER HubSpot Hubstaff Instagram Instagram for Business Intercom IRIS CRM Iterable Jira Service Management Jira Software Cloud Jira Software Server Jotform Kartra Klaviyo Knack LastPass Less Annoying CRM LightSpeed VT LinkedIn LinkedIn Ads Livespace Lofty Mailchimp Mailchimp Transactional MailerLite Classic Mailgun Marketo Method CRM Microsoft Dynamics 365 CRM Microsoft Dynamics365 Business Central Microsoft Outlook Microsoft SharePoint Microsoft Teams Microsoft To Do Miro monday.com Moodle MyCase MyGadgetRepairs Notion Okta OnceHub OneDrive Oneflow OneNote Ontraport Optimizely Campaign Oracle Primavera Cloud PagerDuty PandaDoc Pardot Pike13 Pingdom Pinterest Pipedrive Pipefy Podium Productboard Qualtrics QuickBooks Online Reamaze Recruiterflow Reddit remove.bg RingCentral Sage Accounting Salesforce Salesloft Salesmsg Seismic Learning SEMrush SendGrid ServiceNow ServiceTitan ShareFile ShipStation Shopify SignNow SignRequest SimpleTexting Slack Smartsheet Snitcher Spotify Square Squarespace Strava Streak Stripe SurveyMonkey TalentLMS Teachable Termene TextMagic SMS Thinkific ThriveCart Timely Time Tracking Todoist Tumblr Twilio Twitch Typeform Unbounce Universe Untappd UpKeep VideoAsk Webflow When I Work WooCommerce WordPress WPForms Wrike Xero You Need A Budget YouTube Zapier Tables Zendesk Zoho Analytics Zoho Backstage Zoho Books Zoho Campaigns Zoho Cliq Zoho Connect Zoho Creator Zoho CRM Zoho Desk Zoho Forms Zoho Inventory Zoho Invoice Zoho Mail Zoho Notebook Zoho People Zoho Projects Zoho Recruit Zoho Sheet Zoho ShowTime Zoho Sprints Zoho Survey Zoho WorkDrive Zomentum Zoom Request new apps to be supportedThere are no plans at this time to add additional app coverage.
Note This information was accurate at the time of publication. Please check out the latest product update notes for any updates or changes. In 2022, we released drafts, allowing you to make changes to your Zap without having to turn it off. We also released version preview, which allows you to annotate different versions to give yourself reminders about what you changed in your Zaps. Now, we're releasing the ability to roll back your Zap to a prior version for users on our Professional, Team, and Company plans. With version rollback, you'll be able to: Recover steps from prior version of your Zap Edit the recovered version With this latest update, you'll be able to quickly recover steps from a previous version of your Zap and feel more confident in making changes to your critical workflows. Learn more about how to create and roll back versions of your Zaps.
Note This information was accurate at the time of publication. Please check out the latest product update notes for any updates or changes. An account-wide audit log is now available to account owners and super admins on Team and Company plans. With the audit log, you can monitor activities performed across your entire account giving you insight into when: Zaps are created / deleted Zaps are published Zaps are turned on / off Zaps are deleted / restored Zaps change ownership Audit log offers more transparency into your team's account activities than ever before, so that you can rest assured that all your Zaps are running according to plan. Learn about how to use audit log for more visibility.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
