I’m currently exploring Atlassian Rovo and want to understand the best way to leverage Google Sheets data within my custom Agents. Specifically, I am looking to:
Index Content: Have Rovo index specific Google Sheets so the Agent can reference that data when answering questions in Rovo Chat.
Data Analysis: Use an Agent to analyze trends or summaries directly from a spreadsheet (e.g., "What is the average volatility in our 'Delivery Excellence' sheet?").
Bi-directional Workflow: Is it possible for a Rovo Agent to write or update a row in a Google Sheet based on a chat interaction, similar to how it works with Jira tickets?
I have already enabled the Google Drive Connector in the Atlassian Admin Center. Does this automatically cover Sheets, or do I need to set up a specific Forge action or external API connection to allow the Agent to interact with the data more dynamically?
