Log in to your Google Search Console account using your Google credentials. Ensure you have the necessary permissions to access the property from which you want to export data. Navigate to the desired property and select the "Performance" report from the left-hand menu.

Customize the performance report by selecting the desired date range, search type (e.g., Web, Image, or Video), and any other filters or dimensions (such as queries, pages, countries, devices, etc.) that are relevant to the data you wish to export.

Once you have customized your data view, click on the "EXPORT" button located in the top-right corner of the performance report. Choose the "Google Sheets" option from the dropdown menu. This action will automatically create a new Google Sheet with your selected data.

After the export is complete, a new Google Sheet will open automatically in a new tab. The exported data will be organized into columns according to the dimensions and metrics you selected in the Search Console performance report.

Review the data in the Google Sheet to ensure it is complete and formatted to your preference. You may want to adjust column widths, apply filters, or use conditional formatting to make the data easier to analyze and interpret.

Use Google Sheets' built-in functions and tools to analyze the data. You can create pivot tables, charts, and graphs to visualize trends, calculate metrics like averages or growth rates, and derive insights from the data.

To streamline future data updates, you can create a script using Google Apps Script to automate the export and refresh process. This requires some knowledge of scripting and the Google Sheets API. Write a script that periodically clears the existing data and imports updated data from Google Search Console into your Google Sheet.

By following these steps, you can effectively move data from Google Search Console to Google Sheets manually, allowing for further analysis and reporting without relying on third-party tools.