We’re excited to announce that the Oracle Autonomous AI Lakehouse add-in for Google Sheets is now available on the Google Workspace Marketplace! With this powerful new integration, you can access, query, and analyze your Oracle AI Lakehouse data—all from within the familiar interface of Google Sheets.

Seamless Setup in Minutes

Getting started is easy. Here’s how you can begin:

  1. Start with a Blank Sheet: Open Google Sheets and create a new spreadsheet.
  2. Install the Add-in:
    • Navigate to Extensions > Add-ons > Get add-ons.
  3. Search for Oracle Autonomous Database.
  4. Search for the add-on
  5. Click on the listing to review its features and required permissions.
  6. Review the permissions
  7. Once ready, click Install, select your Google account, and confirm the permissions.
  8. Connect to Your Autonomous Database:
    • Log in to Oracle Database Actions in your browser.
  9. Under Downloads, select the option to download the Google Sheets add-in connection file.
  10. Download the connections file
  11. Back in Google Sheets, go to the Oracle Autonomous AI Lakehouse add-in under Extensions.
  12. Select Import Connection and upload the connection file you downloaded.
  13. Choose your schema and click Import.
  14. You’ll see a green check mark once you’re successfully connected.
  15. Successful connection

Unlock Powerful Analytics

With the Oracle Autonomous AI LakehouseGoogle Sheets add-in, you can:

  • Query Data Instantly: Run direct SQL queries and see your database results right in your spreadsheet.
  • Run Direct SQL
  • Use Natural Language Query for Analysis: Leverage AI-powered features to analyze data conversationally.
  • Natural Language to SQL generation
  • AI Chat: Have conversation with your data
    Have conversation with your Data

     

  • Browse Tables and Data: Quickly view tables, schema details, and hyperlinks for easy navigation.
  • Visualize data as Pivot tables
  • Use Table Hyperlinks to view data
    Use Table Hyperlinks

     

  • No Extra Installations: Securely connect using your credentials—no need for client software or wallet downloads.

Why This Matters?

This integration brings the power and security of Oracle Autonomous AI Lakehouse to the collaboration and simplicity of Google Sheets. Now, anyone in your organization can harness enterprise-grade data and analytics tools—without leaving their spreadsheet.

Get Started Today!

Ready to try it out?

Unlock new possibilities by combining Oracle data and Google Sheets’ collaborative analytics. We can’t wait to see what you’ll accomplish!