It helps to have Windows 11 as the snipping tool has a very good text extractor.
Go to sitechecker.pro
Make a free trial.
Enter website that you want to extract URLs from.
Go to “Site Audit” on the left toolbar (highlighted here)
Choose “Indexable pages” and “View all pages”
Go to notion and make a page where you will paste every URL you copy. (I used notion because it automatically formatted the links close to the way I wanted them - it removed most/all of the URL line breaks. You may use a Google doc or whatever works)
Open Snipping Tool (again, Windows 11 is what I used)
Go through the list 10 links at a time and take a screenshot of the links. Nothing else.
After each screenshot, click on “Text actions”.
Wait for these 2 buttons to load, then click on “Copy all text”
Paste your links in the notion page you created
Keep doing this until you go through all the links (should take you 3-5 minutes tops).
Copy the entire notion document to a Google docs file.
You will notice “Q” after every link. It’s there because the text extractor confuses the “search” symbol.
Go to make.com
Make a scenario.
Choose the “Google Docs” module.
Choose “Replace a text in a document”
Choose the folder and file from your Drive.