Using the Google Sheets IMPORTRANGE function (https://support.google.com/docs/answer/3093340?hl=en), you can display one our of add-on's exports inside of a new tab in your existing spreadsheet. The export itself would still need to be standalone, and would be updated in realtime by our add-on if you chose to configure it that way, but its data could be displayed inside of your existing sheetIf you already have Google Sheets used within your organization to summarize Jira data, you may want to add a realtime update export to one of those sheets. A new export cannot be added directly to a sheet that was not created by the add-on, but Google Sheets provide a way of importing another sheet's data in to your sheet. This functionality can be used to add a realtime update export's data to your sheet. To accomplish this, perform the following steps:
- Create your export. For more information on creating an export, see the Export Issues and Configure Export pages.
- Open your existing spreadsheet.
- Add a new tab to your existing spreadsheet by clicking the + icon in the lower left in Google Sheets.
- In your new tab, use the Google Sheets IMPORTRANGE function to import the data from your export.
That's it! Now when the data in your export changes, the tab in your existing spreadsheet will automatically update to reflect the change.