Bear Brown
← All N8N workflows
Data & databasesConvert To FileGmailGoogle Sheets TriggerHtmlHTTP Request

Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV

Configured with Convert To File, Gmail, Google Sheets Trigger, Html, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗8 nodes · MIT
Workflow preview
TransformConvert to CSV FileConvert To FileTransformExtract all books fromthe pageHtmlTransformSort by priceSortTransformExtract individual bookpriceHtmlMessagingSend CSV via e-mailGmailTriggerTrigger- Watches Fornew URL in SpreadsheetGoogle Sheets TriggerWeb / APIScrape Website Contentwith Dumpling AIHTTP RequestTransformSplit HTML Array intoIndividual BooksSplit Out

Node categories in this workflow

  • Transform
  • Messaging
  • Trigger
  • Web / API

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Convert to CSV FileTransformConvert To FileSee node parameters
Extract all books from the pageTransformHtmlextractHtmlContent
Sort by priceTransformSortSee node parameters
Extract individual book priceTransformHtmlextractHtmlContent
Send CSV via e-mailMessagingGmailSee node parameters
Trigger- Watches For new URL in SpreadsheetTriggerGoogle Sheets TriggerSee node parameters
Scrape Website Content with Dumpling AIWeb / APIHTTP RequestPOST
Split HTML Array into Individual BooksTransformSplit OutSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • gmailOAuth2
  • googleSheetsTriggerOAuth2Api
  • httpBasicAuth
  • httpHeaderAuth

Workflow notes

Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV

Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV

📌 This workflow scrapes book data from a website, turns it into a CSV, saves it, and sends it by email.

🔧 It starts from a Google Sheets trigger, fetches the page using DumplingAI, extracts books, sorts by price, and emails the CSV.

✅ Make sure APIs for Gmail, Sheets & Drive are enabled in Google Cloud. Update the URL in the "Fetch website content" node.

🔁 Trigger to Raw Book HTML

🔁 Trigger to Raw Book HTML

  1. Google Sheets Trigger
    Watches a sheet for new row entries. Once a new URL is added, the workflow starts.

  2. Fetch Website Content (Dumpling AI)
    Makes an HTTP POST request to Dumpling AI to scrape and return the full HTML of the target URL.

  3. Extract All Books
    Uses CSS selectors to isolate the list items (li.row > li) containing book entries.

  4. Split Out Node
    Breaks the array of book HTML blocks into individual items, so each book can be processed separately in the next steps.

📦 Parse, Sort, Export & Email

📦 Parse, Sort, Export & Email

  1. Extract Individual Book Data
    From each book, extract the title (<h3>a title attribute) and price (.price_color content).

  2. Sort by Price
    Organizes the extracted data in descending order using the price field.

  3. Convert to CSV File
    Transforms the sorted JSON data into a downloadable CSV file format.

  4. Send CSV via Gmail
    Automatically sends an email with the CSV file attached to the predefined address.

Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV

Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV

Purpose and structure

This folder contains the Scrape Books from URL with Dumpling AI, Clean HTML, Save to Sheets, Email as CSV workflow. Its executable nodes use convertToFile, gmail, googleSheetsTrigger, html, httpRequest, sort, splitOut. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Trigger- Watches For new URL in Spreadsheet

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/1648_Splitout_Converttofile_Send_Webhook.json MIT; preserve source notices.

More in Data & databases

1/ Add Your credentials1/ Add Your credentials2. Add Beehiiv newsletter subscribers from Gumroad sales