I am new at SEOtoolsforexcel and am fascinated by this tool.
Currently, I am trying to extract the recently published articles of a site. My goal is to extract the outbound links from these articles. I don't know how to do that with this tool. I tried to break this task into two subtasks;
Subtask 1: Getting the recently published articles URL list -- I tried the spider, google search, and bing search functions to get the URL list and then sort it by recent google cache date to get my list. It's not working properly. First of all, this gives me random category and tag page URLs, and secondly, the google cache says limit reached after I get some of the cache dates. Is there any way to derive the publish dates or recently published article lists?
Subtask 2: Extracting external links from a URL: Suppose I am successful at getting the list. to extract the external links I used XpathonURL functions. But this gives me a long list. Can I filter out the only external links?
I tried to find tutorials about this tool, but all I can find is some 7/8 years old video. Can anyone refer me to any tutorial (articles or video) of this tool? If there are none, I think it would be great if you guys compile a tutorial of different functions in detail.