Start by installing and configuring the AWS Command Line Interface (CLI) on your local machine. You can download it from the AWS website and configure it with your access keys using the command `aws configure`. For Google Sheets, enable the Google Sheets API and download your credentials JSON file from the Google Cloud Console. This file will be needed for authentication in your script.

Use the AWS CLI or SDK to scan your DynamoDB table and export the data to a local JSON or CSV file. For example, using the CLI, you can run:
```
aws dynamodb scan --table-name YourTableName --output json > dynamodb_data.json
```
This command retrieves all items from the specified table and saves them to `dynamodb_data.json`.

If you plan to use Python, install necessary libraries such as `boto3` for AWS and `gspread` for Google Sheets. You can do this using pip:
```
pip install boto3 gspread oauth2client pandas
```
These libraries will help in accessing AWS services and interacting with Google Sheets.

Open your exported file and process the data as needed. You can use Python with pandas to load the JSON or CSV file, transform the data, and ensure it is in the correct format for Google Sheets. Here�s a short example of how you might load and process the data:
```python
import pandas as pd

data = pd.read_json('dynamodb_data.json')
# Perform any necessary data cleaning or transformation
cleaned_data = data.drop(['UnnecessaryColumn'], axis=1)
```

Use the `gspread` library to authenticate and access your Google Sheets. Load the credentials JSON file obtained earlier and authorize:
```python
import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/drive"]
creds = ServiceAccountCredentials.from_json_keyfile_name('path_to_credentials.json', scope)
client = gspread.authorize(creds)
```

Use the authenticated client to create a new Google Sheet or open an existing one by title. For example:
```python
sheet = client.create('DynamoDB Export') # Creates a new sheet
# Or open an existing sheet
sheet = client.open('ExistingSheetName')
worksheet = sheet.get_worksheet(0) # Access the first sheet
```

Use the `gspread` library to upload your processed data to the Google Sheet. Here�s how you might do it:
```python
import gspread_dataframe as gd

# Convert the cleaned data to a DataFrame and update the worksheet
gd.set_with_dataframe(worksheet, cleaned_data)
```
This uploads the data from your DataFrame to the specified worksheet in Google Sheets.

By following these steps, you can successfully transfer data from DynamoDB to Google Sheets without relying on third-party connectors or integrations. Ensure you manage your API credentials securely and adhere to best practices for data handling and privacy.