Two Minute Reports Logo
Try for freeLogin
Connectors

MySQL

Connect MySQL to Google Sheets or Google Data Studio

The MySQL connector gets your MySQL data into Google Sheets and Google Data Studio. Use it to track your key metrics in a spreadsheet or a Google Data Studio report.

What you can report on

  • Any custom data stored in your MySQL database
  • Sales, orders, and transactional data from your systems
  • User activity, signups, and product usage metrics
  • Inventory and fulfillment data
  • Custom KPIs and business metrics specific to your product

Prerequisites

  • A MySQL server at a public hostname or IP address, or an SSH server that can connect to it (see Private databases and SSH tunnels)
  • Database host, port, database name, username, and password
  • A database user with SELECT permissions on the tables you want to query
  • Your database firewall set to accept Two Minute Reports' IP addresses (see IP whitelisting below)

How to create a connection

  1. In the Hub, open Connections & accounts.
  2. Select Create connection.
  3. Select MySQL in the connector list.
  4. Select Next.

  1. In Name the connection, enter a name.
  2. Enter your database details in DB host address, DB port, DB name, Username and Password.
  3. If your database needs an encrypted connection or an SSH tunnel, turn on Use SSL or Use SSH, and enter the details.
  4. Select Test connection.

  1. Enable the account.
  2. Select Done.

Only enabled accounts fetch data, and only enabled accounts count toward your plan. You can enable or disable accounts at any time on the Connections & accounts page.

How to get MySQL data into Google Sheets or Google Data Studio

To get MySQL data into Google Sheets:

  1. In the Two Minute Reports sidebar, open Data Queries.
  2. Select Add.
  3. Select your MySQL account.
  4. In Execute (SQL Query), enter your SQL query.
  5. Select Run query. Two Minute Reports adds the data to your sheet.

Dynamic dates

In Google Data Studio, a query config with a custom SQL query can follow the date range of the report. Put @startdate and @enddate in the WHERE clause instead of fixed dates. Two Minute Reports replaces them with the report's date range each time the report gets data. You don't have to edit the dates in the SQL again.

Example: static query

SELECT * FROM orders
WHERE order_date BETWEEN '2024-01-01' AND '2024-01-31'

Same query with dynamic dates

SELECT * FROM orders
WHERE order_date BETWEEN @startdate AND @enddate
Write @startdate and @enddate in lowercase, as in the example. These parameters work in Google Data Studio query configs only. Google Sheets queries send the SQL as you wrote it.

Dynamic dates also keep reports fast, because the database returns only the rows for the selected dates instead of the full table.

IP whitelisting

Two Minute Reports connects from these fixed IP addresses. Add all 5 to your database firewall or GRANT statements before you create the connection. Allowing only some of them gives you a connection that works until a request leaves from one of the others. 

49.13.34.182
5.75.217.220
116.203.164.91
95.216.182.151
91.99.28.86

To grant access in MySQL, run the following for each address (replace your_user and your_password): 

GRANT SELECT ON your_database.* TO 'your_user'@'49.13.34.182' IDENTIFIED BY 'your_password';
GRANT SELECT ON your_database.* TO 'your_user'@'5.75.217.220' IDENTIFIED BY 'your_password';
GRANT SELECT ON your_database.* TO 'your_user'@'116.203.164.91' IDENTIFIED BY 'your_password';
GRANT SELECT ON your_database.* TO 'your_user'@'95.216.182.151' IDENTIFIED BY 'your_password';
GRANT SELECT ON your_database.* TO 'your_user'@'91.99.28.86' IDENTIFIED BY 'your_password';
FLUSH PRIVILEGES;

Still blocked after adding all five? See Connection blocked by a firewall or IP allowlist.

Private databases and SSH tunnels

Two Minute Reports connects only to a host on the public internet. If DB host address is localhost, a loopback address such as 127.0.0.1, or a private network address, the connection fails with this message:

This host is on a private network, so we can't connect to it directly. Use a public host, or add SSH tunnel details to reach a private database.

Private network addresses include:

  • 10.0.0.0 to 10.255.255.255
  • 172.16.0.0 to 172.31.255.255
  • 192.168.0.0 to 192.168.255.255

This also applies to a hostname that points to one of these addresses.

If your database is only on a private network, connect through an SSH server. The SSH server must be on the public internet, and it must be able to connect to the database.

  1. In the connection form, turn on Use SSH.
  2. Enter the SSH host, the SSH port (usually 22) and the SSH username.
  3. Enter the SSH password or the SSH private key. If the key has a passphrase, enter it in Passphrase.
  4. In DB host address, enter the address of the database as the SSH server sees it. This can be a private address. If MySQL runs on the SSH server, enter 127.0.0.1.

When you use an SSH tunnel, add the IP addresses of Two Minute Reports to the firewall of the SSH server, not of the database. The database gets the connection from the SSH server, so the database user must accept connections from the address of the SSH server.

Microsoft Ads

Connect Microsoft Ads to Google Sheets or Google Data Studio

PageSpeed Insights

Connect PageSpeed Insights to Google Sheets or Google Data Studio

Copyright © 2026