snipt

Ctrl+h for KB shortcuts

JavaScript

adwords sitelink replacer script

function main() {
  
  //Defining the variables
  var SPREADSHEET_URL = "[SPREADSHEET URL WITH DATA]";
  var email="[EMAIL]";
  var ccemail="[EMAIL]";
  var scriptName="All Accounts Replacer";
  var PCsheet = 'Desktop SL';
  var Mobilesheet = 'Mobile SL';
  var accountsToCheck = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getSheetByName(PCsheet).getRange('H1').getValue().split(','); //get the accounts to run on
  
  //MCC - select the account to work on
  var accountSelector  = MccApp.accounts().withIds(accountsToCheck);
  var accountIterator = accountSelector.get();
  
  //iteration on the accounts
  while (accountIterator.hasNext()) {
      var account = accountIterator.next();
      MccApp.select(account);
      var accountName = account.getName();
      Logger.log("accountName" + accountName);
  
      //Setting Values in Spreadsheet
      //spreadsheet.getRangeByName("date").setValue(new Date());
      //spreadsheet.getRangeByName("account_id").setValue(AdWordsApp.currentAccount().getCustomerId());
      
        // ***********PC Sitelinks
      var dataspreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getSheetByName(PCsheet);
      var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
      
       // SpeadsheetDataArray.forEach(myFunction);
      
      function myFunction(SpeadsheetDataArray){
        var condition = (SpeadsheetDataArray[5]);
        if ( condition == "yes"){
          Logger.log(condition);
          Logger.log(SpeadsheetDataArray[6]);
          
          //This is the way to select a specific SL in order to modify
          var sitelinkSelector = AdWordsApp.extensions()
          .sitelinks()
          .withIds([SpeadsheetDataArray[6]]);
          
          //now start replacing SLs
          var oldSLUrl= SpeadsheetDataArray[7];
          var newSLUrl= SpeadsheetDataArray[8];
          var sitelinkIterator = sitelinkSelector.get();
          
          while (sitelinkIterator.hasNext()) {
            var sitelink = sitelinkIterator.next();
            var sitelinkOld=sitelink.urls().getFinalUrl();
            var sitelinkNew=sitelinkOld.replace(oldSLUrl, newSLUrl);
            
            //Logger.log("zz" + sitelink.getLinkText()+" "+sitelink.getLinkUrl());
            
            sitelink.setLinkText(SpeadsheetDataArray[1]);
            sitelink.setDescription1(SpeadsheetDataArray[2]);
            sitelink.setDescription2(SpeadsheetDataArray[3]);
            sitelink.urls().setFinalUrl(sitelinkNew);
            
            Logger.log("The following SL is now running: " + sitelink.getLinkText() + sitelink.getDescription1() +"\n" + sitelink.getDescription2() +"\nThe Url changed from "
            + sitelinkOld + " to " + sitelink.urls().getFinalUrl());
            
            //Logger.log(IDs);
            
            //Sending Email telling about the change
            MailApp.sendEmail({
              to:email,
              cc:ccemail,
              subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
              htmlBody: scriptName + " Script ran and The following PC SL ("+ sitelink.getLinkText()+ ") is now running on account " + accountName
              + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
            });
            
          }
          
        }
        
      } //end myFunction
        SpeadsheetDataArray.forEach(myFunction);
    
      
      //******MOBILE   Sitelinks
      var dataspreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getSheetByName(Mobilesheet)
      var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
      //SpeadsheetDataArray.forEach(myFunction);
      
      function myFunction(SpeadsheetDataArray){
        var condition = (SpeadsheetDataArray[5]);
        if ( condition == "yes"){
          Logger.log(condition);
          Logger.log(SpeadsheetDataArray[6]);
          
          //This is the way to select a specific SL in order to modify
          var sitelinkSelector = AdWordsApp.extensions()
          .sitelinks()
          .withIds([SpeadsheetDataArray[6]]);
          
          //now start replacing SLs
          var oldSLUrl= SpeadsheetDataArray[7];
          var newSLUrl= SpeadsheetDataArray[8];
          var sitelinkIterator = sitelinkSelector.get();
          
          while (sitelinkIterator.hasNext()) {
            var sitelink = sitelinkIterator.next();
            var sitelinkOld=sitelink.urls().getFinalUrl();
            var sitelinkNew=sitelinkOld.replace(oldSLUrl, newSLUrl);
            
            // Logger.log("zz" + sitelink.getLinkText()+" "+sitelink.getLinkUrl());
            
            sitelink.setLinkText(SpeadsheetDataArray[1]);
            sitelink.setDescription1(SpeadsheetDataArray[2]);
            sitelink.setDescription2(SpeadsheetDataArray[3]);
            sitelink.urls().setFinalUrl(sitelinkNew);
            
            Logger.log("The following SL is now running: " + sitelink.getLinkText() + sitelink.getDescription1()  +"\n" + sitelink.getDescription2() +"\nThe Url changed from "
            + sitelinkOld + " to " + sitelink.urls().getFinalUrl());
            
            //Logger.log(IDs);
            
            //Sending Email telling about the change
            MailApp.sendEmail({
              to:email,
              cc:ccemail,
              subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
              htmlBody:scriptName + " Script ran and The following Mobile SL ("+ sitelink.getLinkText()+ ") is now running on account " + accountName
              + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
            });
            
          }
          
        }
        
      } //end myFunction
          SpeadsheetDataArray.forEach(myFunction);

  }//end of while accounts loop
}

Description

