POST Request to Google Analytics with Measurement Protocol from the App Script returns valid response but doesnt work

Question

I'm trying to send offline conversions data to Google Analytics using the Measurement Protocol

I'm sending this POST Request using the Google AppScripts:

function hitPageViewGA (line,sheet) {

  var range = sheet.getRange(line,1,1,10);
  var values = range.getValues();

  var origem = values[0][6];
  var campanha = values[0][7]

  var data =    {'v': '1',
                 'tid': 'UA-81598809-3',
                 'cid': generateUUID_(),
                 'z': Math.floor(Math.random()*10E7),
                 't':'pageview',
                 'dl':'https://77digitalmarketing.com/teste',
                 'cs':origem,
                 'cn':campanha
                };

   var payload = Object.keys(data).map(function(key) {
                                        return encodeURIComponent(key) + '=' + encodeURIComponent(data[key]);
                                    }).join('&');

  var options = {
  'method' : 'POST',
  'payload' : payload,
  'headers' : {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36'}
    }; 


  var response = UrlFetchApp.fetch('https:/www.google-analytics.com//collect',options);

  return response; 
}

When I send the request to https://www.google-analytics.com/debug/collect to validate the request, I get a valid response. Also, when I test the generated payload in the Request Builder , it works! I just doesnt work when the request is done by the Google App Scripts.

Does someone know why that would happen?

Thanks!

Ian Brant Ian Brant · Accepted Answer · 2020-02-04T18:31:12

Well, turns out it was an IP issue. Google AppsScripts send the requests using some standard IPs that Google Analytics identifies as being bots, so I just needed to specify the IP adress in the request.

POST Request to Google Analytics with Measurement Protocol from the App Script returns valid response but doesnt work

2 Answers