ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
Step 1:Make a personal copy of this SpreadsheetGo to menu: "File->Make a copy"
5
6
Step 2:Enter Keywords in the "Keywords" TabEnter your keywords you want to monitor. If you use the Free Quota of google custom search API the script processes 100 ranking checks per day. If your keyword list is bigger than the free quota the script goes on with the next (unchecked) keyword automatically. This means you can e.g. check 700 Keywords on a weekly basis - totally free.
7
8
Step 3:Enter Google Custom Search Credentials in the "Settings" TabYou need to setup a google custom search engine. Please Provide the API Key and the SearchId in the "Settings" Tab. Also set your country and language where you want to monitor SERP Results.

If you don't have an API Key and Search Id yet you can follow the steps under Prerequisites section in this page.
9
10
Step 4:Fetch Rankings in "Check-Rankings" Menu ItemChoose "Run Manually" for a one time crawl or "Enable Scheduler" for daily checks. In the background a daily schedule is created for automating the rank checking script.
11
12
Step 5:Use Results in "SERP Rankings" for Data AnalysisYou can use e.g. Google Data Studio on top of the Spreadsheet Data or you can add your Charts directly in this Spreadsheet.
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