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.
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.
We currently support Postgres, MySQL, MariaDB, Redshift, Snowflake, and SQL Server, with more coming soon
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.