What’s the Best Way to Gather SEO Data for Your Website? or How Do You Efficiently Gather SEO Data Wi

Try Nightwatch.io.

It’s built for tracking rankings across multiple sites, and the UI doesn’t make you want to scream.

Also, if you’re stuck with spreadsheets, use Google Apps Script to auto-pull data. A bit of setup, but worth it.