A package to submit Bulk URLs for Google Indexing using an Excel file
Project description
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.
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.
Installation
To install this package, use pip:
pip install google-bulk-url-indexing
Usage
Command Line
After installing, you can use the package from the command line.
google-bulk-url-indexing
As a Module
You can also use it as a module in your Python code.
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
- Install the Package
pip install google-bulk-url-indexing
- 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.
- Create an Excel file (
- Connect Your JSON File
- Obtain a service account JSON file from Google Cloud Console and provide the complete path to it in your script.
- Run the Code
- Execute the script to start submitting your URLs for indexing.
Project Structure
google-bulk-url-indexing/
indexing/
__init__.py
main.py
setup.py
README.md
Dependencies
google-auth
google-auth-oauthlib
requests
pandas
License
This project is licensed under the MIT License - see the LICENSE file for details.
Author
Around With Us- mscrabe@gmail.com
Acknowledgments
Contributing
If you'd like to contribute, please fork the repository and use a feature branch. Pull requests are welcome.
Issues
If you encounter any issues, please open an issue on the repository.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file google_url_bulk_indexing-1.0.0.tar.gz
.
File metadata
- Download URL: google_url_bulk_indexing-1.0.0.tar.gz
- Upload date:
- Size: 3.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.1 CPython/3.12.1
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6153943a8cbdd7275eca20f3f3c10aa7dc5692aa97f82114a6d0806d29c3e5e4 |
|
MD5 | 6b7c22eef0364f34ca6b2f59a1d8a9ce |
|
BLAKE2b-256 | 3a5aea5c6d8df4f5e3131247f98e0b57d701388372ec00b789f168c87af0a32c |
File details
Details for the file google_url_bulk_indexing-1.0.0-py3-none-any.whl
.
File metadata
- Download URL: google_url_bulk_indexing-1.0.0-py3-none-any.whl
- Upload date:
- Size: 4.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.1 CPython/3.12.1
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3e4c698510da19bb96051620646c48c3b994c5d49ae319ee4c2c87d4f2d7791c |
|
MD5 | cb3227708b8951271b228eb5d724c28c |
|
BLAKE2b-256 | a0332e4c64807481372d60cdddefc544de25e5b40d7407869ed8e12dfd7d336f |