Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function addLinksFromSheet() {
- var sheet = SpreadsheetApp.openById("YOUR_SPREADSHEET_ID").getSheetByName("Sheet1");
- var data = sheet.getDataRange().getValues();
- var document = DocumentApp.getActiveDocument();
- var body = document.getBody();
- keywords = []
- for (var i = 0; i < data.length; i++) {
- var searchPhrase = data[i][0];
- var hyperlink = data[i][1];
- keywords.push([searchPhrase, hyperlink])
- }
- keywords.sort(() => Math.random() - 0.5)
- foundLinks = 0
- for ( i=0; i< keywords.length) {
- if foundLinks >= 12 {
- break;
- }
- var keyword = keywords[i]
- if (body.indexOf(keyword[0]) !== -1) {
- body.replace(keyword[0], `<a href="${keyword[1]">${keyword[0]}</a>`);
- foundLinks += 1
- }
- }
- var search = null;
- var count = 0;
- while (count < 1 && (search = body.findText(searchPhrase, search))) {
- var searchElement = search.getElement();
- var startIndex = search.getStartOffset();
- var endIndex = search.getEndOffsetInclusive();
- searchElement.asText().setLinkUrl(startIndex, endIndex, hyperlink);
- count++;
- }
- }
- document.saveAndClose();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement