Appvibe Google Sheets Integration
Overview of Features
Key Features
- Adding Link: Embed Google Sheets links directly into Jira issues for quick access to spreadsheets.
- Editing Link: Update or modify embedded Google Sheets links as the spreadsheet changes.
- Remove Link: Remove links to Google Sheets when they are no longer relevant.
- View Link in Preview and Full Screen: Preview Google Sheets content or expand it to full screen.
- Sort Link: Organize Google Sheets links by custom criteria, name, or date.
- Realign Links: Adjust the positioning of Google Sheets links within the Jira issue.
- View Links in List or Tile View: Toggle between list or tile layout for viewing Google Sheets links.
- Manage Permissions: Control who can view and interact with Google Sheets links embedded in Jira.
- View History of Changes: Access the history of changes made to each Google Sheets link.
Overview of Features
Key Features
Feature 1:
Add Links: Embed Google Sheets links directly into Jira issues for quick access to spreadsheets. This feature allows for seamless integration and efficient navigation between Jira and Google Sheets, ensuring team members have quick access to the necessary spreadsheets directly from their Jira issues.
Feature 2:
Edit Links: Update or modify embedded Google Sheets links as the spreadsheet changes. This ensures that the most up-to-date spreadsheet information is always available, keeping all team members on the same page and avoiding any outdated or incorrect data references.
Feature 3:
Remove Links: Remove links when they are no longer relevant. This feature helps maintain a clutter-free workspace by allowing the removal of unnecessary or obsolete links from Jira issues, aiding in better organization and focus.
Feature 4:
View Links in Preview and Full Screen: Preview Google Sheets content or expand it to full screen. Users can quickly glance over the sheet's data with preview mode, or dive deeper with a full-screen view when more detailed analysis is required.
Feature 5:
Sort Links: Organize Google Sheets links by custom criteria, name, or date. This feature helps prioritize and find specific links quickly, enhancing productivity by allowing users to sort and organize links as per their preferences or needs.
Feature 6:
Realign Links: Adjust the positioning of Google Sheets links within the Jira issue. This provides flexibility in arranging and presenting links, allowing users to highlight the most important links where they are most needed within the issue.
Feature 7:
View Links in List or Tile View: Toggle between list or tile layout for viewing links. This visual flexibility ensures users can choose the most comfortable and efficient format for reviewing and organizing their embedded Google Sheets links.
Feature 8:
Manage Permissions: Control who can view and interact with Google Sheets links embedded in Jira. This feature ensures that sensitive or restricted spreadsheets remain confidential and only accessible to authorized team members, enhancing security and compliance.
Feature 9:
View Link History: Access the history of changes made to each Google Sheets link. By tracking modifications, users can quickly retrace steps, understand changes over time, and maintain version control for better project management and accountability.
Getting Started
Installation
Step 1:
Log in to Jira
Ensure you are logged in with Admin privileges.
Step 2:
Open the Atlassian Marketplace
In Jira, click on Apps → Explore more apps to open the Marketplace.
Search for Appvibe Google Sheets Integration
Use the search bar to find the app.
Step 3:
Install the App
Click Get app or Try it free.
Confirm the installation and grant the required permissions.
Step 4:
Configure the App
Once installed, go to Manage Apps in the Admin section to ensure it's enabled.
The panel will now appear in your Jira issue view.
Step 5:
Start Using the App to add and view links for Google Sheets
Open any Jira issue to view, add, or manage Google Sheets links directly.
Working with Links
Add a Link
Step 1:
Inside a Jira issue, click the "Add" button. A form will appear inline, allowing you to enter the necessary details.
Step 2:
Fill in the form with the following details:
- Embedded URL – The link to your Google Sheets design.
- Title – A meaningful name for the design. (optional)
View a Link
Step 1:
Inside a Jira issue, find the link you want to view and click the view icon for that link.
Step 2:
An inline popup will appear showing your Google Sheets. You can also click this for full screen viewing.
Edit a Link
Step 1:
Inside a Jira issue, find the link you want to edit and click "Edit" from the link dropdown. A form will appear inline, allowing you to edit the following:
- Embedded URL: The link to your Google Sheets design.
- Title: A meaningful name for the design. (optional)
Step 2:
Click the save button again to add your Google Sheets link to the Jira issue.
Delete a Link
Step 1:
Inside a Jira issue, locate the link you wish to remove.
Step 2:
Step 3:
You will be prompted to confirm if you want to delete this Google Sheets link.
Advanced
View Link History
Step 1:
Install the Appvibe Google Sheets Integration Jira app to your Jira instance to begin tracking modifications.
Step 2:
Link a Google Sheets document to a Jira issue. Any changes made to this link will automatically be tracked and recorded.
Step 3:
Access the history of modifications either at a specific link level within a Jira issue or at the Jira issue level itself. This provides a detailed and searchable audit trail.
Step 4:
To view the modification history, navigate to the respective Jira issue. The tracked changes will be readily available for review at any time.
Step 5:
Utilize the historical data stored to monitor the progress, collaborate effectively, and maintain accurate records within your Jira environment.
Link Permissions
Step 1:
Go to the Appvibe Google Sheets Integration configuration page, or click permission from within the link settings in a Jira issue.
Step 2:
Select the desired permissions for each user using the following options:
- Viewer: Users with view permission can see the link in the Jira issue.
- Editor: Users with edit permission can add, edit, or remove links in the Jira issue.
- Admin: Users with admin permission can manage link permissions for other users.
Help
FAQ
What if the Google Sheets link doesn’t load?
Ensure the link is public and accessible. If Google Sheets blocks embedding, try opening it in a new tab.
Can I add multiple links to one issue?
Yes, you can add multiple Google Sheets links to each Jira issue.
How secure are my Google Sheets links?
All links and related meta data are stored within Atlassian's Forge platform. Our app data is stored using Forge's hosted storage solutions, which are integrated into Atlassian's cloud infrastructure. This setup ensures that app data benefits from the same data residency features as Atlassian's core products, allowing administrators to control where the data is hosted.
Support
Support and Contact
Overview:
We are committed to providing you with the best experience possible. The Appvibe Google Sheets Integration app allows effortless management and access to your Google Sheets directly within Jira. By seamlessly embedding your sheets, it ensures your team can concentrate on their work without the distraction of switching between different platforms.
Support Contact:
For any additional help, please contact your Jira administrator or visit our Support Page at https://www.appvibe.com/support