# Google Url Bulk Indexing
A Python package to submit URLs for Google Indexing using an Excel file. This package allows you to submit up to 200 URLs daily to Google Search Console for indexing, which can significantly benefit your SEO efforts.
## Features
- Authorizes credentials using a service account file.
- Submits URLs for indexing or deletion.
- Reads URLs from an Excel file.
- Allows submission of up to 200 URLs daily. If you need to submit more, you can use multiple JSON keys or request access from Google Cloud Console.
## Benefits
- **Fast Implementation**: Quickly set up and start submitting URLs.
- **Excel Integration**: Easily manage URLs in an Excel file.
- **Increased Limit**: Submit up to 200 URLs daily to Google Search Console.
## How to Make JSON Key
Learn how to create a JSON key for authentication with Google Cloud Console here.
- Click Here (https://mscrabe.com/insights/automated-google-url-indexing-a/)
## Excel Demo Download
Download a demo Excel file (format.xlsx) to get started quickly here.
- Click Here (https://mscrabe.com/static/assets/excel/format.xlsx)
## Installation
To install this package, use pip:
```sh
pip install google-url-bulk-indexing
```
## Usage
### Command Line
After installing, you can use the package from the command line.
```sh
google-url-bulk-indexing
```
### As a Module
You can also use it as a module in your Python code.
```python
from indexing.main import authorize_credentials, submit_url, read_urls_from_excel
# Provide the path to the API key file
API_Path = "path/to/your/service_account.json"
# Provide the path to the Excel file
excel_file_path = "path/to/your/urls.xlsx"
# Authorize credentials
creds = authorize_credentials(API_Path)
# Specify the request type
requestType = "URL_UPDATED" # or "URL_DELETED"
# Read URLs from Excel
urls_to_submit = read_urls_from_excel(excel_file_path)
# Submit each URL for indexing or deletion
for url in urls_to_submit:
response_code = submit_url(creds, url, requestType)
if response_code == 200:
print(f"Successfully submitted: {url}")
else:
print(f"Error submitting {url}. Error Code: {response_code}")
```
## Working Method
1. **Install the Package**
```sh
pip install google-url-bulk-indexing
```
2. **Prepare Your Excel File**
- Create an Excel file (`urls.xlsx`) with the URLs you want to submit, placing each URL in a separate cell in the first column.
3. **Connect Your JSON File**
- Obtain a service account JSON file from Google Cloud Console and provide the complete path to it in your script.
4. **Run the Code**
- Execute the script to start submitting your URLs for indexing.
## Dependencies
- `google-auth`
- `google-auth-oauthlib`
- `requests`
- `pandas`
- `openpyxl`
## License
This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.
## Author
Around With Us- [mscrabe@gmail.com](mailto:mscrabe@gmail.com)
## Acknowledgments
- [Google OAuth2](https://google-auth.readthedocs.io/)
- [Pandas](https://pandas.pydata.org/)
- [Requests](https://docs.python-requests.org/)
- [openpyxl](https://openpyxl.readthedocs.io/)
## Contributing
If you'd like to contribute, please fork the repository and use a feature branch. Pull requests are welcome.
Raw data
{
"_id": null,
"home_page": null,
"name": "google-url-bulk-indexing",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": null,
"keywords": "Website URL Indexing, URL indexing, bulk indexing, Google indexing, Python package, Unlimited Indexing, SEO Tool",
"author": "Around With Us",
"author_email": "mscrabe@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/9c/b4/77e769c9c63d9b64c3f232684a1ad5f9a033274d7542da075cb408ca37c7/google_url_bulk_indexing-1.0.7.tar.gz",
"platform": null,
"description": "\r\n# Google Url Bulk Indexing\r\n\r\nA Python package to submit URLs for Google Indexing using an Excel file. This package allows you to submit up to 200 URLs daily to Google Search Console for indexing, which can significantly benefit your SEO efforts.\r\n\r\n## Features\r\n\r\n- Authorizes credentials using a service account file.\r\n- Submits URLs for indexing or deletion.\r\n- Reads URLs from an Excel file.\r\n- Allows submission of up to 200 URLs daily. If you need to submit more, you can use multiple JSON keys or request access from Google Cloud Console.\r\n\r\n## Benefits\r\n\r\n- **Fast Implementation**: Quickly set up and start submitting URLs.\r\n- **Excel Integration**: Easily manage URLs in an Excel file.\r\n- **Increased Limit**: Submit up to 200 URLs daily to Google Search Console.\r\n\r\n\r\n## How to Make JSON Key\r\n\r\nLearn how to create a JSON key for authentication with Google Cloud Console here.\r\n- Click Here (https://mscrabe.com/insights/automated-google-url-indexing-a/)\r\n\r\n## Excel Demo Download\r\n\r\nDownload a demo Excel file (format.xlsx) to get started quickly here.\r\n- Click Here (https://mscrabe.com/static/assets/excel/format.xlsx)\r\n\r\n\r\n## Installation\r\n\r\nTo install this package, use pip:\r\n\r\n```sh\r\npip install google-url-bulk-indexing\r\n```\r\n\r\n## Usage\r\n\r\n### Command Line\r\n\r\nAfter installing, you can use the package from the command line.\r\n\r\n```sh\r\ngoogle-url-bulk-indexing\r\n```\r\n\r\n### As a Module\r\n\r\nYou can also use it as a module in your Python code.\r\n\r\n```python\r\nfrom indexing.main import authorize_credentials, submit_url, read_urls_from_excel\r\n\r\n# Provide the path to the API key file\r\nAPI_Path = \"path/to/your/service_account.json\"\r\n\r\n# Provide the path to the Excel file\r\nexcel_file_path = \"path/to/your/urls.xlsx\"\r\n\r\n# Authorize credentials\r\ncreds = authorize_credentials(API_Path)\r\n\r\n# Specify the request type\r\nrequestType = \"URL_UPDATED\" # or \"URL_DELETED\"\r\n\r\n# Read URLs from Excel\r\nurls_to_submit = read_urls_from_excel(excel_file_path)\r\n\r\n# Submit each URL for indexing or deletion\r\nfor url in urls_to_submit:\r\n response_code = submit_url(creds, url, requestType)\r\n if response_code == 200:\r\n print(f\"Successfully submitted: {url}\")\r\n else:\r\n print(f\"Error submitting {url}. Error Code: {response_code}\")\r\n\r\n```\r\n\r\n## Working Method\r\n\r\n1. **Install the Package**\r\n ```sh\r\n pip install google-url-bulk-indexing\r\n ```\r\n2. **Prepare Your Excel File**\r\n - Create an Excel file (`urls.xlsx`) with the URLs you want to submit, placing each URL in a separate cell in the first column.\r\n3. **Connect Your JSON File**\r\n - Obtain a service account JSON file from Google Cloud Console and provide the complete path to it in your script.\r\n4. **Run the Code**\r\n - Execute the script to start submitting your URLs for indexing.\r\n\r\n\r\n## Dependencies\r\n\r\n- `google-auth`\r\n- `google-auth-oauthlib`\r\n- `requests`\r\n- `pandas`\r\n- `openpyxl`\r\n\r\n\r\n## License\r\n\r\nThis project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.\r\n\r\n## Author\r\n\r\nAround With Us- [mscrabe@gmail.com](mailto:mscrabe@gmail.com)\r\n\r\n## Acknowledgments\r\n\r\n- [Google OAuth2](https://google-auth.readthedocs.io/)\r\n- [Pandas](https://pandas.pydata.org/)\r\n- [Requests](https://docs.python-requests.org/)\r\n- [openpyxl](https://openpyxl.readthedocs.io/)\r\n\r\n## Contributing\r\n\r\nIf you'd like to contribute, please fork the repository and use a feature branch. Pull requests are welcome.\r\n\r\n",
"bugtrack_url": null,
"license": null,
"summary": "A package to submit Bulk URLs for Google Indexing using an Excel file",
"version": "1.0.7",
"project_urls": null,
"split_keywords": [
"website url indexing",
" url indexing",
" bulk indexing",
" google indexing",
" python package",
" unlimited indexing",
" seo tool"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c5c58dd929a6d0f65cb2849cf677a78a4748cf5f38d865782b52f7f1cfc264ff",
"md5": "f9e039958082ee3c1c256cc1d1e63b06",
"sha256": "8f10967569c247a66d7a6107c254c7132bd0be3b1efa0f6e1ddbddaecabb0486"
},
"downloads": -1,
"filename": "google_url_bulk_indexing-1.0.7-py3-none-any.whl",
"has_sig": false,
"md5_digest": "f9e039958082ee3c1c256cc1d1e63b06",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6",
"size": 4205,
"upload_time": "2024-07-18T13:15:18",
"upload_time_iso_8601": "2024-07-18T13:15:18.121418Z",
"url": "https://files.pythonhosted.org/packages/c5/c5/8dd929a6d0f65cb2849cf677a78a4748cf5f38d865782b52f7f1cfc264ff/google_url_bulk_indexing-1.0.7-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "9cb477e769c9c63d9b64c3f232684a1ad5f9a033274d7542da075cb408ca37c7",
"md5": "cb9cdb1c095d7324da9921ce9cfd1642",
"sha256": "1ef1d5bd97f1e2271ff94b0b301e2159964a28b14a4b95142c07381fca1f1218"
},
"downloads": -1,
"filename": "google_url_bulk_indexing-1.0.7.tar.gz",
"has_sig": false,
"md5_digest": "cb9cdb1c095d7324da9921ce9cfd1642",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 3723,
"upload_time": "2024-07-18T13:15:19",
"upload_time_iso_8601": "2024-07-18T13:15:19.826063Z",
"url": "https://files.pythonhosted.org/packages/9c/b4/77e769c9c63d9b64c3f232684a1ad5f9a033274d7542da075cb408ca37c7/google_url_bulk_indexing-1.0.7.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-07-18 13:15:19",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "google-url-bulk-indexing"
}
JSON