Describe the problem/error/question
Hello everyone !
Here is my issue/need :
I have a n8n form and each time a user submits it, I want it to generate a new Google sheets that I will then use to add generated content in some columns depending on what the user’s choice. That’s the reason why I can’t put everything in one document. I will then use this document to import it somewhere else, so it has to be attached to only one user.
What is the error message (if any)?
The main issue is that I get the following error :
“No columns found in Google Sheets. Retry”
Obviously I could add it by hand, but that’s not optimal as I need to generate a new document each time someone’s submits the form, I can’t go by hand and add my columns.
Does anyone have a workaround to fix that ? It’s a bit frustrating, I wished I could add in the settings of the sheet’s node the name of my column for example.
Will take any hint or if you have working example
Please share your workflow
Very basic workflow :
Summary
{
“nodes”: [
{
“parameters”: {
“formTitle”: “Générer les spécifications projets”,
“formFields”: {
“values”: [
{
“fieldLabel”: “Quel est le nom du projet ?”,
“requiredField”: true
},
{
“fieldLabel”: “Télécharger votre fichier de spécifications (format .md)”,
“fieldType”: “file”,
“acceptFileTypes”: “.md”,
“requiredField”: true
},
{
“fieldLabel”: “Nom du chef de projet”,
“placeholder”: “Format : prenom.nom”,
“requiredField”: true
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.formTrigger”,
“typeVersion”: 2.2,
“position”: [
0,
0
],
“id”: “684234ee-a621-42ab-a1ef-5ca664f4524e”,
“name”: “On form submission”,
“webhookId”: “bab3cd44-c142-40d5-b729-1bbc7f8df73a”
},
{
“parameters”: {
“resource”: “spreadsheet”,
“title”: “={{ $json["Quel est le nom du projet ?"] }}”,
“sheetsUi”: {
“sheetValues”: [
{
“title”: “Détails du projet”
},
{
“title”: “User Stories”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.5,
“position”: [
240,
0
],
“id”: “68c04306-7276-473b-b40c-2489a4e04356”,
“name”: “Google Sheets”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “IyLZ0VYjjVwrNH3R”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“operation”: “append”,
“documentId”: {
“__rl”: true,
“value”: “={{ $json.spreadsheetId }}”,
“mode”: “id”
},
“sheetName”: {
“__rl”: true,
“value”: 1269048016,
“mode”: “list”,
“cachedResultName”: “Détails du projet”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1KLypXGmgtXrS_7WxlLJ9HiOwz9_GaCHlRiHbDq_xVys/edit#gid=1269048016”
},
“columns”: {
“mappingMode”: “defineBelow”,
“value”: {},
“matchingColumns”: [
“Nom du projet”
],
“schema”: ,
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.5,
“position”: [
420,
0
],
“id”: “bd1b744c-8a7e-4f45-b21d-b27e37c8f7e8”,
“name”: “Google Sheets2”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “IyLZ0VYjjVwrNH3R”,
“name”: “Google Sheets account”
}
}
}
],
“connections”: {
“On form submission”: {
“main”: [
[
{
“node”: “Google Sheets”,
“type”: “main”,
“index”: 0
}
]
]
},
“Google Sheets”: {
“main”: [
[
{
“node”: “Google Sheets2”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “ee0de93d84af59c3524ecc73435c84ea991fe8131bfa10872ffc50e27488afb4”
}
}
Information on your n8n setup
- n8n version: browser
- Database (default: SQLite): x
- n8n EXECUTIONS_PROCESS setting (default: own, main): x
- Running n8n via (Docker, npm, n8n cloud, desktop app): cloud
- Operating system: Windows 10