I'm trying to build a dashboard in Google Sheets that allows me to search for data from 5 different Google Analytics accounts. I have access to all 5 of these accounts, but I want to be able to search through them by running a script from my main dev account.

There are several hundred profiles, and the limit for each user is 100 profiles, so I can't just add permissions to the dev account.

Is there some way to authenticate my dev account so that it has access to these 5 other accounts?

I'd like to do this exclusively in Apps Script.