ERROR: Cannot read properties of null (reading 'toString')

Questions
,
1

Hello, need help with append to google sheets node, has error when null data on inbound flow.

Error in google sheets node: ERROR: Cannot read properties of null (reading ‘toString’)

Thanks!
Andres

Example workflow:

Running n8n cloud, 0.177.0

2

Hi @pradilla,

I’ve tried your workflow in my self-hosted environement and got the same error. When ‘Use Header Names As JSON Paths’ activated, the code is trying to convert value to string. Since you have null value, it can not be converted.

If you have rush, you can use below workaround for now tili issue is resolved.

1 - Set your column names on Google Sheet without ‘body’ path.
2 - Transfer your input data’s body.

image

Hope it helps.

P.S for n8n team: I’ve created a pull request for the issue.

4 Likes
3

Thanks a lot for fixing it @samaritan!

Got released with [email protected]

1 Like