How to connect Google Forms to Google Sheets

How to connect Google Forms to Google Sheets

If you are using G Suite, you already know how useful it is. It has the best apps and one of them is Google Forms. You will find Google Forms more useful, especially when you are working with Google Sheets.

We mostly use Google Forms to conduct the survey. But when it comes to gathering data, it is not that useful. This is where Google Sheets comes into the picture.

For efficient working, you can connect Google Forms to Google Sheets. For example, you can gather survey data using Google Forms and then put it in Google Sheets. So, how to connect Google Forms to Google Sheets?

In this guide, we will walk you through the steps to link Forms with Sheets. Once you learn how to do it, you can work more efficiently with it. Just go through the steps given below and you will know what to do.

Steps to connect Google Forms to Google Sheets:

  1. Open Google Forms:
How to connect Google Forms to Google Sheets
  1. Next, navigate to the top left under Responses section: 
How to connect Google Forms to Google Sheets
  1. In the Response section, click three dot menu > then Select response destination.
How to connect Google Forms to Google Sheets
How to connect Google Forms to Google Sheets
  1. Now, a new popup window will appear where you can create a new Google Sheet or an existing Sheet:
How to connect Google Forms to Google Sheets
  1. Chose any of the options according to your need and click Create:
How to connect Google Forms to Google Sheets

Now the responses will be visible in the Google sheets