Send live database data to Google Sheets

Send query results directly from your database to Google Sheets and have them update automatically every hour. In just a couple of clicks.

There are lots of reasons to send data to Google Sheets.

For instance, take Jeff.

Jeff just loves spreadsheets and isn't interested in that new data platform everyone's raving about.

But, Jeff needs up-to-date data and no-one has time to perform regular exports for him.

This is where Trevor comes in.

Trevor lets you query your database without code, and easily send the results to Google Sheets.

Best of all, those results will refresh, all on their own.

Get started free

Frequently Asked Questions

How does it work?

Start by creating a query against your database (with SQL or using Trevor's query builder). Once saved, Trevor will provide you with a share link you can use to export the live results directly into Google Sheets. You don't need to copy the table or do anything manually - just copy and paste the share link into any cell in Google Sheets and it will pull in the latest results.

What databases are supported?

How does Trevor.io connect to my database?

Trevor connects directly to your database using a read-only transaction. Your credentials are kept strictly private and are securely encrypted using industry standard 128-bit AES Encryption. We're trusted by companies, large and small, around the globe.

How many rows can I import?

Google Sheets has both cell and size (kb) limits when importing data. If you hit the limit, we have methods that enable you to import more data into the same Sheet.

Have another question?

Ping us via the black Intercom button, we'd be happy to help :)