replace sitelinks on adwords- can manage multi accounts sitelinks.
the format of the google spreadsheet is very important.
https://snipt.net/embed/a5d1d96d84c50b2f3e9462882ea816f0/
/raw/a5d1d96d84c50b2f3e9462882ea816f0/
a5d1d96d84c50b2f3e9462882ea816f0
js
JavaScript
139
2019-06-17T04:35:19
True
False
False
Jul 21, 2016 at 06:45 AM
/api/public/snipt/147429/
adwords-sitelink-replacer-script
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10"> 10</a> <a href="#L-11"> 11</a> <a href="#L-12"> 12</a> <a href="#L-13"> 13</a> <a href="#L-14"> 14</a> <a href="#L-15"> 15</a> <a href="#L-16"> 16</a> <a href="#L-17"> 17</a> <a href="#L-18"> 18</a> <a href="#L-19"> 19</a> <a href="#L-20"> 20</a> <a href="#L-21"> 21</a> <a href="#L-22"> 22</a> <a href="#L-23"> 23</a> <a href="#L-24"> 24</a> <a href="#L-25"> 25</a> <a href="#L-26"> 26</a> <a href="#L-27"> 27</a> <a href="#L-28"> 28</a> <a href="#L-29"> 29</a> <a href="#L-30"> 30</a> <a href="#L-31"> 31</a> <a href="#L-32"> 32</a> <a href="#L-33"> 33</a> <a href="#L-34"> 34</a> <a href="#L-35"> 35</a> <a href="#L-36"> 36</a> <a href="#L-37"> 37</a> <a href="#L-38"> 38</a> <a href="#L-39"> 39</a> <a href="#L-40"> 40</a> <a href="#L-41"> 41</a> <a href="#L-42"> 42</a> <a href="#L-43"> 43</a> <a href="#L-44"> 44</a> <a href="#L-45"> 45</a> <a href="#L-46"> 46</a> <a href="#L-47"> 47</a> <a href="#L-48"> 48</a> <a href="#L-49"> 49</a> <a href="#L-50"> 50</a> <a href="#L-51"> 51</a> <a href="#L-52"> 52</a> <a href="#L-53"> 53</a> <a href="#L-54"> 54</a> <a href="#L-55"> 55</a> <a href="#L-56"> 56</a> <a href="#L-57"> 57</a> <a href="#L-58"> 58</a> <a href="#L-59"> 59</a> <a href="#L-60"> 60</a> <a href="#L-61"> 61</a> <a href="#L-62"> 62</a> <a href="#L-63"> 63</a> <a href="#L-64"> 64</a> <a href="#L-65"> 65</a> <a href="#L-66"> 66</a> <a href="#L-67"> 67</a> <a href="#L-68"> 68</a> <a href="#L-69"> 69</a> <a href="#L-70"> 70</a> <a href="#L-71"> 71</a> <a href="#L-72"> 72</a> <a href="#L-73"> 73</a> <a href="#L-74"> 74</a> <a href="#L-75"> 75</a> <a href="#L-76"> 76</a> <a href="#L-77"> 77</a> <a href="#L-78"> 78</a> <a href="#L-79"> 79</a> <a href="#L-80"> 80</a> <a href="#L-81"> 81</a> <a href="#L-82"> 82</a> <a href="#L-83"> 83</a> <a href="#L-84"> 84</a> <a href="#L-85"> 85</a> <a href="#L-86"> 86</a> <a href="#L-87"> 87</a> <a href="#L-88"> 88</a> <a href="#L-89"> 89</a> <a href="#L-90"> 90</a> <a href="#L-91"> 91</a> <a href="#L-92"> 92</a> <a href="#L-93"> 93</a> <a href="#L-94"> 94</a> <a href="#L-95"> 95</a> <a href="#L-96"> 96</a> <a href="#L-97"> 97</a> <a href="#L-98"> 98</a> <a href="#L-99"> 99</a> <a href="#L-100">100</a> <a href="#L-101">101</a> <a href="#L-102">102</a> <a href="#L-103">103</a> <a href="#L-104">104</a> <a href="#L-105">105</a> <a href="#L-106">106</a> <a href="#L-107">107</a> <a href="#L-108">108</a> <a href="#L-109">109</a> <a href="#L-110">110</a> <a href="#L-111">111</a> <a href="#L-112">112</a> <a href="#L-113">113</a> <a href="#L-114">114</a> <a href="#L-115">115</a> <a href="#L-116">116</a> <a href="#L-117">117</a> <a href="#L-118">118</a> <a href="#L-119">119</a> <a href="#L-120">120</a> <a href="#L-121">121</a> <a href="#L-122">122</a> <a href="#L-123">123</a> <a href="#L-124">124</a> <a href="#L-125">125</a> <a href="#L-126">126</a> <a href="#L-127">127</a> <a href="#L-128">128</a> <a href="#L-129">129</a> <a href="#L-130">130</a> <a href="#L-131">131</a> <a href="#L-132">132</a> <a href="#L-133">133</a> <a href="#L-134">134</a> <a href="#L-135">135</a> <a href="#L-136">136</a> <a href="#L-137">137</a> <a href="#L-138">138</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="kd">function</span> <span class="nx">main</span><span class="p">()</span> <span class="p">{</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a> <span class="c1">//Defining the variables</span> </span><span id="L-4"><a name="L-4"></a> <span class="kd">var</span> <span class="nx">SPREADSHEET_URL</span> <span class="o">=</span> <span class="s2">&quot;[SPREADSHEET URL WITH DATA]&quot;</span><span class="p">;</span> </span><span id="L-5"><a name="L-5"></a> <span class="kd">var</span> <span class="nx">email</span><span class="o">=</span><span class="s2">&quot;[EMAIL]&quot;</span><span class="p">;</span> </span><span id="L-6"><a name="L-6"></a> <span class="kd">var</span> <span class="nx">ccemail</span><span class="o">=</span><span class="s2">&quot;[EMAIL]&quot;</span><span class="p">;</span> </span><span id="L-7"><a name="L-7"></a> <span class="kd">var</span> <span class="nx">scriptName</span><span class="o">=</span><span class="s2">&quot;All Accounts Replacer&quot;</span><span class="p">;</span> </span><span id="L-8"><a name="L-8"></a> <span class="kd">var</span> <span class="nx">PCsheet</span> <span class="o">=</span> <span class="s1">&#39;Desktop SL&#39;</span><span class="p">;</span> </span><span id="L-9"><a name="L-9"></a> <span class="kd">var</span> <span class="nx">Mobilesheet</span> <span class="o">=</span> <span class="s1">&#39;Mobile SL&#39;</span><span class="p">;</span> </span><span id="L-10"><a name="L-10"></a> <span class="kd">var</span> <span class="nx">accountsToCheck</span> <span class="o">=</span> <span class="nx">SpreadsheetApp</span><span class="p">.</span><span class="nx">openByUrl</span><span class="p">(</span><span class="nx">SPREADSHEET_URL</span><span class="p">).</span><span class="nx">getSheetByName</span><span class="p">(</span><span class="nx">PCsheet</span><span class="p">).</span><span class="nx">getRange</span><span class="p">(</span><span class="s1">&#39;H1&#39;</span><span class="p">).</span><span class="nx">getValue</span><span class="p">().</span><span class="nx">split</span><span class="p">(</span><span class="s1">&#39;,&#39;</span><span class="p">);</span> <span class="c1">//get the accounts to run on</span> </span><span id="L-11"><a name="L-11"></a> </span><span id="L-12"><a name="L-12"></a> <span class="c1">//MCC - select the account to work on</span> </span><span id="L-13"><a name="L-13"></a> <span class="kd">var</span> <span class="nx">accountSelector</span> <span class="o">=</span> <span class="nx">MccApp</span><span class="p">.</span><span class="nx">accounts</span><span class="p">().</span><span class="nx">withIds</span><span class="p">(</span><span class="nx">accountsToCheck</span><span class="p">);</span> </span><span id="L-14"><a name="L-14"></a> <span class="kd">var</span> <span class="nx">accountIterator</span> <span class="o">=</span> <span class="nx">accountSelector</span><span class="p">.</span><span class="nx">get</span><span class="p">();</span> </span><span id="L-15"><a name="L-15"></a> </span><span id="L-16"><a name="L-16"></a> <span class="c1">//iteration on the accounts</span> </span><span id="L-17"><a name="L-17"></a> <span class="k">while</span> <span class="p">(</span><span class="nx">accountIterator</span><span class="p">.</span><span class="nx">hasNext</span><span class="p">())</span> <span class="p">{</span> </span><span id="L-18"><a name="L-18"></a> <span class="kd">var</span> <span class="nx">account</span> <span class="o">=</span> <span class="nx">accountIterator</span><span class="p">.</span><span class="nx">next</span><span class="p">();</span> </span><span id="L-19"><a name="L-19"></a> <span class="nx">MccApp</span><span class="p">.</span><span class="nx">select</span><span class="p">(</span><span class="nx">account</span><span class="p">);</span> </span><span id="L-20"><a name="L-20"></a> <span class="kd">var</span> <span class="nx">accountName</span> <span class="o">=</span> <span class="nx">account</span><span class="p">.</span><span class="nx">getName</span><span class="p">();</span> </span><span id="L-21"><a name="L-21"></a> <span class="nx">Logger</span><span class="p">.</span><span class="nx">log</span><span class="p">(</span><span class="s2">&quot;accountName&quot;</span> <span class="o">+</span> <span class="nx">accountName</span><span class="p">);</span> </span><span id="L-22"><a name="L-22"></a> </span><span id="L-23"><a name="L-23"></a> <span class="c1">//Setting Values in Spreadsheet</span> </span><span id="L-24"><a name="L-24"></a> <span class="c1">//spreadsheet.getRangeByName(&quot;date&quot;).setValue(new Date());</span> </span><span id="L-25"><a name="L-25"></a> <span class="c1">//spreadsheet.getRangeByName(&quot;account_id&quot;).setValue(AdWordsApp.currentAccount().getCustomerId());</span> </span><span id="L-26"><a name="L-26"></a> </span><span id="L-27"><a name="L-27"></a> <span class="c1">// ***********PC Sitelinks</span> </span><span id="L-28"><a name="L-28"></a> <span class="kd">var</span> <span class="nx">dataspreadsheet</span> <span class="o">=</span> <span class="nx">SpreadsheetApp</span><span class="p">.</span><span class="nx">openByUrl</span><span class="p">(</span><span class="nx">SPREADSHEET_URL</span><span class="p">).</span><span class="nx">getSheetByName</span><span class="p">(</span><span class="nx">PCsheet</span><span class="p">);</span> </span><span id="L-29"><a name="L-29"></a> <span class="kd">var</span> <span class="nx">SpeadsheetDataArray</span> <span class="o">=</span> <span class="nx">dataspreadsheet</span><span class="p">.</span><span class="nx">getRange</span><span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="nx">dataspreadsheet</span><span class="p">.</span><span class="nx">getLastRow</span><span class="p">()</span> <span class="o">-</span> <span class="mi">2</span><span class="p">,</span> <span class="nx">dataspreadsheet</span><span class="p">.</span><span class="nx">getLastColumn</span><span class="p">()).</span><span class="nx">getValues</span><span class="p">();</span> </span><span id="L-30"><a name="L-30"></a> </span><span id="L-31"><a name="L-31"></a> <span class="c1">// SpeadsheetDataArray.forEach(myFunction);</span> </span><span id="L-32"><a name="L-32"></a> </span><span id="L-33"><a name="L-33"></a> <span class="kd">function</span> <span class="nx">myFunction</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">){</span> </span><span id="L-34"><a name="L-34"></a> <span class="kd">var</span> <span class="nx">condition</span> <span class="o">=</span> <span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">5</span><span class="p">]);</span> </span><span id="L-35"><a name="L-35"></a> <span class="k">if</span> <span class="p">(</span> <span class="nx">condition</span> <span class="o">==</span> <span class="s2">&quot;yes&quot;</span><span class="p">){</span> </span><span id="L-36"><a name="L-36"></a> <span class="nx">Logger</span><span class="p">.</span><span class="nx">log</span><span class="p">(</span><span class="nx">condition</span><span class="p">);</span> </span><span id="L-37"><a name="L-37"></a> <span class="nx">Logger</span><span class="p">.</span><span class="nx">log</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">6</span><span class="p">]);</span> </span><span id="L-38"><a name="L-38"></a> </span><span id="L-39"><a name="L-39"></a> <span class="c1">//This is the way to select a specific SL in order to modify</span> </span><span id="L-40"><a name="L-40"></a> <span class="kd">var</span> <span class="nx">sitelinkSelector</span> <span class="o">=</span> <span class="nx">AdWordsApp</span><span class="p">.</span><span class="nx">extensions</span><span class="p">()</span> </span><span id="L-41"><a name="L-41"></a> <span class="p">.</span><span class="nx">sitelinks</span><span class="p">()</span> </span><span id="L-42"><a name="L-42"></a> <span class="p">.</span><span class="nx">withIds</span><span class="p">([</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">6</span><span class="p">]]);</span> </span><span id="L-43"><a name="L-43"></a> </span><span id="L-44"><a name="L-44"></a> <span class="c1">//now start replacing SLs</span> </span><span id="L-45"><a name="L-45"></a> <span class="kd">var</span> <span class="nx">oldSLUrl</span><span class="o">=</span> <span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">7</span><span class="p">];</span> </span><span id="L-46"><a name="L-46"></a> <span class="kd">var</span> <span class="nx">newSLUrl</span><span class="o">=</span> <span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">8</span><span class="p">];</span> </span><span id="L-47"><a name="L-47"></a> <span class="kd">var</span> <span class="nx">sitelinkIterator</span> <span class="o">=</span> <span class="nx">sitelinkSelector</span><span class="p">.</span><span class="nx">get</span><span class="p">();</span> </span><span id="L-48"><a name="L-48"></a> </span><span id="L-49"><a name="L-49"></a> <span class="k">while</span> <span class="p">(</span><span class="nx">sitelinkIterator</span><span class="p">.</span><span class="nx">hasNext</span><span class="p">())</span> <span class="p">{</span> </span><span id="L-50"><a name="L-50"></a> <span class="kd">var</span> <span class="nx">sitelink</span> <span class="o">=</span> <span class="nx">sitelinkIterator</span><span class="p">.</span><span class="nx">next</span><span class="p">();</span> </span><span id="L-51"><a name="L-51"></a> <span class="kd">var</span> <span class="nx">sitelinkOld</span><span class="o">=</span><span class="nx">sitelink</span><span class="p">.</span><span class="nx">urls</span><span class="p">().</span><span class="nx">getFinalUrl</span><span class="p">();</span> </span><span id="L-52"><a name="L-52"></a> <span class="kd">var</span> <span class="nx">sitelinkNew</span><span class="o">=</span><span class="nx">sitelinkOld</span><span class="p">.</span><span class="nx">replace</span><span class="p">(</span><span class="nx">oldSLUrl</span><span class="p">,</span> <span class="nx">newSLUrl</span><span class="p">);</span> </span><span id="L-53"><a name="L-53"></a> </span><span id="L-54"><a name="L-54"></a> <span class="c1">//Logger.log(&quot;zz&quot; + sitelink.getLinkText()+&quot; &quot;+sitelink.getLinkUrl());</span> </span><span id="L-55"><a name="L-55"></a> </span><span id="L-56"><a name="L-56"></a> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">setLinkText</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">1</span><span class="p">]);</span> </span><span id="L-57"><a name="L-57"></a> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">setDescription1</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">2</span><span class="p">]);</span> </span><span id="L-58"><a name="L-58"></a> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">setDescription2</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">3</span><span class="p">]);</span> </span><span id="L-59"><a name="L-59"></a> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">urls</span><span class="p">().</span><span class="nx">setFinalUrl</span><span class="p">(</span><span class="nx">sitelinkNew</span><span class="p">);</span> </span><span id="L-60"><a name="L-60"></a> </span><span id="L-61"><a name="L-61"></a> <span class="nx">Logger</span><span class="p">.</span><span class="nx">log</span><span class="p">(</span><span class="s2">&quot;The following SL is now running: &quot;</span> <span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">getLinkText</span><span class="p">()</span> <span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">getDescription1</span><span class="p">()</span> <span class="o">+</span><span class="s2">&quot;\n&quot;</span> <span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">getDescription2</span><span class="p">()</span> <span class="o">+</span><span class="s2">&quot;\nThe Url changed from &quot;</span> </span><span id="L-62"><a name="L-62"></a> <span class="o">+</span> <span class="nx">sitelinkOld</span> <span class="o">+</span> <span class="s2">&quot; to &quot;</span> <span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">urls</span><span class="p">().</span><span class="nx">getFinalUrl</span><span class="p">());</span> </span><span id="L-63"><a name="L-63"></a> </span><span id="L-64"><a name="L-64"></a> <span class="c1">//Logger.log(IDs);</span> </span><span id="L-65"><a name="L-65"></a> </span><span id="L-66"><a name="L-66"></a> <span class="c1">//Sending Email telling about the change</span> </span><span id="L-67"><a name="L-67"></a> <span class="nx">MailApp</span><span class="p">.</span><span class="nx">sendEmail</span><span class="p">({</span> </span><span id="L-68"><a name="L-68"></a> <span class="nx">to</span><span class="o">:</span><span class="nx">email</span><span class="p">,</span> </span><span id="L-69"><a name="L-69"></a> <span class="nx">cc</span><span class="o">:</span><span class="nx">ccemail</span><span class="p">,</span> </span><span id="L-70"><a name="L-70"></a> <span class="nx">subject</span><span class="o">:</span><span class="s2">&quot;Sitelinks in AdWords Account &quot;</span> <span class="o">+</span> <span class="nx">accountName</span> <span class="o">+</span> <span class="s2">&quot; (&quot;</span> <span class="o">+</span> <span class="nx">AdWordsApp</span><span class="p">.</span><span class="nx">currentAccount</span><span class="p">().</span><span class="nx">getCustomerId</span><span class="p">()</span> <span class="o">+</span> <span class="s2">&quot;) were changed&quot;</span><span class="p">,</span> </span><span id="L-71"><a name="L-71"></a> <span class="nx">htmlBody</span><span class="o">:</span> <span class="nx">scriptName</span> <span class="o">+</span> <span class="s2">&quot; Script ran and The following PC SL (&quot;</span><span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">getLinkText</span><span class="p">()</span><span class="o">+</span> <span class="s2">&quot;) is now running on account &quot;</span> <span class="o">+</span> <span class="nx">accountName</span> </span><span id="L-72"><a name="L-72"></a> <span class="o">+</span> <span class="s2">&quot;\n\nLog into AdWords and take a look.\n\nAlerts dashboard: &quot;</span> <span class="o">+</span> <span class="nx">SPREADSHEET_URL</span> </span><span id="L-73"><a name="L-73"></a> <span class="p">});</span> </span><span id="L-74"><a name="L-74"></a> </span><span id="L-75"><a name="L-75"></a> <span class="p">}</span> </span><span id="L-76"><a name="L-76"></a> </span><span id="L-77"><a name="L-77"></a> <span class="p">}</span> </span><span id="L-78"><a name="L-78"></a> </span><span id="L-79"><a name="L-79"></a> <span class="p">}</span> <span class="c1">//end myFunction</span> </span><span id="L-80"><a name="L-80"></a> <span class="nx">SpeadsheetDataArray</span><span class="p">.</span><span class="nx">forEach</span><span class="p">(</span><span class="nx">myFunction</span><span class="p">);</span> </span><span id="L-81"><a name="L-81"></a> </span><span id="L-82"><a name="L-82"></a> </span><span id="L-83"><a name="L-83"></a> <span class="c1">//******MOBILE Sitelinks</span> </span><span id="L-84"><a name="L-84"></a> <span class="kd">var</span> <span class="nx">dataspreadsheet</span> <span class="o">=</span> <span class="nx">SpreadsheetApp</span><span class="p">.</span><span class="nx">openByUrl</span><span class="p">(</span><span class="nx">SPREADSHEET_URL</span><span class="p">).</span><span class="nx">getSheetByName</span><span class="p">(</span><span class="nx">Mobilesheet</span><span class="p">)</span> </span><span id="L-85"><a name="L-85"></a> <span class="kd">var</span> <span class="nx">SpeadsheetDataArray</span> <span class="o">=</span> <span class="nx">dataspreadsheet</span><span class="p">.</span><span class="nx">getRange</span><span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="nx">dataspreadsheet</span><span class="p">.</span><span class="nx">getLastRow</span><span class="p">()</span> <span class="o">-</span> <span class="mi">2</span><span class="p">,</span> <span class="nx">dataspreadsheet</span><span class="p">.</span><span class="nx">getLastColumn</span><span class="p">()).</span><span class="nx">getValues</span><span class="p">();</span> </span><span id="L-86"><a name="L-86"></a> <span class="c1">//SpeadsheetDataArray.forEach(myFunction);</span> </span><span id="L-87"><a name="L-87"></a> </span><span id="L-88"><a name="L-88"></a> <span class="kd">function</span> <span class="nx">myFunction</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">){</span> </span><span id="L-89"><a name="L-89"></a> <span class="kd">var</span> <span class="nx">condition</span> <span class="o">=</span> <span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">5</span><span class="p">]);</span> </span><span id="L-90"><a name="L-90"></a> <span class="k">if</span> <span class="p">(</span> <span class="nx">condition</span> <span class="o">==</span> <span class="s2">&quot;yes&quot;</span><span class="p">){</span> </span><span id="L-91"><a name="L-91"></a> <span class="nx">Logger</span><span class="p">.</span><span class="nx">log</span><span class="p">(</span><span class="nx">condition</span><span class="p">);</span> </span><span id="L-92"><a name="L-92"></a> <span class="nx">Logger</span><span class="p">.</span><span class="nx">log</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">6</span><span class="p">]);</span> </span><span id="L-93"><a name="L-93"></a> </span><span id="L-94"><a name="L-94"></a> <span class="c1">//This is the way to select a specific SL in order to modify</span> </span><span id="L-95"><a name="L-95"></a> <span class="kd">var</span> <span class="nx">sitelinkSelector</span> <span class="o">=</span> <span class="nx">AdWordsApp</span><span class="p">.</span><span class="nx">extensions</span><span class="p">()</span> </span><span id="L-96"><a name="L-96"></a> <span class="p">.</span><span class="nx">sitelinks</span><span class="p">()</span> </span><span id="L-97"><a name="L-97"></a> <span class="p">.</span><span class="nx">withIds</span><span class="p">([</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">6</span><span class="p">]]);</span> </span><span id="L-98"><a name="L-98"></a> </span><span id="L-99"><a name="L-99"></a> <span class="c1">//now start replacing SLs</span> </span><span id="L-100"><a name="L-100"></a> <span class="kd">var</span> <span class="nx">oldSLUrl</span><span class="o">=</span> <span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">7</span><span class="p">];</span> </span><span id="L-101"><a name="L-101"></a> <span class="kd">var</span> <span class="nx">newSLUrl</span><span class="o">=</span> <span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">8</span><span class="p">];</span> </span><span id="L-102"><a name="L-102"></a> <span class="kd">var</span> <span class="nx">sitelinkIterator</span> <span class="o">=</span> <span class="nx">sitelinkSelector</span><span class="p">.</span><span class="nx">get</span><span class="p">();</span> </span><span id="L-103"><a name="L-103"></a> </span><span id="L-104"><a name="L-104"></a> <span class="k">while</span> <span class="p">(</span><span class="nx">sitelinkIterator</span><span class="p">.</span><span class="nx">hasNext</span><span class="p">())</span> <span class="p">{</span> </span><span id="L-105"><a name="L-105"></a> <span class="kd">var</span> <span class="nx">sitelink</span> <span class="o">=</span> <span class="nx">sitelinkIterator</span><span class="p">.</span><span class="nx">next</span><span class="p">();</span> </span><span id="L-106"><a name="L-106"></a> <span class="kd">var</span> <span class="nx">sitelinkOld</span><span class="o">=</span><span class="nx">sitelink</span><span class="p">.</span><span class="nx">urls</span><span class="p">().</span><span class="nx">getFinalUrl</span><span class="p">();</span> </span><span id="L-107"><a name="L-107"></a> <span class="kd">var</span> <span class="nx">sitelinkNew</span><span class="o">=</span><span class="nx">sitelinkOld</span><span class="p">.</span><span class="nx">replace</span><span class="p">(</span><span class="nx">oldSLUrl</span><span class="p">,</span> <span class="nx">newSLUrl</span><span class="p">);</span> </span><span id="L-108"><a name="L-108"></a> </span><span id="L-109"><a name="L-109"></a> <span class="c1">// Logger.log(&quot;zz&quot; + sitelink.getLinkText()+&quot; &quot;+sitelink.getLinkUrl());</span> </span><span id="L-110"><a name="L-110"></a> </span><span id="L-111"><a name="L-111"></a> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">setLinkText</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">1</span><span class="p">]);</span> </span><span id="L-112"><a name="L-112"></a> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">setDescription1</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">2</span><span class="p">]);</span> </span><span id="L-113"><a name="L-113"></a> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">setDescription2</span><span class="p">(</span><span class="nx">SpeadsheetDataArray</span><span class="p">[</span><span class="mi">3</span><span class="p">]);</span> </span><span id="L-114"><a name="L-114"></a> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">urls</span><span class="p">().</span><span class="nx">setFinalUrl</span><span class="p">(</span><span class="nx">sitelinkNew</span><span class="p">);</span> </span><span id="L-115"><a name="L-115"></a> </span><span id="L-116"><a name="L-116"></a> <span class="nx">Logger</span><span class="p">.</span><span class="nx">log</span><span class="p">(</span><span class="s2">&quot;The following SL is now running: &quot;</span> <span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">getLinkText</span><span class="p">()</span> <span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">getDescription1</span><span class="p">()</span> <span class="o">+</span><span class="s2">&quot;\n&quot;</span> <span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">getDescription2</span><span class="p">()</span> <span class="o">+</span><span class="s2">&quot;\nThe Url changed from &quot;</span> </span><span id="L-117"><a name="L-117"></a> <span class="o">+</span> <span class="nx">sitelinkOld</span> <span class="o">+</span> <span class="s2">&quot; to &quot;</span> <span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">urls</span><span class="p">().</span><span class="nx">getFinalUrl</span><span class="p">());</span> </span><span id="L-118"><a name="L-118"></a> </span><span id="L-119"><a name="L-119"></a> <span class="c1">//Logger.log(IDs);</span> </span><span id="L-120"><a name="L-120"></a> </span><span id="L-121"><a name="L-121"></a> <span class="c1">//Sending Email telling about the change</span> </span><span id="L-122"><a name="L-122"></a> <span class="nx">MailApp</span><span class="p">.</span><span class="nx">sendEmail</span><span class="p">({</span> </span><span id="L-123"><a name="L-123"></a> <span class="nx">to</span><span class="o">:</span><span class="nx">email</span><span class="p">,</span> </span><span id="L-124"><a name="L-124"></a> <span class="nx">cc</span><span class="o">:</span><span class="nx">ccemail</span><span class="p">,</span> </span><span id="L-125"><a name="L-125"></a> <span class="nx">subject</span><span class="o">:</span><span class="s2">&quot;Sitelinks in AdWords Account &quot;</span> <span class="o">+</span> <span class="nx">accountName</span> <span class="o">+</span> <span class="s2">&quot; (&quot;</span> <span class="o">+</span> <span class="nx">AdWordsApp</span><span class="p">.</span><span class="nx">currentAccount</span><span class="p">().</span><span class="nx">getCustomerId</span><span class="p">()</span> <span class="o">+</span> <span class="s2">&quot;) were changed&quot;</span><span class="p">,</span> </span><span id="L-126"><a name="L-126"></a> <span class="nx">htmlBody</span><span class="o">:</span><span class="nx">scriptName</span> <span class="o">+</span> <span class="s2">&quot; Script ran and The following Mobile SL (&quot;</span><span class="o">+</span> <span class="nx">sitelink</span><span class="p">.</span><span class="nx">getLinkText</span><span class="p">()</span><span class="o">+</span> <span class="s2">&quot;) is now running on account &quot;</span> <span class="o">+</span> <span class="nx">accountName</span> </span><span id="L-127"><a name="L-127"></a> <span class="o">+</span> <span class="s2">&quot;\n\nLog into AdWords and take a look.\n\nAlerts dashboard: &quot;</span> <span class="o">+</span> <span class="nx">SPREADSHEET_URL</span> </span><span id="L-128"><a name="L-128"></a> <span class="p">});</span> </span><span id="L-129"><a name="L-129"></a> </span><span id="L-130"><a name="L-130"></a> <span class="p">}</span> </span><span id="L-131"><a name="L-131"></a> </span><span id="L-132"><a name="L-132"></a> <span class="p">}</span> </span><span id="L-133"><a name="L-133"></a> </span><span id="L-134"><a name="L-134"></a> <span class="p">}</span> <span class="c1">//end myFunction</span> </span><span id="L-135"><a name="L-135"></a> <span class="nx">SpeadsheetDataArray</span><span class="p">.</span><span class="nx">forEach</span><span class="p">(</span><span class="nx">myFunction</span><span class="p">);</span> </span><span id="L-136"><a name="L-136"></a> </span><span id="L-137"><a name="L-137"></a> <span class="p">}</span><span class="c1">//end of while accounts loop</span> </span><span id="L-138"><a name="L-138"></a><span class="p">}</span> </span></pre></div> </td></tr></table>
adwords, javascript, sitelinks
--- 
+++ 
@@ -68,7 +68,7 @@
               to:email,
               cc:ccemail,
               subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
