Before you start, ensure that you have Python installed on your system. You can download it from [python.org](https://www.python.org/). Additionally, install the necessary packages by running the following command in your terminal or command prompt:
```bash
pip install requests gspread oauth2client
```
These packages will help you interact with the PyPI API and Google Sheets API.

Use the Python `requests` library to fetch data from the PyPI API. For example, to get information about a specific package, you can use:
```python
import requests

package_name = "requests" # Replace with your package of interest
response = requests.get(f"https://pypi.org/pypi/{package_name}/json")
package_data = response.json()
```
This will give you a JSON object containing information about the specified package.

Extract and format the data you fetched from PyPI so that it can be easily inserted into Google Sheets. For example:
```python
version = package_data['info']['version']
summary = package_data['info']['summary']
data_to_upload = [["Package Name", "Version", "Summary"], [package_name, version, summary]]
```

Go to the [Google Cloud Console](https://console.cloud.google.com/), create a new project, and enable the Google Sheets API. This step is crucial to allow your script to interact with Google Sheets.

Follow these steps to authenticate:
- In Google Cloud Console, create credentials for a service account.
- Download the JSON key file and save it securely.
- Share the Google Sheet you want to use with the service account email from the JSON key.
- Use the following Python code to authenticate:
```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/your/credentials.json', scope)
client = gspread.authorize(creds)
```

Use the `gspread` library to open your desired Google Sheet by name or URL:
```python
sheet = client.open("Your Google Sheet Name").sheet1 # Opens the first sheet in the workbook
```

Use the `update` method to upload your prepared data to the sheet:
```python
sheet.update("A1", data_to_upload)
```
This command will write your data to the specified range in the Google Sheet, starting from cell A1.

By following these steps, you can efficiently move data from PyPI to Google Sheets using Python without relying on third-party connectors or integrations.