The data retrieved from the Autonomous Database is available locally in Google Sheets™ for further analysis. The results are stored in the local copy and cannot be written back to the Autonomous Database. You can run custom SQL queries or query Analytic Views and view their results in the worksheet. The add-on allows you to filter the query results and perform table joins and calculations.

You must select an Analytic View or table to work with to query an analytical view or table from the autonomous database. While retrieving data from the Analytic View, you can configure the query according to your requirements. You can select specific hierarchies and create custom calculations on the wizard. 

The add-on configures your query and returns the result to the Google Sheets™. You can save the results of your queries locally in the Google Sheet™. The add-on can also query the schema directly to which you have access. Using the Web UI, you can view reports and analyses you create in the Data Analysis menu in the Data Studio tool.

You must enable Web Access on the Autonomous Database account to use the add-on. To access the Google Sheets™ add-on, you must have the CONNECT, DWROLE, and RESOURCE roles granted in the SQL worksheet.

Document: https://docs.oracle.com/en/database/oracle/sql-developer-web/sdwad/data-analysis-tool.html#GUID-ECBE4F57-73FB-44E6-BF97-6873E6CE0E57