Effortlessly connect your Microsoft SQL data to Google Sheets for reporting and analysis.
Add-ons
and choose Get Add-ons
. This action will redirect you to the Google Workspace Marketplace.Install
button to install Superjoin.
Extensions
menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.Queries
, choose to Create new query
.Sources
, select Connect to a new source
and search for Microsoft SQL Server.Host Name/IP Address
, Port number
(which is usually 3306), Database Name
, Username
( Make sure to create a new user with read-only access to your database) and Password
.
Once this is done click on Authorize
to allow Superjoin to access your Microsoft SQL Server data.Authorize
to allow Superjoin to access your Microsoft SQL Server data.Run query
and then you can preview your data.Import
and wait for a few seconds. This action pulls all your data from Microsoft SQL to Google Sheets.Refresh
to automatically update your data daily, weekly, or monthly at a specific time.