can someone help me fix this
It looks like your topic is missing some important information. Could you provide the following if applicable.
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system:
@bartv can you help me understand this please? thank you
Do the column names in Google Sheets map 1-1 to your Nocodb fields, and is the primary key included?
1 Like
im so confused with the primary key, but with your first questions, yes.
how do i include the primary key?
Primary keys are a key concept in relational database design - they identify the row that you want to operate on. You can learn more about primary keys in Nocodb here. Make sure you have a column name in Google Sheets with the same name and that the values refer to exisiting rows in your Nocodb database to update them.
1 Like
do i have to set the primary key in google sheet?
Yes; if you want to update rows in your Nocodb based on the data in your Google Sheet you need to tell the database which row to process.
If, however, you only need to insert data then you should select another operation from the node and if you configured your database correctly it will generate a new primary key for each new row that you insert.
1 Like
Thank you! I’ll try to fix it again…
i appreciate your help!
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.