Load data from a Google Sheet to a MySQL database.
Read data from a range of cells in a Google Sheet and use it to create rows in a table in a MySQL database.
Variables
Select the credentials to use to authenticate with the Google Cloud Platform.
Specify the shareable URL link of the Sheet with the data that you want to load.
Specify the range of cells with the data that you want to load.
Select the MySQL database where the Sheet data will be stored.
Specify the name of the table, in schema.table format, where the Sheet data will be stored. If the table does not exist, it will be created.
Specify the name of each column, in matching order, that map to the columns in the Sheet.
If enabled, the rows of data from the Sheet will be appended to the rows in the table. If disabled, the existing content in the table will be deleted.