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




Description

Load data from a Google Sheet to a MySQL database.


Purchasing Options



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 required

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

flag_append required

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.