The Google Sheets App is available within Google Sheets from the Google Workspace Marketplace. This app enables you to pull data from the integrations you've connected to AgencyAnalytics directly into a Google Sheet.
Before following the connection steps below, first ensure that your browser is set to allow all cookies. If this setting is not turned on, you may run into issues logging into the app.
Connecting the AgencyAnalytics App within Google Sheets
To get started, open the AgencyAnalytics Google Workspace Marketplace here. On this page, click Install in the upper right to begin the installation process.
A small popover will display in the center of the page. In the bottom right of this window, click Continue to launch a Google authentication window.
Next, choose the account you'd like to use with our Google Sheets App.
Lastly, click Allow on the final authorization page to confirm our permissions.
Now that the app is connected, you'll need to login to the add-on with your AgencyAnalytics credentials. Click Extensions at the top of the page, then hover AgencyAnalytics, before clicking Launch Sidebar from the dropdown.
This will open the AgencyAnalytics sidebar. Click the Site Address field, and enter in the URL you use when logging into AgencyAnalytics. If you're a staff user, this would be the URL you sign into our platform from. If you're not sure, follow the steps here to locate the custom URL. If you're the Admin of your AgencyAnalytics account, click Login as Admin instead.
Enter in the same email address and password you use on AgencyAnalytics.com in the Email and Password fields, then login.
Now that you've authenticated the app, and logged into your AgencyAnalytics account, you're ready to create your first query, and start pulling data into sheets.