title: Upload Googlesheet Data to Google Cloud service and then Analyse with CloudSQL
body: <p>This question is edited to make requirements clearer:</p>
  <p>I am involved with a charity with multiple location. It provides low cost medicines. Current the transaction data - sale purchases is stored in Googlesheets in each location. As it grows it is becoming a pain to analyse one by one.</p>
  <p>The data is structured. Each Table/Tab has defined fields. Each location has identical structure and I can easily have a unique ID.</p>
  <p>I have also experimented with local Postgresql database. Data is in standard Table format - each location has identical format.</p>
  <p>As each shop is selling each day, each day there are new transactions.</p>
  <p>I need a simple way of collecting all this information in <strong>one place</strong> in the cloud so that I can analyse the data using SQL type queries without having to manually get it from each location each day. In total there are some 2000 new transactions in a day that need to be added to database.</p>
  <p>One logical solution would be for each local postgresql database to send new data to a cloud master postgresql database - using WAL? Local databases dont have 24x7 internet access - net is patchy. Charity is in India. I am in UK.</p>
  <p>Ideally I need a solution where when the local computer finds net, it transmits the new transactions to the cloud database.</p>