1
// 方法A: TwitterWebServiceを使った認証およびコールバック: Start ----------------------------------------------
2
// 方法Aの日本語アカウント用: Start ----------------------------------------
3
// //認証用インスタンスの生成
4
// const twitter = TwitterWebService.getInstance(
5
//   apiKeyTwitterAccountJp, //API Key
6
//   apiKeySecretTwitterAccountJp //API secret key
7
// );
8

9
// //アプリを連携認証する
10
// function authorize() {
11
//   twitter.authorize();
12
// }
13

14
// //認証を解除する
15
// function reset() {
16
//   twitter.reset();
17
// }
18

19
// //認証後のコールバック
20
// function authCallback(request) {
21
//   return twitter.authCallback(request);
22
// }
23
// 方法Aの日本語アカウント用: End ----------------------------------------
24
// 方法Aの英語アカウント用: Start ----------------------------------------
25
// //認証用インスタンスの生成
26
// const twitter = TwitterWebService.getInstance(
27
//   apiKeyTwitterAccountEn, //API Key
28
//   apiKeySecretTwitterAccountEn //API secret key
29
// );
30

31
// //アプリを連携認証する
32
// function authorize() {
33
//   twitter.authorize();
34
// }
35

36
// //認証を解除する
37
// function reset() {
38
//   twitter.reset();
39
// }
40

41
// //認証後のコールバック
42
// function authCallback(request) {
43
//   return twitter.authCallback(request);
44
// }
45
// 方法Aの英語アカウント用: End ----------------------------------------
46
// 方法A: TwitterWebServiceを使った認証およびコールバック: End ----------------------------------------------
47

48
// 方法B: OAuth1.createServiceを使った認証およびコールバック: Start ----------------------------------------------
49
// 方法Bの日本語アカウント用: Start ----------------------------------------
50
// function getTwitterServiceJp() {
51
//   // Create a new service with the given name. The name will be used when
52
//   // persisting the authorized token, so ensure it is unique within the
53
//   // scope of the property store.
54
//   return OAuth1.createService('twitter')
55
//     // Set the endpoint URLs.
56
//     .setAccessTokenUrl('https://api.twitter.com/oauth/access_token')
57
//     .setRequestTokenUrl('https://api.twitter.com/oauth/request_token')
58
//     .setAuthorizationUrl('https://api.twitter.com/oauth/authorize')
59
//     // Set the consumer key and secret.
60
//     .setConsumerKey(apiKeyTwitterAccountJp)
61
//     .setConsumerSecret(apiKeySecretTwitterAccountJp)
62
//     // Set the name of the callback function in the script referenced
63
//     // above that should be invoked to complete the OAuth flow.
64
//     .setCallbackFunction('authCallback')
65
//     // Set the property store where authorized tokens should be persisted.
66
//     .setPropertyStore(PropertiesService.getUserProperties());
67
// }
68
function getTwitterServiceJp() {
69
  return OAuth1.createService("Twitter")
70
    .setAccessTokenUrl("https://api.twitter.com/oauth/access_token")
71
    .setRequestTokenUrl("https://api.twitter.com/oauth/request_token")
72
    .setAuthorizationUrl("https://api.twitter.com/oauth/authorize")
73
    .setConsumerKey(apiKeyTwitterAccountJp)
74
    .setConsumerSecret(apiKeySecretTwitterAccountJp)
75
    .setAccessToken(accessTokenTwitterAccountJp, accessTokenSecretTwitterAccountJp);
76
};
77
function showSidebarToAuthJp() {
78
  let twitterService = getTwitterServiceJp();
79
  if (!twitterService.hasAccess()) {
80
    let authorizationUrl = twitterService.authorize();
81
    let template = HtmlService.createTemplate(
82
        '<a href="<?= authorizationUrl ?>" target="_blank">Authorize</a>. ' +
83
        'Reopen the sidebar when the authorization is complete.');
84
    template.authorizationUrl = authorizationUrl;
85
    let page = template.evaluate();
86
    SpreadsheetApp.getUi().showSidebar(page);
87
  } else {
88
    //
89
  }
90
}
91
function authCallbackJp(request) {
92
  let twitterService = getTwitterServiceJp();
93
  let isAuthorized = twitterService.handleCallback(request);
94
  if (isAuthorized) {
95
    return HtmlService.createHtmlOutput('Success! You can close this tab.');
96
  } else {
97
    return HtmlService.createHtmlOutput('Denied. You can close this tab');
98
  }
99
}
100
// 方法Bの日本語アカウント用: End ----------------------------------------
101

