2

I have a google response form that is connected to a Google sheet. However, due to the large volume of responses the spreadsheet is running too slow to open and operate within. I think the spreadsheet is about to reach the cell limit so I might need to use other software to handle the large volume of responses coming in.

What should I use to better use and analyze the responses that are there and coming in?

I have heard that using Bigquery might be a good option but if I load the data for incoming responses from the sheet into bigquery won't the spreadsheet still remain full and not accept any more form submissions once it's full? Or is there a way that any form responses that are received are loaded automatically into bigquery and deleted from the spreadsheet so that the spreadsheet does not fill up?

Or is there a better way to deal with this apart from bigquery? Would I need to move on to something like an actual database? However, I still need to be able to receive the responses from the Google form though.

2
  • Yes, you need a database. BTW, how the users fill up the Google Sheet? What form are they using? Google Form? Commented May 1, 2023 at 7:35
  • Yes, they are using Google forms that feed into a google sheet
    – RedAce
    Commented May 3, 2023 at 0:08

1 Answer 1

0

Personally I think BigData is an overkill.

As the name says it's for storing Big Data and a Google Spreadsheet is not Big Data. However it turns out that the first Terabyte is for free, so bring it on...

First of all you have to export your current data to BigData:

  1. Open the Google Sheet that contains the data you want to export.
  2. Click on "File" in the top-left corner of the screen, and then select "Download" -> "Comma-separated values (.csv, current sheet)".
  3. Save the CSV file to your computer.
  4. Open your BigData system and import the data (there must be a way but I have no details about how to do this operation, you have to find out. Look for an "Import" or "Upload" button, which will allow you to select the CSV file you just downloaded.)
  5. Make sure that the columns and the datatypes are mapped: the columns in the CSV file must correspond to the columns in your database table.
  6. Click "Import" or "Upload" to complete the process.

You can also try to connect BigData and Google Spreadsheet on the fly. Or look at this video: https://www.youtube.com/watch?v=OLw_4oB_fXs

Then connect Google Sheet into BigData.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.