ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Step 1:
4
Get your OpenWeatherMap Key:e3c01c####379817<-- Get a key for the OpenWeatherMap API at
5
https://openweathermap.org/appid#get
6
7
Step 2:
8
In this spreadsheet, go to the menu for 'Tools' > 'Script Editor' and create a time based trigger for the function 'RefreshImports'
9
10
Step 3:
11
In this spreadsheet, go to the menu for 'Tools' > 'Script Editor' and update line 17 with the ID of your spreadsheet (the long string of random characters in the URL of this spreadsheet)
12
13
Step 4:
14
Select units ->Metric
15
Metric C - Imperial F - Standard K
16
17
Step 5:
18
Paste the list of Campaigns you want to manage in "Paste CSV from RE here"
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