information_gathering

To gather information such as security news using Google Apps Script and Google Spreadsheet. Developed by clasp.

Requirement

• Node.js: 18.x
• npm: 9.x

Install

npm install

as needed: clasp

npm install -g @google/clasp

Usage

Sign in to Google Apps:

clasp login

Then enable the Google Apps Script API: https://script.google.com/home/usersettings

Create Sheet:

clasp create --type sheets --rootDir ./dist

Deploy:

npm run deploy

Run functions in Apps Script:

• createInfoAll
• uploadInfoAll
• execSecurityNext
• execHatenaBlog
• execHatenaBookmark
• execITmedia
• execTheHackerNews
• execUCCard
• execQiita
• execRSS2

Details: functions in Apps Script

• createInfoAll

  • Get the data from each website and write it to spreadsheets.

• uploadInfoAll

  • Send the data written in the spreadsheets to Slack.

  • Needs: set a script property SLACK_URL
    ex. https://hooks.slack.com/services/XXXXXXX/YYYYYY/ZZZZZZZZZZZZZ

• execSecurityNext

  • Get the data about Security Next and send it to Slack.

• execHatenaBlog

  • Get the data about はてなブログ and send it to Slack.

  • Needs: set a script property HATENA_BLOG_URLS
    Set the Hatena blog URLs separated by commas.
    ex. https://XXX.hatenadiary.jp/rss,https://YYY.hatenablog.com/rss

• execHatenaBookmark

  • Get the data about はてなブックマーク with security tags and send it to Slack.

• execITmedia

  • Get the data about ITmedia and send it to Slack.

• execTheHackerNews

  • Get the data about The Hacker News and send it to Slack.

• execUCCard

  • Get the data about UCカード 重要なお知らせ and send it to Slack.

• execQiita

  • Get the data about Qiita and send it to Slack.

  • Needs: set a script property QIITA_URLS
    Set the Hatena blog URLs separated by commas.
    ex. https://qiita.com/tags/rails/feed,https://qiita.com/tags/security/feed

• execRSS2

  • Get the data format RSS2.0 and send it to Slack.

  • Needs: set a script property RSS2_URLS
    Set the URLs separated by commas.
    ex. https://XXX.com/rss,https://YYY.jp/rss

Test

npm test

License

MIT

Author

salty-byte