ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
There is an associated blog post for this at: https://www.pipedout.com/resources/diy-unit-testing-for-seo/

It has screenshots and actual formatting because it's not a Google sheet. The cliff notes are here:

How does this work?

This sheet does two things:
- Checks if the website in the correct state.
- Checks if the website changed from this check to the previous check?

How do you set this up.

- Go to the correct values tab. Pick the URLs and the correct value for each column. If you leave it blank it will be ignored.

How to run the sheet
- Open the change detection menu and click copy current to previous. This will save the current values into the previous values spreadsheet.
- Then hit check URLs.

Tab data
- Are the tests passed? A list of TRUE/FALSE values for when values are correct/incorrect.
- Changes from correct: What is different between current values and correct values
- Did something change: What is different between current values and previous values
- Current values: The current values
- Previous values: The previous values

2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100