top of page

Google Sheets to AWS

Send data from Google Sheet to AWS

​

Apply data-type validation rules

​

Automatically load data to Aurora-MySQL

​

Apply SQL transformation rules

powered by AWS
Google Sheets to AWS

Google Sheets to AWS

Google Sheets to AWS.png

Many companies have valuable data stored in spreadsheets that are not integrated on a comprehensive data warehouse and thus not easily available for deeper analysis with Business Intelligence tools.

​

Is there a way to easily connect and process data from spreadsheets to a scalable and affordable data warehouse on the cloud?

​

With this Add-on for Google Sheets you will be able to:

​

  • Define a layout to collect information and specify for each sheet and column a valid data-type. 

  • With a user-friendly menu, send Google Sheets data directly to AWS and automatically load it to RDS Aurora-MySQL.

  • Execute SQL routines before and after data loads to Aurora-MySQL.

  • Use Aurora-MySQL and AWS set of services to build a scalable Data Warehouse.

2020-07-21_20-07-18.png
bottom of page