Website Blog Content Scraper and Google Sheets Auditor - n8n Workflow

SEO Specialists and Content Strategists needing fast competitive analysis.
Digital Marketing Agencies performing content audits for clients.
Technical users looking for powerful web scraping n8n templates.
Automation Consultants seeking advanced examples of combining AI APIs with Google Sheets operations in n8n.

Performing a comprehensive blog content audit manually is tedious and time-consuming. This specialized n8n workflow solves this by providing a hands-free solution. It starts with a simple web form to input the target URL, then dynamically creates a dedicated Google Sheet for the audit. The core of this n8n workflow utilizes the Dumpling AI service to deep-crawl the site. Crucially, a custom Code n8n node intelligently filters the massive list of found links, isolating only potential blog posts, articles, or news items. This efficiency ensures that the subsequent scraping actions focus only on valuable content. Finally, all the extracted website content is systematically appended to the Google Sheet. This reusable n8n templates streamlines technical SEO and content planning, demonstrating the power of integrating specialized AI tools within an n8n automation framework. Every step, from the initial n8n trigger to the final data save, is optimized for maximum performance.

This automation starts when the Form Submission n8n trigger is activated by a user providing a target client URL.

1. Sheet Initialization: The workflow immediately uses the Google Sheets n8n node to create a new spreadsheet named after the client's domain and initializes a sheet called 'Blog content audit'.


2. Header Setup: A Set n8n node defines the column headers (Url, Crawledpages, websitecontent). These headers are formatted by a subsequent Code n8n node and inserted into the sheet using an HTTP Request n8n node connecting directly to the Google Sheets API.


3. Website Crawling: The Dumpling AI: Crawl Website n8n node is called, using the provided client URL to perform a comprehensive site crawl.


4. URL Filtering: The pivotal Extract Blog URLs Code n8n node processes the crawl results. This advanced custom n8n node uses complex regular expressions to identify and filter only URLs that likely correspond to blog posts, filtering out images, shopping carts, and administrative pages.


5. Content Scraping: The workflow iterates over the list of filtered blog URLs. For each URL, the Dumpling AI: Scrape Blog Pages n8n node executes a targeted scrape to extract the full text content of that specific page.


6. Data Structuring and Saving: A Set n8n node prepares the output data (original URL, scraped page URL, and the content text). Finally, the Save Blog Data to Google Sheets n8n node appends this structured data as a new row in the audit spreadsheet. This complete n8n workflow ensures a seamless transition from input to structured analysis.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided JSON code and import it into your n8n instance as a new workflow.


2. Google Sheets Credentials: Update the Create Blog Audit Sheet and Save Blog Data to Google Sheets n8n node configurations to use your Google Sheets OAuth2 API credentials.


3. Dumpling AI Credentials: Configure the HTTP Header Authentication credentials used by the Dumpling AI: Crawl Website and Dumpling AI: Scrape Blog Pages n8n node. This typically requires an API key provided by Dumpling AI.


4. Activate Trigger: Navigate to the Form Submission n8n trigger node. Copy the generated Webhook URL and share it, or use the 'Execute Workflow' button to test the n8n templates by inputting a target URL.


5. Execution: Save the n8n workflow and toggle the status to 'Active'.

This n8n workflow leverages several powerful nodes:

Form Submission (n8n trigger): The starting point for the automation. It captures the essential input—the Client URL—to initiate the entire content audit process.
Google Sheets (Create Blog Audit Sheet): Creates the required destination spreadsheet dynamically. Key Configuration: Spreadsheet title is dynamically set using an expression based on the client URL.
Set Sheet Headers (n8n node): A utility node used to define the required column names (Url, Crawledpages, websitecontent) before they are written to Google Sheets.
Code (Extract Blog URLs): A critical custom n8n node that applies regex filtering to the raw crawl data from Dumpling AI. It ensures that only links containing patterns like /blog/, /article/, or date structures are retained for scraping, significantly improving the quality of the n8n workflow output.
HTTP Request (Dumpling AI: Crawl Website & Scrape Blog Pages): These n8n nodes handle the core interaction with the external AI service, making specialized web scraping requests. Key Configuration: Uses HTTP Header Auth for API access and passes the dynamically extracted URLs as parameters.
Google Sheets (Save Blog Data to Google Sheets): This final n8n node appends the fully structured blog content and metadata to the designated audit sheet in Google Drive, finalizing the data collection process established by this n8n templates.