Skip to content

Instantly share code, notes, and snippets.

@bob2314

bob2314/Slackbot.double

Forked from senyaitiya/Slackbot.double
Created October 23, 2018 17:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save bob2314/73fdfa004b5c96aead7062f781d731d5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save bob2314/73fdfa004b5c96aead7062f781d731d5 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @senyaitiya senyaitiya revised this gist Jul 17, 2018. No changes.
  2. @senyaitiya senyaitiya revised this gist Jul 11, 2018. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions Slackbot.double
    View file
    Original file line number Diff line number Diff line change
    @@ -17,5 +17,6 @@ function doPost(y) {

    return app.postMessage("#general", message, {
    username: name,
    icon_emoji: ':emojiname:'
    });
    }
  3. @senyaitiya senyaitiya revised this gist Jul 9, 2018. 1 changed file with 5 additions and 5 deletions.
    10 changes: 5 additions & 5 deletions Slackbot.double
    View file
    Original file line number Diff line number Diff line change
    @@ -7,13 +7,13 @@ function doPost(y) {
    var spreadsheet = SpreadsheetApp.openById('sheetID');
    var sheet = spreadsheet.getSheetByName('シート1');

    var range = sheet.getRange("シート1!C1").setFormula('=INDIRECT("シート1!A:A" & INT(RAND()*15+1))');
    //A列からランダムで出力した結果をC列1番セルに出力
    var range2 = sheet.getRange("シート1!D1").setFormula('=INDIRECT("シート1!B:B" & INT(RAND()*10+1))');
    //B列からランダムで出力した結果をD列1番セルに出力
    var range = sheet.getRange("シート1!C1").setFormula('=INDIRECT("シート1!A:A" & INT(RAND()*n+1))');
    //A列内からランダムでC列1番セルに出力
    var range2 = sheet.getRange("シート1!D1").setFormula('=INDIRECT("シート1!B:B" & INT(RAND()*n+1))');
    //B列内からランダムでD列1番セルに出力

    var message =sheet.getRange("シート1!C1").getValue()+sheet.getRange("シート1!D1").getValue();
    //C1セルとD1セルの内容をつなげてbotの発言として出力
    //C1セルとD1セルの内容をつなげてbotの投稿として出力

    return app.postMessage("#general", message, {
    username: name,
  4. @senyaitiya senyaitiya revised this gist Jul 2, 2018. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions Slackbot.double
    View file
    Original file line number Diff line number Diff line change
    @@ -6,6 +6,7 @@ function doPost(y) {
    var app = SlackApp.create(token);
    var spreadsheet = SpreadsheetApp.openById('sheetID');
    var sheet = spreadsheet.getSheetByName('シート1');

    var range = sheet.getRange("シート1!C1").setFormula('=INDIRECT("シート1!A:A" & INT(RAND()*15+1))');
    //A列からランダムで出力した結果をC列1番セルに出力
    var range2 = sheet.getRange("シート1!D1").setFormula('=INDIRECT("シート1!B:B" & INT(RAND()*10+1))');
  5. @senyaitiya senyaitiya revised this gist Jul 2, 2018. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion Slackbot.double
    View file
    Original file line number Diff line number Diff line change
    @@ -7,12 +7,14 @@ function doPost(y) {
    var spreadsheet = SpreadsheetApp.openById('sheetID');
    var sheet = spreadsheet.getSheetByName('シート1');
    var range = sheet.getRange("シート1!C1").setFormula('=INDIRECT("シート1!A:A" & INT(RAND()*15+1))');
    //A列からランダムで出力した結果をC列1番セルに出力
    var range2 = sheet.getRange("シート1!D1").setFormula('=INDIRECT("シート1!B:B" & INT(RAND()*10+1))');
    //B列からランダムで出力した結果をD列1番セルに出力

    var message =sheet.getRange("シート1!C1").getValue()+sheet.getRange("シート1!D1").getValue();
    //C1セルとD1セルの内容をつなげてbotの発言として出力

    return app.postMessage("#general", message, {
    username: name,
    });

    }
  6. @senyaitiya senyaitiya revised this gist Jul 2, 2018. 1 changed file with 3 additions and 2 deletions.
    5 changes: 3 additions & 2 deletions Slackbot.double
    View file
    Original file line number Diff line number Diff line change
    @@ -6,8 +6,9 @@ function doPost(y) {
    var app = SlackApp.create(token);
    var spreadsheet = SpreadsheetApp.openById('sheetID');
    var sheet = spreadsheet.getSheetByName('シート1');
    var range = sheet.getRange("シート1!C1").setFormula('=INDIRECT("シート1!A:A" & INT(RAND()*31+1))');
    var range2 = sheet.getRange("シート1!D1").setFormula('=INDIRECT("シート1!B:B" & INT(RAND()*12+1))');
    var range = sheet.getRange("シート1!C1").setFormula('=INDIRECT("シート1!A:A" & INT(RAND()*15+1))');
    var range2 = sheet.getRange("シート1!D1").setFormula('=INDIRECT("シート1!B:B" & INT(RAND()*10+1))');

    var message =sheet.getRange("シート1!C1").getValue()+sheet.getRange("シート1!D1").getValue();

    return app.postMessage("#general", message, {
  7. @senyaitiya senyaitiya created this gist Jul 2, 2018.
    17 changes: 17 additions & 0 deletions Slackbot.double
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,17 @@
    function doPost(y) {
    var token = PropertiesService.getScriptProperties().getProperty("xoxp-123");
    var name = "name";

    var token = PropertiesService.getScriptProperties().getProperty('SLACK_ACCESS_TOKEN');
    var app = SlackApp.create(token);
    var spreadsheet = SpreadsheetApp.openById('sheetID');
    var sheet = spreadsheet.getSheetByName('シート1');
    var range = sheet.getRange("シート1!C1").setFormula('=INDIRECT("シート1!A:A" & INT(RAND()*31+1))');
    var range2 = sheet.getRange("シート1!D1").setFormula('=INDIRECT("シート1!B:B" & INT(RAND()*12+1))');
    var message =sheet.getRange("シート1!C1").getValue()+sheet.getRange("シート1!D1").getValue();

    return app.postMessage("#general", message, {
    username: name,
    });

    }