Automated Internal Linking Tool (Google Docs & Google sheets)

📌 What the Script Does

• Adds up to 15 internal links into a Google Doc by matching keywords from a Google Sheet.
• Searches the doc for each keyword and applies a hyperlink to the first valid instance it finds.
• Ensures links are only added when:
  • The keyword is not already linked.
  • The keyword is not in bold text.
  • The keyword is not inside a heading.
  • The same link hasn’t already been used.

📄 Prep Document Requirements (Google Sheet)

• The script expects a Google Sheet named: Keywords
• Each row must contain:
  • Column A: Keyword or phrase (e.g. best mouse )
  • Column B: URL to link the keyword to (e.g., https://example.com/best-mouse)
• Example sheet layout linked here (will be linked in the doc)

Action Items for First-Time Setup 

🔧 1. Click to Make a Copy of the Automated Internal Linking sheet

📄 2. Prepare the Google Sheet [Click to make a copy]

• Create a Google Sheet with the exact sheet/tab name: "Keywords".
  • Example sheet layout linked here
    
    
• Add the following columns:
  • Column A: Keyword or phrase you want to link (e.g. best mouse )
  • Column B: Corresponding URL to link to (e.g., https://example.com/best-mouse)
• Make sure there are no empty rows or missing data in those columns.
  

🔑 3. Replace the Sheet ID in the AppScript Present in the Google Doc

Replace the existing ID with your own Sheet’s ID, which is found in the URL:
-> Code section in AppScript: var YOUR_GOOGLE_SHEET_ID = "Enter Your Sheet ID HERE";

-> Identify Google Sheet ID: https://docs.google.com/spreadsheets/d/**YOUR_SHEET_ID**/edit

📚 4. Test the Google Doc - Internal Linking Tool

• Add the content to the Google Doc to add internal links 

▶️ 5. Run the Script

• In the Google Doc, after running the script on AppScript and allowing access, refresh the page.
• You’ll see a new menu item called: Internal Links → Click Add Internal Links.
• The script will insert up to 15 internal links based on your Sheet.

✅ 6. Review and Adjust

• Review the document:
  • Were the links inserted correctly?
  • Are some keywords not linking? (Could be because they're bold, already linked, or inside a heading.)
    
• Tweak your Sheet, content, or script conditions as needed.
  
  

🛠 Optional Customizations

Increase or decrease the link limit (MAX_INTERNAL_LINKS).