谷歌脚本每分钟触发一次不起作用

Google scripts every minute trigger not working

本文关键字:一次 不起作用 脚本 每分钟 谷歌      更新时间:2023-09-26

我有以下脚本

    function scraper() {
        var url = 'http://gpa.shet.com.aspx';
        var sss = SpreadsheetApp.getActiveSpreadsheet();
        //var ss = SpreadsheetApp.openById('1im78ip4Wcmb1xbfZs8Lqy3-LP1SU9rC8E5OfKbOjJDg');
        //var sss = SpreadsheetApp.setActiveSpreadsheet(ss);
        var sheet = sss.getSheetByName("Sheet1");
        var rows = sheet.getDataRange();
        var numRows = rows.getNumRows();
        var response = UrlFetchApp.fetch(url);
        var contentText = response.getContentText();
        var pr = sheet.getRange('A1:Z1000');
        var cstring = contentText.tostring;
        var ui = SpreadsheetApp.getUi();
        var NHL = "New Agent";
        var nlength = contentText.length;
        // ui.alert(nlength);
        //ui.alert(contentText);
        //var g = 5;
        var clength = 200000;
        ///
        var temp = contentText;
        var count = (temp.match(/New Hot Lead/g) || []).length;
        var C6 = sheet.getRange('C6');
        var C8 = sheet.getRange('C8');
        var C10 = sheet.getRange('C10').getValue();
        var C10r = sheet.getRange('C10');
        if (count > 0) {
            var d = new Date();
            var hrs = d.getHours();
            var mins = d.getMinutes();
            var time1 = hrs + ":" + mins;
            if (C6.isBlank() == true) {
                C6.setValue(time1);
            } else if (C6.isBlank() == false) {
                C8.setValue(time1);
            }
        }
        if (count == 0) {
            C6.clear();
            C8.clear();
        }
        var time2 = 0.00347222222222222;
        if (C10 >= time2) {
            var D10 = sheet.getRange("D10");
            var alert = "NHLs for more than 5 minutes!";
            D10.setValue(alert);
            D10.setFontColor('Red');
        }
    }

现在,问题不在于代码本身,因为当我手动运行它时,它确实按预期的方式工作。我的问题在于时间驱动的触发器。我尝试每分钟手动设置一次,并在函数的末尾和外部添加触发器生成器代码,但它仍然不起作用。有哪些建议?

尝试使用 sleep 函数 60 秒。

sleep(60000);