-              htmlBody: scriptName + "ran and The following PC SL ("+ sitelink.getLinkText()+ ") is now running on account " + accountName
+              htmlBody: scriptName + " Script ran and The following PC SL ("+ sitelink.getLinkText()+ ") is now running on account " + accountName
               + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
             });
             
@@ -123,7 +123,7 @@
               to:email,
               cc:ccemail,
               subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
-              htmlBody:scriptName + "ran and The following Mobile SL ("+ sitelink.getLinkText()+ ") is now running on account " + accountName
+              htmlBody:scriptName + " Script ran and The following Mobile SL ("+ sitelink.getLinkText()+ ") is now running on account " + accountName
               + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
             });
             
--- 
+++ 
@@ -1,125 +1,138 @@
 function main() {
   
-  var SPREADSHEET_URL = "[URL TO SPREADSHEET]"; 
-  
   //Defining the variables
+  var SPREADSHEET_URL = "[SPREADSHEET URL WITH DATA]";
   var email="[EMAIL]";
   var ccemail="[EMAIL]";
-  var accountName="All Accounts Replacer";
-  var PCsheet = 'Desktop SL'; //spreasheet sheet name of desktop links
-  var Mobilesheet = 'Mobile SL'; //spreasheet sheet name of mobile links
+  var scriptName="All Accounts Replacer";
+  var PCsheet = 'Desktop SL';
+  var Mobilesheet = 'Mobile SL';
+  var accountsToCheck = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getSheetByName(PCsheet).getRange('H1').getValue().split(','); //get the accounts to run on
   
-  //Setting Values in Spreadsheet
-  //spreadsheet.getRangeByName("date").setValue(new Date());
-  //spreadsheet.getRangeByName("account_id").setValue(AdWordsApp.currentAccount().getCustomerId());
- 
+  //MCC - select the account to work on
+  var accountSelector  = MccApp.accounts().withIds(accountsToCheck);
+  var accountIterator = accountSelector.get();
   
-  // ***********PC Sitelinks
-  var dataspreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL.getSheetByName(PCsheet)
-  var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
-  SpeadsheetDataArray.forEach(myFunction);
+  //iteration on the accounts
+  while (accountIterator.hasNext()) {
+      var account = accountIterator.next();
+      MccApp.select(account);
+      var accountName = account.getName();
+      Logger.log("accountName" + accountName);
   
-  function myFunction(SpeadsheetDataArray){
-    var condition = (SpeadsheetDataArray[5]);
-    if ( condition == "yes"){
-      Logger.log(condition);
-      Logger.log(SpeadsheetDataArray[6]);
+      //Setting Values in Spreadsheet
+      //spreadsheet.getRangeByName("date").setValue(new Date());
+      //spreadsheet.getRangeByName("account_id").setValue(AdWordsApp.currentAccount().getCustomerId());
       
-      //This is the way to select a specific SL in order to modify
-      var sitelinkSelector = AdWordsApp.extensions()
-      .sitelinks()
-      .withIds([SpeadsheetDataArray[6]]);
+        // ***********PC Sitelinks
+      var dataspreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getSheetByName(PCsheet);
+      var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
       
-      //now start replacing SLs
-      var oldSLUrl= SpeadsheetDataArray[7];
-      var newSLUrl= SpeadsheetDataArray[8];
-      var sitelinkIterator = sitelinkSelector.get();
+       // SpeadsheetDataArray.forEach(myFunction);
       
-      while (sitelinkIterator.hasNext()) {
-        var sitelink = sitelinkIterator.next();
-        var sitelinkOld=sitelink.urls().getFinalUrl();
-        var sitelinkNew=sitelinkOld.replace(oldSLUrl, newSLUrl);
+      function myFunction(SpeadsheetDataArray){
+        var condition = (SpeadsheetDataArray[5]);
+        if ( condition == "yes"){
+          Logger.log(condition);
+          Logger.log(SpeadsheetDataArray[6]);
+          
+          //This is the way to select a specific SL in order to modify
+          var sitelinkSelector = AdWordsApp.extensions()
+          .sitelinks()
+          .withIds([SpeadsheetDataArray[6]]);
+          
+          //now start replacing SLs
+          var oldSLUrl= SpeadsheetDataArray[7];
+          var newSLUrl= SpeadsheetDataArray[8];
+          var sitelinkIterator = sitelinkSelector.get();
+          
+          while (sitelinkIterator.hasNext()) {
+            var sitelink = sitelinkIterator.next();
+            var sitelinkOld=sitelink.urls().getFinalUrl();
+            var sitelinkNew=sitelinkOld.replace(oldSLUrl, newSLUrl);
+            
+            //Logger.log("zz" + sitelink.getLinkText()+" "+sitelink.getLinkUrl());
+            
+            sitelink.setLinkText(SpeadsheetDataArray[1]);
+            sitelink.setDescription1(SpeadsheetDataArray[2]);
+            sitelink.setDescription2(SpeadsheetDataArray[3]);
+            sitelink.urls().setFinalUrl(sitelinkNew);
+            
+            Logger.log("The following SL is now running: " + sitelink.getLinkText() + sitelink.getDescription1() +"\n" + sitelink.getDescription2() +"\nThe Url changed from "
+            + sitelinkOld + " to " + sitelink.urls().getFinalUrl());
+            
+            //Logger.log(IDs);
+            
+            //Sending Email telling about the change
+            MailApp.sendEmail({
+              to:email,
+              cc:ccemail,
+              subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
+              htmlBody: scriptName + "ran and The following PC SL ("+ sitelink.getLinkText()+ ") is now running on account " + accountName
+              + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
+            });
+            
+          }
+          
+        }
         
-        // Logger.log("zz" + sitelink.getLinkText()+" "+sitelink.getLinkUrl());
+      } //end myFunction
+        SpeadsheetDataArray.forEach(myFunction);
+    
+      
+      //******MOBILE   Sitelinks
+      var dataspreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getSheetByName(Mobilesheet)
+      var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
+      //SpeadsheetDataArray.forEach(myFunction);
+      
+      function myFunction(SpeadsheetDataArray){
+        var condition = (SpeadsheetDataArray[5]);
+        if ( condition == "yes"){
+          Logger.log(condition);
+          Logger.log(SpeadsheetDataArray[6]);
+          
+          //This is the way to select a specific SL in order to modify
+          var sitelinkSelector = AdWordsApp.extensions()
+          .sitelinks()
+          .withIds([SpeadsheetDataArray[6]]);
+          
+          //now start replacing SLs
+          var oldSLUrl= SpeadsheetDataArray[7];
+          var newSLUrl= SpeadsheetDataArray[8];
+          var sitelinkIterator = sitelinkSelector.get();
+          
+          while (sitelinkIterator.hasNext()) {
+            var sitelink = sitelinkIterator.next();
+            var sitelinkOld=sitelink.urls().getFinalUrl();
+            var sitelinkNew=sitelinkOld.replace(oldSLUrl, newSLUrl);
+            
+            // Logger.log("zz" + sitelink.getLinkText()+" "+sitelink.getLinkUrl());
+            
+            sitelink.setLinkText(SpeadsheetDataArray[1]);
+            sitelink.setDescription1(SpeadsheetDataArray[2]);
+            sitelink.setDescription2(SpeadsheetDataArray[3]);
+            sitelink.urls().setFinalUrl(sitelinkNew);
+            
+            Logger.log("The following SL is now running: " + sitelink.getLinkText() + sitelink.getDescription1()  +"\n" + sitelink.getDescription2() +"\nThe Url changed from "
+            + sitelinkOld + " to " + sitelink.urls().getFinalUrl());
+            
+            //Logger.log(IDs);
+            
+            //Sending Email telling about the change
+            MailApp.sendEmail({
+              to:email,
+              cc:ccemail,
+              subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
+              htmlBody:scriptName + "ran and The following Mobile SL ("+ sitelink.getLinkText()+ ") is now running on account " + accountName
+              + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
+            });
+            
+          }
+          
+        }
         
-        sitelink.setLinkText(SpeadsheetDataArray[1]);
-        sitelink.setDescription1(SpeadsheetDataArray[2]);
-        sitelink.setDescription2(SpeadsheetDataArray[3]);
-        sitelink.urls().setFinalUrl(sitelinkNew);
-        
-        Logger.log("The following SL is now running: " + sitelink.getLinkText() + sitelink.getDescription1() + sitelink.getDescription2() +"\nThe Url changed from "
-        + sitelinkOld + " to " + sitelink.urls().getFinalUrl());
-        
-        //Logger.log(IDs);
-        
-        //Sending Email telling about the change
-        MailApp.sendEmail({
-          to:email,
-          cc:ccemail,
-          subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
-          htmlBody:"The following PC SL ("+ sitelink.getLinkText()+ ") is now running on account [ACCOUNT]"
-          + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
-        });
-        
-      }
-      
-    }
-    
-  } //end myFunction
-  
-  
-  //******MOBILE   Sitelinks
-  var dataspreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getSheetByName(Mobilesheet)
-  var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
-  SpeadsheetDataArray.forEach(myFunction);
-  
-  function myFunction(SpeadsheetDataArray){
-    var condition = (SpeadsheetDataArray[5]);
-    if ( condition == "yes"){
-      Logger.log(condition);
-      Logger.log(SpeadsheetDataArray[6]);
-      
-      //This is the way to select a specific SL in order to modify
-      var sitelinkSelector = AdWordsApp.extensions()
-      .sitelinks()
-      .withIds([SpeadsheetDataArray[6]]);
-      
-      //now start replacing SLs
-      var oldSLUrl= SpeadsheetDataArray[7];
-      var newSLUrl= SpeadsheetDataArray[8];
-      var sitelinkIterator = sitelinkSelector.get();
-      
-      while (sitelinkIterator.hasNext()) {
-        var sitelink = sitelinkIterator.next();
-        var sitelinkOld=sitelink.urls().getFinalUrl();
-        var sitelinkNew=sitelinkOld.replace(oldSLUrl, newSLUrl);
-        
-        // Logger.log("zz" + sitelink.getLinkText()+" "+sitelink.getLinkUrl());
-        
-        sitelink.setLinkText(SpeadsheetDataArray[1]);
-        sitelink.setDescription1(SpeadsheetDataArray[2]);
-        sitelink.setDescription2(SpeadsheetDataArray[3]);
-        sitelink.urls().setFinalUrl(sitelinkNew);
-        
-        Logger.log("The following SL is now running: " + sitelink.getLinkText() + sitelink.getDescription1() + sitelink.getDescription2() +"\nThe Url changed from "
-        + sitelinkOld + " to " + sitelink.urls().getFinalUrl());
-        
-        //Logger.log(IDs);
-        
-        //Sending Email telling about the change
-        MailApp.sendEmail({
-          to:email,
-          cc:ccemail,
-          subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
-          htmlBody:"The following Mobile SL ("+ sitelink.getLinkText()+ ") is now running on account [ACCOUNT]"
-          + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
-        });
-        
-      }
-      
-    }
-    
-  } //end myFunction
-  
+      } //end myFunction
+          SpeadsheetDataArray.forEach(myFunction);
+
+  }//end of while accounts loop
 }
