This script finds the rank of your keywords and automatically imports it in your Google Sheet! All you have to do is enter the keywords in keywords.txt and the website url in website.txt then run the script, that's it! See the ranking of your words in Google Sheet
If you want use this script click here and follow my github tutorial
Installation
- Clone the repository in your local storage (or you can use google colab)
- Import your keywords in keywords.txt (Each word in a line)
- Add your website URL in website.txt
- Enable the API and grab your credentials for pygsheets, (Use google sheet in python)
- Edit 52 and 55 lines in keyword-tracker.py based on the previous step
- Install robobrowser
pip install robobrowser
- Install pygsheets
pip install pygsheets
- Enjoy!
Enable the API for use pygsheets
- Head over to the Google API Console.
- Create a new project by selecting My Project -> + button
- Search for 'Google Drive API', enable it.
- Head over to 'Credentials' (sidebar), click 'Create Credentials' -> 'Service Account Key'
- Select Compute Engine service default, JSON, hit create.
- Open up the JSON file, share your spreadsheet with the "XXX-compute@developer.gserviceaccount.com" email listed.
- Save the JSON file wherever you're hosting your project, you'll need to load it in through Python later.
Top comments (1)
If someone is looking for a free google position checker tool, in our opinion serposcope will be much more convenient to use.