How to integrate Rovo Agents with Google Sheets for data analysis and actions?

[Juan Carlos Romero]

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:

1. Index Content: Have Rovo index specific Google Sheets so the Agent can reference that data when answering questions in Rovo Chat.

2. 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?").

3. 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?

[Rebekka Heilmann _viadee_ · Accepted solution]

Hi @Juan Carlos Romero - welcome to the Community,

1. Yes. The Google Drive Connector will index Google Sheets as well. See Connect Google Drive to Rovo | Atlassian Support for details
2. I just tried to Upload an Excel file directly to chat and I get an analysis and could get fancy charts if I wanted to. I'd expect it to work with Google Sheets as well. Assuming that if you provide a direct link to the file, it works too. We don't have Sharepoint or Drive connected yet so cannot test it.
3. There is no Google Sheets skill yet. You could create your own skill via Forge and make use of any available Google Sheets APIs. See Rovo agent skills | Rovo | Atlassian Support for more info on skills. If you are planning to use a Rovo Agent in an Automation, you could take the Agent response and call the API yourself via an Automation action. We expect to see more and more skills over the next few months but there is no roadmap for those.

[Juan Carlos Romero]

Great, thanks so much for sharing it, I will try both. the drive connector and Forge.

Regards.