-
--- 
+++ 
@@ -1,14 +1,13 @@
 function main() {
   
-  var SPREADSHEET_URL = "[URL TO SPREADSHEET]";
+  var SPREADSHEET_URL = "[URL TO SPREADSHEET]"; 
   
   //Defining the variables
-  var spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
   var email="[EMAIL]";
   var ccemail="[EMAIL]";
   var accountName="All Accounts Replacer";
-  var PCsheet = 'Desktop SL';
-  var Mobilesheet = 'Mobile SL';
+  var PCsheet = 'Desktop SL'; //spreasheet sheet name of desktop links
+  var Mobilesheet = 'Mobile SL'; //spreasheet sheet name of mobile links
   
   //Setting Values in Spreadsheet
   //spreadsheet.getRangeByName("date").setValue(new Date());
@@ -16,7 +15,7 @@
  
   
   // ***********PC Sitelinks
-  var dataspreadsheet = SpreadsheetApp.openByUrl('[URL TO SPREADSHEET]').getSheetByName(PCsheet)
+  var dataspreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL.getSheetByName(PCsheet)
   var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
   SpeadsheetDataArray.forEach(myFunction);
   
@@ -70,7 +69,7 @@
   
   
   //******MOBILE   Sitelinks
-  var dataspreadsheet = SpreadsheetApp.openByUrl('[URL TO SPREADSHEET]').getSheetByName(Mobilesheet)
+  var dataspreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL).getSheetByName(Mobilesheet)
   var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
   SpeadsheetDataArray.forEach(myFunction);
   
