I have set up a Google Sheet and got the oauth connection setup and working. I am able to insert data into the sheet using sample data from a set node.
I am sending data to n8n via webhook and then trying to insert that data into the google sheet.
I have set all as per the docs but nothing is being inserted to the sheet? Perhaps some data manipulation of what is coming in via the webhook is needed before pushing it to the google sheet? The sheet has columns with titles in row 1
This is what the incoming webhook data looks like
[
{
"headers": {
"host": "redacted",
"user-agent": "GuzzleHttp/7",
"content-length": "70",
"content-type": "application/x-www-form-urlencoded",
"x-forwarded-for": "redacted",
"x-forwarded-host": "redacted",
"x-forwarded-port": "443",
"x-forwarded-proto": "https",
"x-forwarded-server": "dc30d3fe785b",
"x-real-ip": "redacted",
"accept-encoding": "gzip"
},
"params": {
},
"query": {
},
"body": {
"Name": "Robin",
"Lastname": "Tindall",
"Discipline": "Surfski",
"Course": "Full 27km Course"
}
}
]
The items under body are what I need to append to the sheet.