How to sync google forms responses to google sheets?

You can create a new spreadsheet for responses in Google Sheets or choose from your existing spreadsheet in Google Sheets to store responses. Once you link your google form with a spreadsheet, the new responses will automatically synced.

Create a new spreadsheet in Google Sheets to sync responses

  • Open your form in Google Forms
  • Click Responses
  • Click spreadsheet icon
  • Select response destination screen will be displayed
  • Select Create a new spreadsheet
  • Click Create

Choose from your existing spreadsheet in Google Sheets to sync responses

  • Open your form in Google Forms
  • Click Responses
  • Click spreadsheet icon
  • Select response destination screen will be displayed
  • Select Select existing spreadsheet
  • Click Select
  • Choose a spreadsheet screen will be displayed
  • Click on an existing spreadsheet where you want to sync responses
  • Click Select