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:20
3
Keywordbest apple cases 2023
<<< ENTER YOUR KEYWORD HERE
4
Number of results20
<<< How many results? (20 = page 1)
5
Freshness Distance
(in months)
0
6
7
ResultsFormatted DateDateTitleURLDescription
8
1
#END_OF_PERIOD_REACHED
9
2
10
3
11
4
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