Bring your Atlassian Marketplace data to Google Sheets and create reports and charts to visualize your sales performance, licensing data or, conversion events.
🗄️️ Available datasets:
Clone the repository and install dependencies.
git clone https://github.com/toolsplus/atlassian-marketplace-sheets-connector
cd atlassian-marketplace-sheets-connector
npm install
Enable the Google Apps Script API: https://script.google.com/home/usersettings
Log in to Google clasp and authorize using your Google account.
npx clasp login
Create a new Google Script in your Google Drive.
npx clasp create --type sheets --title "Atlassian Marketplace Sheets Connector" --rootDir ./dist
Deploy the project (production or development build).
// Production build
npm run deploy:prod
// Development build
npm run deploy
Once you have deployed the connector script go to the associated Google Sheet > Add-ons > Atlassian Marketplace Sheets Connector > Login.
You will be asked to enter your Atlassian account email and API token. If you do not have an API token you can generate one at https://id.atlassian.com/manage/api-tokens. Refer to the Atlassian documentation for further details on how to generate API tokens.
Currently, the script will check the list of available vendors for the logged-in user and select the first one.
Once you have successfully logged in you can import data into the Google Sheet by clicking Add-ons > Atlassian Marketplace Sheets Connector > Load datasets