102
// 方法Bの英語アカウント用: Start ----------------------------------------
103
// function getTwitterServiceEn() {
104
//   // Create a new service with the given name. The name will be used when
105
//   // persisting the authorized token, so ensure it is unique within the
106
//   // scope of the property store.
107
//   return OAuth1.createService('twitter')
108
//     // Set the endpoint URLs.
109
//     .setAccessTokenUrl('https://api.twitter.com/oauth/access_token')
110
//     .setRequestTokenUrl('https://api.twitter.com/oauth/request_token')
111
//     .setAuthorizationUrl('https://api.twitter.com/oauth/authorize')
112
//     // Set the consumer key and secret.
113
//     .setConsumerKey(apiKeyTwitterAccountEn)
114
//     .setConsumerSecret(apiKeySecretTwitterAccountEn)
115
//     // Set the name of the callback function in the script referenced
116
//     // above that should be invoked to complete the OAuth flow.
117
//     .setCallbackFunction('authCallback')
118
//     // Set the property store where authorized tokens should be persisted.
119
//     .setPropertyStore(PropertiesService.getUserProperties());
120
// }
121
function getTwitterServiceEn() {
122
  return OAuth1.createService("Twitter")
123
    .setAccessTokenUrl("https://api.twitter.com/oauth/access_token")
124
    .setRequestTokenUrl("https://api.twitter.com/oauth/request_token")
125
    .setAuthorizationUrl("https://api.twitter.com/oauth/authorize")
126
    .setConsumerKey(apiKeyTwitterAccountEn)
127
    .setConsumerSecret(apiKeySecretTwitterAccountEn)
128
    .setAccessToken(accessTokenTwitterAccountEn, accessTokenSecretTwitterAccountEn);
129
};
130
function showSidebarToAuthEn() {
131
  let twitterService = getTwitterServiceEn();
132
  if (!twitterService.hasAccess()) {
133
    let authorizationUrl = twitterService.authorize();
134
    let template = HtmlService.createTemplate(
135
        '<a href="<?= authorizationUrl ?>" target="_blank">Authorize</a>. ' +
136
        'Reopen the sidebar when the authorization is complete.');
137
    template.authorizationUrl = authorizationUrl;
138
    let page = template.evaluate();
139
    SpreadsheetApp.getUi().showSidebar(page);
140
  } else {
141
    //
142
  }
143
}
144
function authCallbackEn(request) {
145
  let twitterService = getTwitterServiceEn();
146
  let isAuthorized = twitterService.handleCallback(request);
147
  if (isAuthorized) {
148
    return HtmlService.createHtmlOutput('Success! You can close this tab.');
149
  } else {
150
    return HtmlService.createHtmlOutput('Denied. You can close this tab');
151
  }
152
}
153
// 方法Bの英語アカウント用: End ----------------------------------------
154
// 方法B: OAuth1.createServiceを使った認証およびコールバック: End ----------------------------------------------
155

156
function postTweet(sentence, language) {
157
  // const service = twitter.getService(); // 方法Aによるサービス
158
  let service;
159
  let bearerTokenTwitterAccount;
160
  if(language === 'JP'){
161
    service = getTwitterServiceJp(); // 方法Bによるサービス
162
    bearerTokenTwitterAccount = bearerTokenTwitterAccountJp;
163
  }else if(language === 'EN'){
164
    service = getTwitterServiceEn(); // 方法Bによるサービス
165
    bearerTokenTwitterAccount = bearerTokenTwitterAccountEn;
166
  }
167

168
  const endPointUrl = 'https://api.twitter.com/1.1/statuses/update.json';
169
  const options = {
170
    'method': 'post',
171
    // 'headers' : {Authorization: 'Bearer ' + bearerTokenTwitterAccount},
172
    // "muteHttpExceptions" : true,
173
    "payload": {
174
      status: sentence
175
    }
176
  }
177
  try {
178
    let response = service.fetch(endPointUrl, options);
179
    console.log(response);
180
  } catch(e) {
181
    // 例外エラー処理
182
    console.log('Error:')
183
    console.log(e)
184
  }
185
}
186

