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

[n8n_rookie]

Hello -

I am running N8N

I am stuck in a scenario that seems simple: I am able to do a MySQL insert with the MySQL node when I have a simple mapping of 1:1 for column names in the Input to output in the MySQL Ouput table (IE: if my Input is ID, Name and my MySQL table has the columns ID, Name).

The scenario that I am stuck: what if my Input has a 3rd value that can be referenced with: {{ $json[“AP”][0] }} and it should map to my MySQL table with Autopilots?

What is the best approach? If I try to use the Expression table of the MySQL node it seems to think my column name is “{{ $json[“AP”][0] }}” which isn’t correct…

Any advice is appreciated!

Thank you

[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…