You can get your list of websites and use seo tools for excel (14 days of trial and you can use a fake email every time) to get the data More on reddit.com

This is too old way to do What you can do Install "SERP Snippet Extractor Extension" (pin it) Set your Chrome browser results from 10 to 100 (if you want more than 10) Use operator (site:) to whatever website you want Click on the extension by default copy all SERP results and paste them into Google Sheets. Yes, it works with a search query to Voila! There are other methods as well You can also do it with an SEOquake extension as well or bookmarklet. More on reddit.com