Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getChannelsDetails() {
- let ss = SpreadsheetApp.getActive();
- let sh_settings = ss.getSheetByName('Настройки');
- let sh_paste = ss.getSheetByName('Результат');
- sh_settings.getDataRange().getValues().slice(1)
- .forEach(row => {
- if (row[1]) {
- let members, online, bio
- let url = `${row[0]}/?pagehidden=false`;
- let response = UrlFetchApp.fetch(url).getContentText();
- let match_members = response.match(/"tgme_page_extra">(.+?)<\/div>/)?.[1];
- if (match_members) {
- [members, online] = match_members.replace(/members|online|subscribers|\/s/g, '').split(',')
- }
- bio = response.match(/tgme_page_description" dir="auto">(.+?)<\/div>/)?.[1];
- let row_to_paste = [[new Date(), row[0], members, online, bio]];
- sh_paste.insertRowBefore(2);
- sh_paste.getRange(2, 1, row_to_paste.length, row_to_paste[0].length).setValues(row_to_paste);
- }
- })
- }
- function onOpen(e) {
- SpreadsheetApp.getUi()
- .createMenu("❄️")
- .addItem("парсим!", "getChannelsDetails")
- .addToUi();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement