1
00:00:00,080 --> 00:00:03,996
Sending form answers to Google Sheets is useful, but the finished

2
00:00:03,996 --> 00:00:06,843
row is not the only thing to check.

3
00:00:06,843 --> 00:00:10,047
Follow this fictional practice workflow: submit one workshop suggestion,

4
00:00:10,047 --> 00:00:14,675
find it in a linked Sheet, and inspect who can see the answers.

5
00:00:14,675 --> 00:00:18,590
Google Forms can show response summaries to responders if that setting

6
00:00:18,590 --> 00:00:22,150
is enabled, while the Sheet has its own sharing permissions.

7
00:00:22,750 --> 00:00:25,993
Start a blank form called Workshop Feedback — Practice.

8
00:00:25,993 --> 00:00:30,451
Add a multiple-choice question asking which tutorial to improve, with

9
00:00:30,451 --> 00:00:34,099
Spreadsheet cleanup, Gmail filters, and Meeting notes as options.

10
00:00:34,099 --> 00:00:39,369
Add a paragraph question asking what would make it clearer. Make both required.

11
00:00:39,369 --> 00:00:42,206
The downloadable blueprint lists the exact fields.

12
00:00:42,206 --> 00:00:45,854
This demo needs no email addresses or personal information.

13
00:00:46,454 --> 00:00:50,308
Before sharing the practice form, open Settings, then Presentation, and

14
00:00:50,308 --> 00:00:51,850
find View results summary.

15
00:00:51,850 --> 00:00:54,162
Leave it off for this exercise.

16
00:00:54,162 --> 00:01:00,328
Google's help says that if enabled, responders can see summary results, including full-text answers.

17
00:01:00,328 --> 00:01:05,724
That is easy to miss when the form looks like a simple feedback box.

18
00:01:05,724 --> 00:01:09,963
Also confirm that email collection is unnecessary for this fictional test.

19
00:01:10,563 --> 00:01:14,708
Google's current Forms help says responders need a published form.

20
00:01:14,708 --> 00:01:19,607
Choose Publish, review who may respond, and select a test audience you control.

21
00:01:19,607 --> 00:01:22,998
Do not send the link to real participants yet.

22
00:01:22,998 --> 00:01:27,520
Depending on a personal or Workspace account, the sharing choices may differ.

23
00:01:27,520 --> 00:01:32,041
This exercise needs one fictional submission to check the linked data path.

24
00:01:32,641 --> 00:01:36,839
Open the form's Responses tab and choose Link to Sheets, or

25
00:01:36,839 --> 00:01:39,288
select a response destination from the menu.

26
00:01:39,288 --> 00:01:42,086
Choose a new spreadsheet for this practice form.

27
00:01:42,086 --> 00:01:46,984
Google says form responses can live in a linked Sheet, separate from the form.

28
00:01:46,984 --> 00:01:49,783
Remember the Sheet is its own Drive file.

29
00:01:49,783 --> 00:01:53,631
Its collaborators and sharing settings deserve a separate review after linking.

30
00:01:54,231 --> 00:01:58,523
Use the responder preview or link to submit just one fictional entry.

31
00:01:58,523 --> 00:02:03,530
Choose Spreadsheet cleanup, then write, Label the workbook download more clearly. Submit it once.

32
00:02:03,530 --> 00:02:07,823
These words come from the answer-check download, so we know exactly

33
00:02:07,823 --> 00:02:09,254
what to look for.

34
00:02:09,254 --> 00:02:13,188
If you repeat the submission, the Sheet may correctly contain more

35
00:02:13,188 --> 00:02:15,692
than one row; this exercise expects one.

36
00:02:16,292 --> 00:02:18,139
Return to the linked Sheet.

37
00:02:18,139 --> 00:02:22,204
It should contain one data row with Spreadsheet cleanup, the full

38
00:02:22,204 --> 00:02:24,421
suggestion, and an automatically generated timestamp.

39
00:02:24,421 --> 00:02:28,485
The clock value will depend on when you submit and the

40
00:02:28,485 --> 00:02:30,702
Sheet's locale or time zone.

41
00:02:30,702 --> 00:02:34,766
Compare the two text answers exactly; a timestamp alone does not

42
00:02:34,766 --> 00:02:37,722
prove that the right response destination was linked.

43
00:02:38,322 --> 00:02:40,191
Finish with two access checks.

44
00:02:40,191 --> 00:02:45,423
In Forms, leave View results summary off and review collaborator and responder access separately.

45
00:02:45,423 --> 00:02:49,908
In the linked Sheet's Share panel, set General access to Restricted

46
00:02:49,908 --> 00:02:52,150
and review named and inherited access.

47
00:02:52,150 --> 00:02:56,261
Google says form collaborators get access to a newly linked Sheet,

48
00:02:56,261 --> 00:02:59,251
and later form permission changes do not sync.

49
00:02:59,251 --> 00:03:03,362
Restricted links do not block people who already have named access.

50
00:03:03,962 --> 00:03:07,601
The complete guide includes the fictional question blueprint, the exact

51
00:03:07,601 --> 00:03:11,604
test response, and a checklist for missing rows or unexpected access.

52
00:03:11,604 --> 00:03:14,879
It does not publish a live form for you.

53
00:03:14,879 --> 00:03:18,882
These panels illustrate the expected flow; they are not a recording

54
00:03:18,882 --> 00:03:20,337
of a Forms submission.

55
00:03:20,337 --> 00:03:24,340
Confirm the row and each access setting in your own account

56
00:03:24,340 --> 00:03:25,796
before inviting real respondents.