Fail to log an attribute in an existing document on Firestore

Hi guys, this is not a workflow question but more of a data logging issue with Firebase. Appreciate any help you can offer.

Describe the problem/error/question

Using n8n’s Firestore node to update a single field (dailyCalorieGoal) in an existing user document, but all available operations are document-level only.

Current Setup:
Collection: user/{{json.userID}}
Update Key: {{json.userID}} - this is the (document ID)
Columns/Attributes: dailyCalorieGoal

Issue:

  1. “Create” operation fails because the user document already exists
    2.“Create or update” operation doesn’t update existing fields
    All available operations are document-lev

What is the error message (if any)?

Issue 1. Your request is invalid or could not be processed by the service. Document already exists: projects/users-25b7a/databases/(default)/documents/users/user101
Issue 2. no error message, the putput is successful but it is not updating on Firebase

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Information on your n8n setup

  • Database (default: SQLite)
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via n8n cloud
  • Operating system: MacOs