ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Freshness Distance Calculator
Created by Darren Shaw, Founder at Whitespark (with formula help from ChatGPT)

Hat tip to Ross Hudgens for the idea.

This spreadsheet will fetch the top 20 results for the keyword you enter in B3, parse out all the dates, then calculate a "freshness distance".

Instructions: 1. Make a copy of the sheet. 2. Install the add-on. 3. Change the keyword.

REQUIRED ADD-ON: https://nodatanobusiness.com/importfromweb/
Free for 30 days, then $11/m. I couldn't figure out a different way to pull search results into a sheet. If you can make this script work with ImportXML() or UrlFetchApp.fetch() please let me know, but it looks like Google is blocking that now.

Share this sheet! http://sprk.it/fdc

Questions/Comments?
Twi
tter: @DarrenShaw_
LinkedIn: https://www.linkedin.com/in/darrenshawwhitespark/
2
numResults:40
3
Keywordbest dishwashers 2025
<<< ENTER YOUR KEYWORD HERE
4
Number of results40
<<< How many results? (20 = page 1)
5
Freshness Distance
(in months)
0
6
7
ResultsFormatted DateDateTitleURLDescription
8
1
#END_OF_PERIOD_REACHED
9
2
#END_OF_PERIOD_REACHED
10
3
#END_OF_PERIOD_REACHED
11
4
#END_OF_PERIOD_REACHED
12
5
13
6
14
7
15
8
16
9
17
10
18
11
19
12
20
13
21
14
22
15
23
16
24
17
25
18
26
19
27
20
28
21
29
22
30
23
31
24
32
25
33
26
34
27
35
28
36
29
37
30
38
31
39
32
40
33
41
34
42
35
43
36
44
37
45
38
46
39
47
40
48
41
49
42
50
43
51
44
52
45
53
46
54
47
55
48
56
49
57
50
58
51
59
52
60
53
61
54
62
55
63
56
64
57
65
58
66
59
67
60
68
61
69
62
70
63
71
64
72
65
73
66
74
67
75
68
76
69
77
70
78
71
79
72
80
73
81
74
82
75
83
76
84
77
85
78
86
79
87
80
88
81
89
82
90
83
91
84
92
85
93
86
94
87
95
88
96
89
97
90
98
91
99
92
100
93