AX1 Add-on for Google Sheets™: Your Live Data, Instantly.
For AX1 clients using Google Workspace™. Fetch live client data—like sales, metrics, or account details—directly into your Google Sheets™ without manual exports.
How it Works
Open the AX1 Add-on from the Extensions menu on your sheet.
Navigate to Data imports - this opens the Add-on at the side of the screen.
Click Add data import and input the details of your required data then click on Add.
This action fetches your data from AX1 and populates your sheets with the data.
Transparency in Data Usage
To provide its service, the AX1 Add-on needs your permission to perform specific actions within your Google Workspace™ environment and connect to AX1.
View and manage the current spreadsheet only (
spreadsheets.currentonly
): This allows the add-on to write the fetched AX1 data directly into the sheet you have open and are actively using. It cannot access other spreadsheets.Display UI elements within Google Sheets™ (
script.container.ui
): Needed to show you the sidebar form where you select the data you want to import.Connect to external services (
script.external_request
): Required to securely send your data request (type, year, account you entered) to the AX1 API and retrieve the corresponding data for you.View your basic profile info & email address (
userinfo.email
,userinfo.profile
,openid
): Standard permissions to identify you within the Google environment and ensure the add-on runs correctly under your account." (Or adjust if you use this info more specifically).
The add-on acts as a conduit. It uses the parameters you provide solely to request and display data from your AX1 account. We do not store your Google credentials or your AX1 data within the add-on itself.