From spreadsheets to a real data warehouse — with the BI tool you choose.
Google Sheets
One or many sheets, your team's existing layout.
Vansync Apps Script
Validate, transform and load — on-demand from inside Sheets.
Amazon Aurora MySQL
Cloud-native data warehouse on AWS, schema auto-created.
Connect any BI tool
Four steps from your spreadsheet to the data warehouse.
Define layout
Specify, per sheet and column, what data to send and the valid data type for each.
Validate & send
From a user-friendly menu inside Google Sheets, push the data to AWS. Type validation runs before sending.
Auto-load
Data lands in your Amazon Aurora MySQL instance, schema auto-created on first load.
Transform
Stored procedures you configure run automatically before and after each load to clean, aggregate or reshape data for analytics.
What you can do with it
Type validation per column
Define data types per sheet and column. Bad rows get flagged before they touch your database.
Push from inside Google Sheets
A custom menu inside Google Sheets lets your team push data when they need to.
SQL transforms before and after
Stored procedures you configure run automatically before and after each load to clean and reshape data for analytics.
On top of a real warehouse
Your sheets data joins everything else in Aurora MySQL. Connect any BI tool on top — QuickSight, Tableau, Power BI, Google Data Studio.