All good. I figured it out. Had to write the values from Google Calendar events to a “Set” node first, with variables that have the same name as the columns in the MSSQL table.
I was also surprised to find that I had to write the values from specifying the exact Node, not from the passed values to the “Current Node”. The “Current Node” values just returned as blank values in when executing the node after building the result in the Expression builder, even though the value was shown in the result in the expression builder.
This process was not very intuitive for a newbie to n8n. Could I suggest that a simple example (even a demo video) be added to Here or Here?
Please feel free to send me pointers on any of this if I have done anything in a dodgy way. Still learning and always will be.
