This n8n workflow automates the process of retrieving Google Search Engine Results Pages (SERPs) for specified keywords using the ScrapingRobot API. Designed for SEO professionals and digital marketers, it fetches search rankings, organizes the data, and updates a database with keyword positions, enabling continuous tracking of website and competitor rankings.

The workflow begins with a manual trigger for testing purposes. It pulls a list of keywords from a connected database or a pre-defined set, then makes API requests to ScrapingRobot to fetch search results for each keyword. The JSON response from the API contains organic results, paid ads, and ‘People Also Ask’ data. Each result is split into individual rows, and only entries with non-empty titles are processed further.

The workflow then assigns ranking positions to each organic search result, groups results by search query, and adds a position number (1-10). It updates the rankings into a designated database, providing a structured overview of current keyword positions. Sticky notes embedded in the workflow highlight key steps, such as data retrieval, API posting, and database updates.

Such a workflow is invaluable for SEO monitoring, competitor analysis, and tracking SERP fluctuations over time, all while minimizing manual effort and ensuring data accuracy.