1

I have 400 google sheets each with 6 tabs. They are projects maintained by different analysts. Is there any way I can connect these sheets to Redshift that will not only insert the data but also keep updating Redshift whenever anyone adds any row in a sheet.

I can use apps script but is it the scalable solution for this use case?

James Z
  • 12,209
  • 10
  • 24
  • 44
Prajakta Yerpude
  • 215
  • 6
  • 20

2 Answers2

1

Amazon Redshift presents itself as PostgreSQL 8.0.2.

So, just search the web for "Connect Google Sheets to PostgreSQL".

Several suggestions will appear, including: How can I link a Google spreadsheet to PostgreSQL?

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
0

Can you use redshift spectrum instead? Redshift spectrum supports open csv file format. More info - https://docs.aws.amazon.com/redshift/latest/dg/c-using-spectrum.html

Kiran
  • 46
  • 1