187
function decideSentenceToTweet(wordArray, language){
188
  const funcName = 'decideSentenceToTweet';
189
  let sentenceToTweet = ''
190

191
  if(wordArray.length === 1){
192
    sentenceToTweet = wordArray[0];
193
    console.log(`${funcName}:${getStrRepeatedToMark('a')}: `);
194
    return sentenceToTweet;
195
  }
196
  if(language === 'JP'){
197
    sentenceToTweet = `${wordArray[0]}・${wordArray[1]}`;
198
  }
199
  if(language === 'EN'){
200
    sentenceToTweet = `${wordArray[0]}${wordArray[1]}`;
201
  }
202
  console.log(`${funcName}:${getStrRepeatedToMark('b')}: `);
203
  console.log(`sentenceToTweet:${sentenceToTweet}`);
204
  return sentenceToTweet;
205
}
206

207
function selectRowAtRandom(amountOfRow, offsetAmountOfRow){
208
  let randomFloat = 0;
209
  while(randomFloat === 0){
210
    randomFloat = Math.random();
211
  }
212
  return Math.floor(randomFloat * (amountOfRow)) + offsetAmountOfRow;
213
}
214

215
function selectWordsToTweet(language) {
216
  const funcName = 'selectWordsToTweet';
217
  const defaultRatio = 0.3;
218
  const irregularRatio = 0.2;
219
  let   isIrregular = false;
220

221
  let spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
222
  let sheet       = spreadsheet.getSheetByName(sheetNameDisseminating1st);
223
  let irregularIndex;
224
  let amountOfWords;
225
  let selectedRow;
226
  let wordArrayToTweet = [];
227

228
  // decide regular or irregular.
229
  irregularIndex = Math.random();
230
  console.log(`${funcName}:${getStrRepeatedToMark('a')}: irregularIndex is${irregularIndex}`);
231

232
  if(irregularIndex < irregularRatio){
233
    isIrregular = true;
234
  }
235
  console.log(`${funcName}:${getStrRepeatedToMark('b')}: isIrregular is${isIrregular}`);
236

237
  if(isIrregular === true){
238
    // irregular process.
239
    let cell_amount_of_word_language;
240
    let column_word_language;
241
    if(language === 'JP'){
242
      cell_amount_of_word_language = cell_amount_of_word_jp_for_irregular_1st;
243
      column_word_language = column_word_jp_for_irregular_1st;
244
    }
245
    if(language === 'EN'){
246
      cell_amount_of_word_language = cell_amount_of_word_en_for_irregular_1st;
247
      column_word_language = column_word_en_for_irregular_1st;
248
    }
249
    amountOfWords = Number(sheet.getRange(cell_amount_of_word_language).getValue());
250
    selectedRow   = selectRowAtRandom(amountOfWords, row_start_of_word_list);
251
    const irregularWord = String(sheet.getRange(selectedRow, column_word_language, 1, 1).getValue());
252
    console.log(`${funcName}:${getStrRepeatedToMark('c')}: irregularWord is${irregularWord}`);
253

254
    wordArrayToTweet.push(irregularWord);
255
    console.log(`${funcName}:${getStrRepeatedToMark('d')}: `);
256
    console.log(wordArrayToTweet);
257
    return wordArrayToTweet;
258
  }
259
  console.log(`${funcName}:${getStrRepeatedToMark('e')}: `);
260

261
  // regular process.
262
  let cell_amount_of_word_cardinal,
263
    column_word_cardinal,
264
    cell_amount_of_word_george,
265
    column_word_george;
266
  if(language === 'JP'){
267
    cell_amount_of_word_cardinal = String(cell_amount_of_word_jp_for_cardinal_1st);
268
    column_word_cardinal         = Number(column_word_jp_for_cardinal_1st);
269
    cell_amount_of_word_george   = String(cell_amount_of_word_jp_for_george_1st);
270
    column_word_george           = Number(column_word_jp_for_george_1st);
271
  }
272
  if(language === 'EN'){
273
    cell_amount_of_word_cardinal = String(cell_amount_of_word_en_for_cardinal_1st);
274
    column_word_cardinal         = Number(column_word_en_for_cardinal_1st);
275
    cell_amount_of_word_george   = String(cell_amount_of_word_en_for_george_1st);
276
    column_word_george           = Number(column_word_en_for_george_1st);
277
  }
278
  console.log(`${funcName}:${getStrRepeatedToMark('e')}: `);
279
  console.log(`cell_amount_of_word_cardinal:${cell_amount_of_word_cardinal}`);
280
  console.log(`column_word_cardinal:${column_word_cardinal}`);
281
  console.log(`cell_amount_of_word_george:${cell_amount_of_word_george}`);
282
  console.log(`column_word_george:${column_word_george}`);
283

284
  const amountOfWordsCardinal = Number(sheet.getRange(cell_amount_of_word_cardinal).getValue());
285
  selectedRow        = selectRowAtRandom(amountOfWordsCardinal, row_start_of_word_list);
286
  const wordCardinal = String(sheet.getRange(selectedRow, column_word_cardinal, 1, 1).getValue());
287
  const amountOfWordsGeorge = Number(sheet.getRange(cell_amount_of_word_george).getValue());
288
  selectedRow        = selectRowAtRandom(amountOfWordsGeorge, row_start_of_word_list);
289
  const wordGeorge   = String(sheet.getRange(selectedRow, column_word_george, 1, 1).getValue());
290
  console.log(`${funcName}:${getStrRepeatedToMark('e')}: `);
291
  console.log(`amountOfWordsCardinal:${amountOfWordsCardinal}`);
292
  console.log(`wordCardinal:${wordCardinal}`);
293
  console.log(`amountOfWordsGeorge:${amountOfWordsGeorge}`);
294
  console.log(`wordGeorge:${wordGeorge}`);
295

296
  wordArrayToTweet = [wordCardinal, wordGeorge];
297
  console.log(`${funcName}:${getStrRepeatedToMark('f')}: `);
298
  console.log(wordArrayToTweet)
299
  return wordArrayToTweet;
300
}
301

