MySQL Node: Insert operation when column names don't match

[EmeraldHerald]

Hi @n8n_rookie If you don’t have a matching column, you’ll need to use a set node or rename keys here - you can find some more information on that here:

Read all data inside a google sheet and pass it all to MySQL Database

Hi @daniel.o, welcome to the community! This should be fairly straightforward. Assuming both your Google Sheet and MySQL table have identical column names you can simply connect the Google Sheet node (reading your data) to the MySql node (inserting your data). If the columns don’t match exactly you’d need to add a Rename Keys or Set node to the mix. Here’s an example workflow: This workflow will read a Google Sheet like below, then rename the columns to match the colum…