Script, code, or macros to pull data on what a companies GMB status is.

Basically i am looking for something that can scan a SERP or GMB profile and pull basic data from it. Would love it to be something quick that can be done in bulk. Would be perfect is it could be done in excel or google docs.

Additionally would love something that does this for websites. something that could pull DA (using a free tool), website status, #pages, & page titles.

Anyone have any ideas? Or maybe the best place to look?