franzenzenhofer

let l = window.location;
const p = new URLSearchParams(l.search);
p.set('hl','en');
window.location.search="?"+p.toString();


//minified bookmarklet code
//javascript:let l=window.location,p=new URLSearchParams(l.search);p.set("hl","en");window.location.search="?"+p.toString();

franzenzenhofer

<script>

var mui = function()
{
	var fired = false;
	var kickTrigger = function()
	{
		if(fired === true){return false;}
        //console.log("miniumal-user-interaction");
        dataLayer.push({'minimal-user-interaction': true});

franzenzenhofer

{
    "exportFormatVersion": 2,
    "exportTime": "2020-10-06 15:31:33",
    "containerVersion": {
        "path": "accounts/6000775609/containers/32949204/versions/0",
        "accountId": "6000775609",
        "containerId": "32949204",
        "containerVersionId": "0",
        "container": {
            "path": "accounts/6000775609/containers/32949204",

franzenzenhofer

function createChart() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  // Get the last row with content
  var lastRow = sheet.getLastRow();
  
  // Get data range
  var dataRange = sheet.getRange('A2:B' + lastRow);
  var data = dataRange.getValues();

franzenzenhofer

function analyzeURLs() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const data = sheet.getDataRange().getValues();

    deleteSheets(['Page Type Analysis', 'Language Namespace Analysis', 'Parameters Analysis', 'Copied & Analyzed']);

  // Create a copy of the original sheet
  const newSheet = sheet.copyTo(SpreadsheetApp.getActiveSpreadsheet());
  newSheet.setName('Copied & Analyzed');

franzenzenhofer

function generateCharts() {
  // Access the sheet
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Devices');
  
  // Sort Column A
  sheet.getRange('A2:E4').sort(1);
  
  // Get the range for your data
  var dataRange = sheet.getRange('A1:E4');

franzenzenhofer

// Global spreadsheet object
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
//console.log(spreadsheet);

function main() {
  console.log("main");
  generateLineCharts();
}

// Function to delete multiple sheets

franzenzenhofer

function calculateAndCreatePieChart() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName('Queries');
  var chartSheetName = 'brand';
  var brandstring = "radar";
  
  // Remove old chart sheet if exists
  var oldChartSheet = spreadsheet.getSheetByName(chartSheetName);
  if (oldChartSheet) spreadsheet.deleteSheet(oldChartSheet);

franzenzenhofer

function analyzeURLs() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const data = sheet.getDataRange().getValues();

  deleteSheets(['Page Type Analysis', 'Language Namespace Analysis', 'Parameters Analysis', 'Copied & Analyzed']);

  // Create a copy of the original sheet
  const newSheet = sheet.copyTo(SpreadsheetApp.getActiveSpreadsheet());
  newSheet.setName('Copied & Analyzed');

franzenzenhofer

const axios = require('axios');
const cheerio = require('cheerio');
const argv = require('yargs').argv;
const sleep = require('util').promisify(setTimeout);

const start_url = argv._[0] || '';
const delay = argv.s || 1;

const headers = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3',