Crawl Website Blogs & Save to Google Sheets with Dumpling AI

This n8n workflow streamlines content auditing by starting with a form submission of a client website URL. It automatically creates a dedicated Google Sheet titled based on the URL, adds essential headers like 'Url', 'Crawled_pages', and 'website_content', and prepares the sheet for data ingestion.

Next, it leverages Dumpling AI via HTTP requests to crawl the entire website, intelligently discovering all pages while filtering specifically for blog-related URLs. This avoids irrelevant pages like homepages or contact forms, focusing only on valuable article content.

For each identified blog post, the workflow scrapes the full article content and structures the results. Data is then appended row-by-row to the Google Sheet, enabling quick analysis for SEO strategies, content gaps, or competitor audits. Ideal for content strategists, SEO specialists, marketing agencies, and VAs saving hours on manual scraping.

Benefits include error-free automation, scalability for multiple sites, and no coding required. Use cases: Audit client blogs for keyword research, track content freshness, or build competitive intelligence sheets in Health & Fitness niches or beyond.