Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // This constant is written in column C for rows for which an email
- // has been sent successfully.
- var Pushed_SENT = "Pushed";
- function pushToGA() {
- var sheet = SpreadsheetApp.getActiveSheet();
- var startRow = 8; // First row of data to process
- var trueRange = sheet.getRange(startRow,1,500,8);
- var GaID = sheet.getRange('E2').getValues();
- var data = trueRange.getValues();
- for (var i = 0; i < data.length; ++i) {
- var row = data[i];
- var pushSent = row[1];
- var cid = row[2];
- var paid = row[4]; //сумму привести к виду
- var service = row[7];
- var value = row[6];
- var nameProduct = encodeURIComponent(row[7]);
- Logger.log(nameProduct + " " + row[7]);
- var urlGA = "http://www.google-analytics.com/collect?v=1&tid=" + GaID + "&cid=";
- if (paid == 'да') { //проверяем наличие оплатил
- if (value != ''){ //проверяем наличие суммы
- if (service != ''){ //проверяем наличие название услуги
- if (pushSent != Pushed_SENT) { //проверяем отправку
- Logger.log(urlGA + cid + "&t=event&ec=pay_success&ea="+ nameProduct +"&ev=" + value);
- //event
- UrlFetchApp.fetch(urlGA + cid + "&t=event&ec=pay_success&ea="+ nameProduct +"&ev=" + value);
- //устанавливаем статус
- sheet.getRange(startRow + i, 2).setValue(Pushed_SENT);
- }
- }}
- }
- }
- }
Add Comment
Please, Sign In to add comment