Advertisement
incomestreamsurfer

Internal linking script sEO

Feb 15th, 2023 (edited)
664
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | Help | 0 0
  1.  
  2. function addLinksFromSheet() {
  3. var sheet = SpreadsheetApp.openById("YOUR_SPREADSHEET_ID").getSheetByName("Sheet1");
  4. var data = sheet.getDataRange().getValues();
  5.  
  6. var document = DocumentApp.getActiveDocument();
  7. var body = document.getBody();
  8.  
  9. keywords = []
  10. for (var i = 0; i < data.length; i++) {
  11. var searchPhrase = data[i][0];
  12. var hyperlink = data[i][1];
  13. keywords.push([searchPhrase, hyperlink])
  14. }
  15. keywords.sort(() => Math.random() - 0.5)
  16. foundLinks = 0
  17. for ( i=0; i< keywords.length) {
  18. if foundLinks >= 12 {
  19. break;
  20. }
  21. var keyword = keywords[i]
  22. if (body.indexOf(keyword[0]) !== -1) {
  23. body.replace(keyword[0], `<a href="${keyword[1]">${keyword[0]}</a>`);
  24. foundLinks += 1
  25. }
  26. }
  27.  
  28. var search = null;
  29. var count = 0;
  30. while (count < 1 && (search = body.findText(searchPhrase, search))) {
  31. var searchElement = search.getElement();
  32. var startIndex = search.getStartOffset();
  33. var endIndex = search.getEndOffsetInclusive();
  34. searchElement.asText().setLinkUrl(startIndex, endIndex, hyperlink);
  35. count++;
  36. }
  37. }
  38.  
  39. document.saveAndClose();
  40. }
  41.  
  42.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement