MySQL to Google Sheets Loader

Read data from a MySQL database and load it into a Google Sheet.

Run SQL Query

Execute an SQL Query in a MySQL database and store the results in a Google Sheet.

Variables

Source Parameters

source_db required

Select the MySQL database where the query will be executed to find data to load.

sql_steps required

SQL Query to run. Only one SQL step is allowed.

user_params

Parameters to use in your SQL Query, if any. Refer to slide out help for more information.

Destination Parameters

google_config required

Credentials to use to authenticate with the Google Cloud Platform.

sheet_url required

Shareable URL link to the spreadsheet containing the sheet where the data will be written.

worksheet_name required

Name of the sheet where the data will be written.

starting_cell required

Top left cell where the data write should begin.

clear_worksheet required

If enabled, all existing data on the Sheet specified will be destroyed prior to new data being written.

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