II would like to build an automatic report Dashboard with VBA. Is it possible to use the Google Analytics funtions from VBA? I haven’t found a way to do it yet.
Yes, it is possible, see this guide:
When VBA outputs a Google Analytics formula, SeoTools will automatically login the first time and get the access token.