Skip to main content

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

  1. Install the Package
    pip install google-bulk-url-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.

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

google_url_bulk_indexing-1.0.0.tar.gz (3.4 kB view details)

Uploaded Source

Built Distribution

google_url_bulk_indexing-1.0.0-py3-none-any.whl (4.0 kB view details)

Uploaded Python 3

File details

Details for the file google_url_bulk_indexing-1.0.0.tar.gz.

File metadata

File hashes

Hashes for google_url_bulk_indexing-1.0.0.tar.gz
Algorithm Hash digest
SHA256 6153943a8cbdd7275eca20f3f3c10aa7dc5692aa97f82114a6d0806d29c3e5e4
MD5 6b7c22eef0364f34ca6b2f59a1d8a9ce
BLAKE2b-256 3a5aea5c6d8df4f5e3131247f98e0b57d701388372ec00b789f168c87af0a32c

See more details on using hashes here.

File details

Details for the file google_url_bulk_indexing-1.0.0-py3-none-any.whl.

File metadata

File hashes

Hashes for google_url_bulk_indexing-1.0.0-py3-none-any.whl
Algorithm Hash digest
SHA256 3e4c698510da19bb96051620646c48c3b994c5d49ae319ee4c2c87d4f2d7791c
MD5 cb3227708b8951271b228eb5d724c28c
BLAKE2b-256 a0332e4c64807481372d60cdddefc544de25e5b40d7407869ed8e12dfd7d336f

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page