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 columns in my database.

image

The MySQL node will return the result following the insert operation: