Gsheet undefined range error

[Swati]

I have an n8n flow where data from a webhook is parsed and entered into supabase first and then a backup is done in googlesheets , i have ensured the googlesheet header row matches the data being inserted, i have enured my sheet name is “sheet1” , yet i get an error unable to parse range,
{ “error”: { “code”: 400, “message”: “Unable to parse range: sheet12:undefined2”, “status”: “INVALID_ARGUMENT” } }

my google sheet structure also matches the json

Not sure what im doing wrong

[jabbson]

Two things I’ve noticed:

• you have a range specified as sheet1 - do you have this range in the document
• I see the UI warns about this not being the newest version of the node. Could you please update to the most current version.

[Swati]

thank you, I missed this .I replaced it with the latest version which allows sheet selection and field mapping. the error is gone but the google sheets is not being written into. it is empty.

[jabbson]

Well it is difficult to determine why this could be not updating the sheet based on the image

I you could share the workflow while pinning some input data, that would help and I could take a look.

[Swati]

I cannot see the option </>in the reply for pasting the workflow, let me try creating a new post instead. [quote=“Swati, post:3, topic:154975, full:true”]
thank you, I missed this .I replaced it with the latest version which allows sheet selection and field mapping. the error is gone but the google sheets is not being written into. it is empty.

[/quote]

@Swati

thank you, I missed this .I replaced it with the latest version which allows sheet selection and field mapping. the error is gone but the google sheets is not being written into. it is empty.

[quote=“Swati, post:3, topic:154975, full:true”]
thank you, I missed this .I replaced it with the latest version which allows sheet selection and field mapping. the error is gone but the google sheets is not being written into. it is empty.

See the flow pasted above. Hope it gives some clarity

[jabbson]

Can you please pin the “Code_SanitizeForGsheet” node, so that I can experiement with values just before the node with your issue?

[Swati]

I messed up. Was troubleshooting some stuff and Lovable was misbehaving and asked me to clear cache. Now im not able to login into n8n (self-hosted via npm), i thought i entered the right password, although yesterday I was asked to do an MFA by google on that gmail account. Not sure, either ways , forgot password isnt working. Does this mean , I lose all my data , all my workflows and start from scratch ?

[jabbson]

You can try to reset the password with:

n8n user-management:reset

and if needed disable mfa with:

n8n mfa:disable [email protected]

[Swati]

I finally found my password in document. I didnt want to reset the password and lose all workflows. Regarding pinning the data , it is not allowing me to pin the data as it says production data cannot be pinned.

[jabbson]

I see, well, at least you found the pass!