Step 2: Connect Google Sheets

Create a dedicated spreadsheet for each audit and prepare it for header writing and row appends.

1. Add the Generate Audit Spreadsheet node and set Resource to spreadsheet.
2. Set Title to the expression ={{ $json["Client URL"].trim().split(/›|>|»/)[0].trim().split(".")[0] }}.
3. In Sheets UI, set the sheet title to Blog content audit.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials in Generate Audit Spreadsheet.

Step 3: Set Up Header Preparation

Define the sheet columns and convert them into an array that can be written to Google Sheets.

1. Add the Assign Sheet Columns node and set a string field named rows to Url,Crawled_pages,website_content.
2. Add the Structure Header Array node and keep the provided code that builds data from $json.rows.
3. Connect Assign Sheet Columns → Structure Header Array → Write Headers to Sheet.
4. In Write Headers to Sheet, set URL to =https://sheets.googleapis.com/v4/spreadsheets/{{ $('Generate Audit Spreadsheet').first().json.spreadsheetId }}/values/{{ $('Generate Audit Spreadsheet').first().json.sheets[0].properties.title }}!A:Z.
5. Set Method to PUT and enable Send Body and Send Query.
6. Set body parameter range to ={{ $('Generate Audit Spreadsheet').first().json.sheets[0].properties.title }}!A:Z and values to ={{ $json.data }}.
7. Set query parameter valueInputOption to RAW.
8. Credential Required: Connect your googleSheetsOAuth2Api credentials in Write Headers to Sheet.

Step 4: Set Up the Dumpling Crawl and Scrape Requests

Send the client URL to Dumpling for crawling, derive blog links, then scrape each blog URL.

1. Add Dumpling Crawl Request and set URL to https://app.dumplingai.com/api/v1/crawl with Method POST.
2. Enable Send Body and add body parameters: url = ={{ $('Inbound Form Trigger').item.json["Client URL"] }}, limit = =10.
3. Credential Required: Connect your httpHeaderAuth credentials in Dumpling Crawl Request.
4. Add Derive Blog Links and keep the provided JavaScript to extract blog URLs.
5. Add Dumpling Scrape Request with URL https://app.dumplingai.com/api/v1/scrape and Method POST.
6. Set body parameter url to ={{ $json.blogUrl }}.
7. Credential Required: Connect your httpHeaderAuth credentials in Dumpling Scrape Request.

Step 5: Configure Output to Sheets

Map the scraped results into a row payload and append the data into the generated spreadsheet.

1. Add Map Row Payload and set fields: Url = ={{ $('Inbound Form Trigger').item.json["Client URL"] }}, Crawled_pages = ={{ $('Derive Blog Links').item.json.blogUrl }}, website_content = ={{ $json.content }}.
2. Add Append Rows to Sheets with Operation set to append.
3. Set Sheet Name (ID mode) to ={{ $('Generate Audit Spreadsheet').item.json.sheets[0].properties.sheetId }}.
4. Set Document ID (URL mode) to ={{ $('Generate Audit Spreadsheet').item.json.spreadsheetUrl }}.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Rows to Sheets.

Final Step: Test and Activate Your Workflow

Validate the end-to-end execution and enable the workflow for live use.

1. Click Execute Workflow and submit a test value in Inbound Form Trigger for Client URL.
2. Confirm a new spreadsheet is created by Generate Audit Spreadsheet and headers are written by Write Headers to Sheet.
3. Verify that Dumpling Crawl Request and Dumpling Scrape Request return content and that Append Rows to Sheets appends rows for each blog URL.
4. When successful, toggle the workflow to Active to accept production form submissions.