Knowing the search intent for your keywords is very important for your content plan and strategy. It can give you hints about what your content is missing. You can get the search intent using Python by importing the data, including the keywords from Google Search Console. And Pandas library to read the data into data frames, and another Python function to assign the keywords into groups.
You can get the URLs of any WordPress website by using Python libraries such as BeautifulSoup for scraping the XML sitemap content, Requests to make the requests, and the Pandas library to save the URLs in a data frame where you can export it later to Excel or Google sheets.