This is how to connect Amazon S3 to Google Sheets for free

This is how to connect Amazon S3 to Google Sheets for free

Use Data Pipelines to connect S3 to Google Sheets & schedule data to feed reports.


We're a young, UK based platform bringing big (and small) data processing to everyone without the limits, the code or the costs.

Google Sheets has rapidly become a viable, free alternative to Microsoft Excel whilst Amazon's Simple Storage Service or 'S3' has become an industry standard for scalable data storage.

The video below demonstrates in under 4 minutes how you can use Data Pipelines to connect data between these two systems and schedule fully automated reports.

Instructions:

  1. Create your Project
  2. Add your S3 and Google Sheet data connections
  3. Create a new pipeline and load in your S3 data
  4. Transform your data as needed using the inbuilt SQL tools
  5. Point your new dataset towards your Google sheet, set a schedule and test it
  6. Enjoy seemless, unlimited data flows between S3 & your Google Sheet

Data Pipelines includes many other connectors & comes with 60 minutes of complimentary processing time each month. This tutorial took up only 2:34 of processing time.

Thanks for reading!