Make your personal copy, add your search engine setting, insert your keywords and start monitoring your search rankings. You will find a ready to use spreadsheet here.

Schedule daily runs for the ranking checkerĪfter applying the steps above, you will have a totally free solution to check the rankings of 100 keywords per day.

Store results into a new spreadsheet tab.

If you are searching for a free solution of tracking the SERP results of your most important keywords: Keep on reading! I will describe the full process to set up a monitoring solution build with different Google Cloud Services. Scrape the Google SERPs for your most important keywords for free Just make your copy of the spreadsheet and follow the instructions – then you will have your personal keyword tracker in less than 10 minutes! What you need to do initially is to run daily checks for your keywords and analyze the ranking data over time directly in google sheets or use it as datasource for a more advanced google data studio dashboard. I will show you how easy it is to build and automate your ranking checks with Google App Script and Google CSE. You do not need a paid tool to check your SERP keyword rankings. Schedule it for daily runs and you get a fully automated solution – Totally FREE! Check the SERP Rankings for 100 keywords per day with Google Custom Search Engine + App Script and save the results to Google Sheets.

Google serp check