ABCDEFGHIJ
1
2
InputCharacter CountAd 2 variantCharacter Count
3
Campaign NameVariant text0
4
Campaign Name Delimiter
5
Headline 10
6
Headline 20
7
Headline 30
8
Description 10
9
Description 20
10
Path 10
11
Path 20
12
Final URLInstructions:

1. Fill in required fields (these are shaded red when empty).
2. Headline 1 is optional, if left blank this will be set equal to the keyword in each ad group.
3. Input as many keywords as you would like to build out (this can go further down than the outlined boxes).
4. Select whether you would like a second ad to be created for each ad group, and if so, which field you would like to be varied in the second ad. All ads will be labelled as 'Ad 1' or 'Ad 2' in the output sheet.
5. If creating an ad 2, specify the ad text you would like in the varying field.
6. Click the Go! button to run the script.

Notes:
The campaign name delimiter is the character(s) that you use to separate parts of your campaign names (eg. | or - ) if you use spaces before and after, make sure you include them.

"Broad" and "Exact will be added to the end of your Campaign Name for the relevant keywords and ads.

If you have text that needs to be in caps in ad copy (eg. "UK"), make sure it is input this way - all ad groups will be output in lower case.

If you would like to save your output sheets and run the script again, you will need to change the sheet names as they will otherwise be deleted on rerunning the script.
13
14
15
Keywords:
(don't need to include [ ] or +)
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