Automated Google Keyword Rank Tracking & Reporting Workflow

This n8n workflow automates the process of tracking keyword rankings on Google and reporting results via email. It begins with a trigger—either manual or scheduled every 24 hours—that initiates fetching keywords and target domains from a Google Sheet. The workflow transforms keywords for URL compatibility, processes each keyword in batches, and uses the BrightData API to scrape Google search result pages. It then parses the HTML to find the rank of the specified domain within the search results. The results, including URL and rank, are appended to a ‘Results’ sheet in Google Sheets. An HTML email template is dynamically generated with the keyword rankings and sent to a designated recipient. This setup enables SEO professionals and marketing teams to automate rank monitoring without manual effort, ensuring timely insights into keyword performance.