You can't use this until you register with us!

Description

Load data from a Google Sheet to a MySQL database.

Purchasing Options

Google Sheets to MySQL Loader - $99.99 / month

Available Actions

Load Data

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

Source Parameters
google_connection required

Select the credentials to use to authenticate with the Google Cloud Platform.

sheet_link required

Specify the shareable URL link of the Sheet with the data that you want to load.

range required

Specify the range of cells with the data that you want to load.


Destination Parameters
mysql_connection required

Select the MySQL database where the Sheet data will be stored.

table_name required

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.

to_columns

Specify the name of each column, in matching order, that map to the columns in the Sheet.

primary_key_column

Specify the name of a column to use as a primary key or leave blank for no primary key.

flag_append required

If enabled, the rows of data from the Sheet will be appended to the rows in the existing table. If disabled, any existing table will be deleted and new table created in its place.