DB 2 Sheets

Export your Database tables periodically to Google Sheets

I know you are busy, but...

Your marketing department is hounding you for data exports, they want to crunch the numbers, make a cohort analysis, make fancy graphs for your investors, calculate the PPCAC2x index based on the whatever...

Can't you just make a CSV export?

The data they need is in your application database, you could just give them the database credentials, but that would be irresponsible... or would it?...
Nah, and they don't know SQL anyway...

It's urgent, the investor meeting is in 30 minutes!

Every week, every month... 3 days before the end of the fiscal year: "Hey can you export the users table for me, I need to present this to the board on monday" .

(Received on slack at 14:00 on a Friday)

Let's automate these task for you.

The solution

DB 2 Sheets

Connection
Table
Sync to Sheet
Interval
SQL Query:
id name email last_signed_in created_at updated_at
1 Jack jack@example.net 2022-11-30 06:34:43 2022-11-30 05:54:43 2022-11-30 05:58:43
2 Jack jack@example.net 2022-11-30 06:34:43 2022-11-30 05:41:43 2022-11-30 05:40:43
3 Jack jack@example.net 2022-11-30 06:34:43 2022-11-30 05:57:43 2022-11-30 05:53:43
4 Jack jack@example.net 2022-11-30 06:34:43 2022-11-30 05:44:43 2022-11-30 05:33:43
5 Jack jack@example.net 2022-11-30 06:34:43 2022-11-30 05:57:43 2022-11-30 06:15:43

Focused product

What it says on the tin is what it does, if you need this problem solved, this is the product that will do just that, refreshing right?

Simple pricing

A dollar a day, or less for those who thinks long-term, no up-sells, no arbitrary limitations on accounts, sheets or number of databases you can connect.

Unlimited everything

Connect as many databases as you need, invite all your team members, create 100 new google sheets, we won't stop you.

Monthly

$30 /month

  • Unlimited Queries
  • Unlimited Runs
  • Unlimited Connections
  • Unlimited Google Accounts
Get started

Yearly

Save $60 with a yearly plan

$300 /year

  • Unlimited Queries
  • Unlimited Runs
  • Unlimited Connections
  • Unlimited Google Accounts
Get started

Frequently asked questions

What databases engines does DB2Sheets support?

MySQL and Postgres

What is a "Connection" and how can I have unlimited of them?

A "Connection" in DB2Sheets is a database connection that you have configured in the app (host, port, user/pass etc), we don't arbitrarily limit how many connections you can configure, therefore "unlimited".

What is a "Run"? it was mentioned in the pricing table.

A "Run" is basically, when you either Manually run a Query, or whenever a schedule Runs your Query (and sends the data to Google Sheets), we don't arbitrarily limit how many times or how often you can run a Query, manually or by schedule.

How is this secure?

The database username and password is encrypted in-transit and at rest (aka, if our database is leaked, the data is unusable).

We only connect to your database with a Read-Only connection to ensure that we cannot alter or delete any of your data.

Why are you asking for Google Drive access?

We need access to Google Drive because that is where your Google Sheets are stored, the Google Sheets API alone does not allow "listing" all your sheets.

So we have to pull them out of your Google Drive instead.

We need "write" permission to be able to save new Sheets in your Google Drive.

How frequently can a Scheduled Query run?

You can schedule a Query to run Daily, Weekly or Monthly.

Hourly intervals is coming soon.

We don't restrict how often you can manually run a Query.

Compare us with others.