Using Google Form as Data Collector

Google sheet is commonly used as database. But did you know that you can use google form to collect it? I've been using google form for years now ... and made several how to's .. but I can't believe that I've never made how to create google form and connect it to spreadsheet ... so here ...

There are many ways to connect google form to sheet

1. Through google form.

Go to google form, and create your form. And at the responses, create the sheet.

2. Through google sheet
Go to google sheet, and create your sheet. On tools- create form, it will automaticaly create a sheet as form response

Then boom ... you have 2 files connected to each other.

Share your form through link, email or web page.

From the link, open in browser, then add to home page, it will create a browser shortcut to the browser, with form logo in it.


So there ... ^_^