Track weekly keyword rankings with Google SERP, Serper API, and Google Sheets

This template is designed for SEO specialists, content marketers, and digital growth teams who want to automate the process of tracking keyword rankings.

Manually checking SERPs every week is time-consuming and prone to error. This workflow solves that by automatically querying Google search results with the Serper API, updating rankings in Google Sheets, and keeping historical data for up to 12 weeks.

Prerequisites

Before you begin, make sure you have:

A Google Sheet with columns:

Sr.no (unique row identifier)

Keyword

Target Page (the URL you want to track)