All Collections
SeekWell Google Sheets Add-on
Getting Started (Sheets Add-on)
Getting Started (Sheets Add-on)

How to get started with the SeekWell Google Sheets Add-on

Tejas Sachdeva avatar
Written by Tejas Sachdeva
Updated over a week ago

Install the Sheets Add-on 

Business (GSuite Customers

Accessing your database

  1. SeekWell uses JDBC to connect to your database

  2. You'll need to make your database available to Google's IPs, here are the ranges (source). The last IP is an address dedicated to SeekWell on Google's infrastructure that is used for scheduling and Postgres support.

  3. Here's an example of how an AWS security group would look for SQL Server:

  4. You can paste the string below into one box on AWS and it will automatically create the ranges you need:

64.18.0.0/20, 64.233.160.0/19, 66.102.0.0/20, 66.249.80.0/20, 72.14.192.0/18, 74.125.0.0/16,173.194.0.0/16, 207.126.144.0/20, 209.85.128.0/17, 216.239.32.0/19, 35.193.207.79/32, 35.239.74.213​/32

Here's an example with MySQL on AWS:

Here is the code for MySQL

GRANT SELECT ON *.* to your_user_name@'64.18.0.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'64.233.160.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'66.102.0.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'66.249.80.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'72.14.192.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'74.125.0.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'173.194.0.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'207.126.144.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'216.239.32.0' IDENTIFIED BY 'your_user_password';
GRANT SELECT ON *.* to your_user_name@'35.193.207.79' IDENTIFIED BY 'your_user_password';

  1. You may want to create a new user if your database has personal information (e.g. customer names and addresses). You can grant this new user access to just the neccassary data

  2. If you are trying to access a local database (i.e. on your computer), check out this Stack Overflow answer

Automating reports and dashboards

  1. Click on "Run Sheets" (this will add a new sheet called "runSheet")

  2. Put the queries you want to run in the "query" column and specify the sheet (e.g. result1) and cell (e.g. A1) you'd like the results written to

  3. SeekWell will automatically create the sheets you specify if they don't already exist, so you don't need to create them ahead of time

  4. You can also specify paramaters / filters to make your query dynamic. For example, below we have a column specifying the country to filter results for:

  5. Click the "Schedule" button if you'd like the data updated automatically (e.g. every hour)

  6. Daily schedules will refresh 24 hours from when you start the schedule (e.g. if you click "Daily" at 9 AM, the data will refresh everyday at 9 AM)

  7. Check out this article for more details on scheduling

Accessing CSV's, JSON, Excel, and other Google Sheets

  1. If you are querying another Google Sheet, share the Sheet you want to query so SeekWell can find it (You don't need to share the Sheet you are querying from).

  2. After launching SeekWell, click "Skip Database"

  3. Click the "Files / API" button and select the file type (use CSV for other Google Sheets), name the table (i.e. what you want to call the table in your SQL query) and the URL to the file. For other Google Sheets, simply copy and paste the URL you see in your browser. Note that the URL is different for spreadsheets with multiple Sheets.

  4. Click "Done" and the code to pull your table will be inserted into the query editor. For example, if you wanted to query another Google Sheet and you named your table "example", the code to SELECTeverything from the new file would look like this:

  5. You can add multiple files and JOIN them as you would with any database tables

Upgrading

  1. Note: Make sure you use the email that you'll be logging into Sheets with (i.e. use your business email if you are a GSuite customer)when you set up your SeekWell account. Our Sheets add-on will automatically check your SeekWell account for your plan type.

  2. If you want to use databases other than MySQL or you're going to exceed the basic tier's limits (e.g. max of 100 rows), please click here to upgrade

  3. After you upgrade, be sure to log out of Google and restart your browser so the changes to your plan can take effect

Trouble Shooting

  • Make sure you are including the port number in the connection string (e.g. aws.us-east-1.rds.amazonaws.com:1433)

  • If you're using a database other than MySQL, you'll need to upgrade to a premium plan here

  • Your database needs to be available to Google's IPs, see above for details on how to do this and please contact us if you're still having issues

Did this answer your question?