To begin, ensure you have an Azure Storage Account where your blob data resides. Confirm your access credentials (Account Name and Key) to interact with the Azure Blob Storage using Azure SDKs or REST APIs.

Install the Azure SDK for Python to access and manage Azure Blob Storage. Use the following command to install the necessary package:
```bash
pip install azure-storage-blob
```
This will allow you to programmatically download data from Azure Blob Storage using Python scripts.

Write a Python script to download data from your blob container. Here is a basic example:
```python
from azure.storage.blob import BlobServiceClient
connect_str = ""
container_name = ""
blob_name = ""
download_file_path = "downloaded_file.csv"
blob_service_client = BlobServiceClient.from_connection_string(connect_str)
blob_client = blob_service_client.get_blob_client(container=container_name, blob=blob_name)
with open(download_file_path, "wb") as download_file:
download_file.write(blob_client.download_blob().readall())
```
Replace placeholders with your respective details to download the blob data to your local machine.

After downloading, ensure your data is in a format compatible with Google Sheets, such as CSV. If necessary, process the data using Python (e.g., with Pandas) to clean or reformat it according to your needs.

Access the Google Cloud Console and enable the Google Sheets API. Create credentials for a service account and download the JSON key file. Share the Google Sheet with the service account email to grant access.

Install the Google API Client Library for Python to interact with Google Sheets:
```bash
pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib
```
Use these libraries to authenticate and access the Google Sheets API.

Create a Python script to upload your data to Google Sheets. Here's a basic example:
```python
import gspread
from oauth2client.service_account import ServiceAccountCredentials
# Use credentials to create a client to interact with the Google Drive API
scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/drive"]
creds = ServiceAccountCredentials.from_json_keyfile_name(".json", scope)
client = gspread.authorize(creds)
# Open the Google Sheet
sheet = client.open("").sheet1
# Read the downloaded CSV file and update the sheet
import csv
with open('downloaded_file.csv', 'r') as file:
reader = csv.reader(file)
for i, row in enumerate(reader):
sheet.insert_row(row, i + 1)
```
Replace placeholders with your details to upload the data to Google Sheets.
By following these steps, you can transfer data from Azure Blob Storage to Google Sheets without using third-party connectors or integrations, relying instead on Python scripts and direct API interactions.