how do I enter already answered questions, into a previously set up google sheet? The answers were being transported to the google doc, but for various reasons, the feature was turned off, and now I want to turn it back on again. I want to include upcoming surveys, as well as those who has already been answered but not transported… help.
There is not a feature to retroactively send data into a Google spreadsheet – once you set up the Google Sheet action on your survey, any responses collected after that point will pass to the sheet:
One option that should help you get the previous data into the Google sheet is to export the survey data to excel:
Then you could either import the data from excel into the Google sheet or copy/paste the response data from excel into the Google sheet.
You might consider touching base with SG Support to see if there is another solution:
I hope this helps!