302
function main() {
303
  // Japanese mode.
304
  let wordArray = selectWordsToTweet('JP');
305
  let sentence  = decideSentenceToTweet(wordArray, 'JP');
306
  postTweet(sentence, 'JP');
307

308
  // English mode.
309
  wordArray = selectWordsToTweet('EN');
310
  sentence  = decideSentenceToTweet(wordArray, 'EN');
311
  postTweet(sentence, 'EN');
312

313
}

1
const sheetNameDisseminating1st = 'tweet';
2
const sheetNameDisseminating2nd = 'tweetメモ書き';
3
const sheetNameDisseminating3rd = 'replyRecord';
4

5
const sheetNameOthers1st        = '';
6

7
const cell_amount_of_word_jp_for_cardinal_1st  = 'A1';
8
const column_word_jp_for_cardinal_1st          = 2;
9
const cell_amount_of_word_jp_for_george_1st    = 'C1';
10
const column_word_jp_for_george_1st            = 4;
11
const cell_amount_of_word_jp_for_irregular_1st = 'E1';
12
const column_word_jp_for_irregular_1st         = 6;
13
const cell_amount_of_word_en_for_cardinal_1st  = 'G1';
14
const column_word_en_for_cardinal_1st          = 8;
15
const cell_amount_of_word_en_for_george_1st    = 'I1';
16
const column_word_en_for_george_1st            = 10;
17
const cell_amount_of_word_en_for_irregular_1st = 'K1';
18
const column_word_en_for_irregular_1st         = 12;
19
const row_start_of_word_list                   = 3;
20

21
const defaultWord_jp_cardinal_1st = 'カーディナル';
22
const defaultWord_jp_george_1st   = 'ジョージ';
23
const defaultWord_en_cardinal_1st = 'Cardinal';
24
const defaultWord_en_george_1st   = 'George';
25

26
const bearerTokenTwitterAccountJp    = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
27
const accessTokenTwitterAccountJp       = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
28
const accessTokenSecretTwitterAccountJp = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
29
const apiKeyTwitterAccountJp         = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
30
const apiKeySecretTwitterAccountJp   = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
31
const bearerTokenTwitterAccountEn    = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
32
const accessTokenTwitterAccountEn       = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
33
const accessTokenSecretTwitterAccountEn = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
34
const apiKeyTwitterAccountEn         = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
35
const apiKeySecretTwitterAccountEn   = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';