snegir

google sheets to ga

Sep 4th, 2019
551
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. // This constant is written in column C for rows for which an email
  2. // has been sent successfully.
  3. var Pushed_SENT = "Pushed";
  4.  
  5. function pushToGA() {
  6. var sheet = SpreadsheetApp.getActiveSheet();
  7. var startRow = 8; // First row of data to process
  8. var trueRange = sheet.getRange(startRow,1,500,8);
  9. var GaID = sheet.getRange('E2').getValues();
  10. var data = trueRange.getValues();
  11. for (var i = 0; i < data.length; ++i) {
  12. var row = data[i];
  13. var pushSent = row[1];
  14. var cid = row[2];
  15. var paid = row[4]; //сумму привести к виду
  16. var service = row[7];
  17. var value = row[6];
  18. var nameProduct = encodeURIComponent(row[7]);
  19. Logger.log(nameProduct + " " + row[7]);
  20.  
  21. var urlGA = "http://www.google-analytics.com/collect?v=1&tid=" + GaID + "&cid=";
  22.  
  23.  
  24. if (paid == 'да') { //проверяем наличие оплатил
  25. if (value != ''){ //проверяем наличие суммы
  26. if (service != ''){ //проверяем наличие название услуги
  27.  
  28. if (pushSent != Pushed_SENT) { //проверяем отправку
  29.  
  30. Logger.log(urlGA + cid + "&t=event&ec=pay_success&ea="+ nameProduct +"&ev=" + value);
  31. //event
  32. UrlFetchApp.fetch(urlGA + cid + "&t=event&ec=pay_success&ea="+ nameProduct +"&ev=" + value);
  33.  
  34. //устанавливаем статус
  35. sheet.getRange(startRow + i, 2).setValue(Pushed_SENT);
  36. }
  37. }}
  38.  
  39. }
  40. }
  41.  
  42.  
  43. }
Add Comment
Please, Sign In to add comment