How to link Google Forms with Google Sheet?

Firstly, Open Google Forms and create a new form or select an existing one.
Click on the “Responses” tab at the top of the page.
Select the “Google Sheets” option to link the form to a Google Sheets spreadsheet.
If you haven’t used Google Sheets with the form before, click on “Create a new spreadsheet” to create a new
sheet and link it to the form. If you have already linked the form to a sheet, select the existing sheet from the
drop-down menu.
The responses from the form will now be automatically added to the Google Sheets spreadsheet as soon as
someone submits the form.
To access the spreadsheet, click on the “View Responses” button on the form or go to the Google Sheets
homepage and open the sheet from there.
You can also add a new sheet to an existing spreadsheet and link it to a new form by going to the
spreadsheet and clicking on the “Add sheet” button. Then you can use the “File” > “Link to a form” option to
link the sheet to the form.
Additionally, you can also use the “Add-ons” > “FormMule” on Google Sheets to automatically create a new sheet,
link it to the form, and automatically sends the response to a specified email.

Contact Us