Google Sheets to AWS

( BETA )

Send data from Google Sheet to AWS

Apply data-type validation rules

Automatically load data to Aurora-MySQL

Apply SQL transformation rules

 

Google Sheets to AWS

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.

2016 - 2020,  Factor BI ®. All rights reserved.

  • Facebook
  • Instagram
  • YouTube
  • Twitter