The latest articles on DEV Community by toghani (@toghani). https://dev.to/toghani https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F445659%2F8f817b3c-99df-4b3b-b922-e43a8a91d35f.jpeg https://dev.to/toghani en toghani Fri, 19 Nov 2021 00:15:53 +0000 https://dev.to/toghani/google-rank-tracker-with-python-script-5ac https://dev.to/toghani/google-rank-tracker-with-python-script-5ac <p>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</p> <p>If you want use this script <a href="https://github.com/toghani/Google-keyword-rank-tracker">click here</a> and follow my github tutorial</p> <h2> Installation </h2> <ol> <li>Clone the repository in your local storage (or you can use google colab)</li> <li>Import your keywords in keywords.txt (Each word in a line)</li> <li>Add your website URL in website.txt</li> <li>Enable the API and grab your credentials for <a href="https://github.com/nithinmurali/pygsheets">pygsheets</a>, (Use google sheet in python)</li> <li>Edit 52 and 55 lines in keyword-tracker.py based on the previous step</li> <li>Install robobrowser </li> </ol> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>pip install robobrowser </code></pre> </div> <ol> <li>Install pygsheets </li> </ol> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>pip install pygsheets </code></pre> </div> <ol> <li>Enjoy!</li> </ol> <h3> Enable the API for use pygsheets </h3> <ol> <li> Head over to the <a href="https://console.developers.google.com/">Google API Console</a>.</li> <li> Create a new project by selecting My Project -&gt; + button</li> <li> Search for 'Google Drive API', enable it.</li> <li> Head over to 'Credentials' (sidebar), click 'Create Credentials' -&gt; 'Service Account Key'</li> <li> Select Compute Engine service default, JSON, hit create.</li> <li> Open up the JSON file, <strong>share your spreadsheet with the "<a href="mailto:XXX-compute@developer.gserviceaccount.com">XXX-compute@developer.gserviceaccount.com</a>" email listed.</strong> </li> <li> Save the JSON file wherever you're hosting your project, you'll need to load it in through Python later.</li> </ol> python seo ranktracker google