--- 
+++ 
@@ -0,0 +1,126 @@
+function main() {
+  
+  var SPREADSHEET_URL = "[URL TO SPREADSHEET]";
+  
+  //Defining the variables
+  var spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
+  var email="[EMAIL]";
+  var ccemail="[EMAIL]";
+  var accountName="All Accounts Replacer";
+  var PCsheet = 'Desktop SL';
+  var Mobilesheet = 'Mobile SL';
+  
+  //Setting Values in Spreadsheet
+  //spreadsheet.getRangeByName("date").setValue(new Date());
+  //spreadsheet.getRangeByName("account_id").setValue(AdWordsApp.currentAccount().getCustomerId());
+ 
+  
+  // ***********PC Sitelinks
+  var dataspreadsheet = SpreadsheetApp.openByUrl('[URL TO SPREADSHEET]').getSheetByName(PCsheet)
+  var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
+  SpeadsheetDataArray.forEach(myFunction);
+  
+  function myFunction(SpeadsheetDataArray){
+    var condition = (SpeadsheetDataArray[5]);
+    if ( condition == "yes"){
+      Logger.log(condition);
+      Logger.log(SpeadsheetDataArray[6]);
+      
+      //This is the way to select a specific SL in order to modify
+      var sitelinkSelector = AdWordsApp.extensions()
+      .sitelinks()
+      .withIds([SpeadsheetDataArray[6]]);
+      
+      //now start replacing SLs
+      var oldSLUrl= SpeadsheetDataArray[7];
+      var newSLUrl= SpeadsheetDataArray[8];
+      var sitelinkIterator = sitelinkSelector.get();
+      
+      while (sitelinkIterator.hasNext()) {
+        var sitelink = sitelinkIterator.next();
+        var sitelinkOld=sitelink.urls().getFinalUrl();
+        var sitelinkNew=sitelinkOld.replace(oldSLUrl, newSLUrl);
+        
+        // Logger.log("zz" + sitelink.getLinkText()+" "+sitelink.getLinkUrl());
+        
+        sitelink.setLinkText(SpeadsheetDataArray[1]);
+        sitelink.setDescription1(SpeadsheetDataArray[2]);
+        sitelink.setDescription2(SpeadsheetDataArray[3]);
+        sitelink.urls().setFinalUrl(sitelinkNew);
+        
+        Logger.log("The following SL is now running: " + sitelink.getLinkText() + sitelink.getDescription1() + sitelink.getDescription2() +"\nThe Url changed from "
+        + sitelinkOld + " to " + sitelink.urls().getFinalUrl());
+        
+        //Logger.log(IDs);
+        
+        //Sending Email telling about the change
+        MailApp.sendEmail({
+          to:email,
+          cc:ccemail,
+          subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
+          htmlBody:"The following PC SL ("+ sitelink.getLinkText()+ ") is now running on account [ACCOUNT]"
+          + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
+        });
+        
+      }
+      
+    }
+    
+  } //end myFunction
+  
+  
+  //******MOBILE   Sitelinks
+  var dataspreadsheet = SpreadsheetApp.openByUrl('[URL TO SPREADSHEET]').getSheetByName(Mobilesheet)
+  var SpeadsheetDataArray = dataspreadsheet.getRange(3, 1, dataspreadsheet.getLastRow() - 2, dataspreadsheet.getLastColumn()).getValues();
+  SpeadsheetDataArray.forEach(myFunction);
+  
+  function myFunction(SpeadsheetDataArray){
+    var condition = (SpeadsheetDataArray[5]);
+    if ( condition == "yes"){
+      Logger.log(condition);
+      Logger.log(SpeadsheetDataArray[6]);
+      
+      //This is the way to select a specific SL in order to modify
+      var sitelinkSelector = AdWordsApp.extensions()
+      .sitelinks()
+      .withIds([SpeadsheetDataArray[6]]);
+      
+      //now start replacing SLs
+      var oldSLUrl= SpeadsheetDataArray[7];
+      var newSLUrl= SpeadsheetDataArray[8];
+      var sitelinkIterator = sitelinkSelector.get();
+      
+      while (sitelinkIterator.hasNext()) {
+        var sitelink = sitelinkIterator.next();
+        var sitelinkOld=sitelink.urls().getFinalUrl();
+        var sitelinkNew=sitelinkOld.replace(oldSLUrl, newSLUrl);
+        
+        // Logger.log("zz" + sitelink.getLinkText()+" "+sitelink.getLinkUrl());
+        
+        sitelink.setLinkText(SpeadsheetDataArray[1]);
+        sitelink.setDescription1(SpeadsheetDataArray[2]);
+        sitelink.setDescription2(SpeadsheetDataArray[3]);
+        sitelink.urls().setFinalUrl(sitelinkNew);
+        
+        Logger.log("The following SL is now running: " + sitelink.getLinkText() + sitelink.getDescription1() + sitelink.getDescription2() +"\nThe Url changed from "
+        + sitelinkOld + " to " + sitelink.urls().getFinalUrl());
+        
+        //Logger.log(IDs);
+        
+        //Sending Email telling about the change
+        MailApp.sendEmail({
+          to:email,
+          cc:ccemail,
+          subject:"Sitelinks in AdWords Account " + accountName + " (" + AdWordsApp.currentAccount().getCustomerId() + ") were changed", 
+          htmlBody:"The following Mobile SL ("+ sitelink.getLinkText()+ ") is now running on account [ACCOUNT]"
+          + "\n\nLog into AdWords and take a look.\n\nAlerts dashboard: " + SPREADSHEET_URL
+        });
+        
+      }
+      
+    }
+    
+  } //end myFunction
+  
+}
+