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

Credentials to use to connect to the MySQL database.

sql_steps required

SQL Query to return the data to add to the Google Sheet.

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!