Automated Webpage Conversion Audit Report Generation and Google Docs Storage - n8n Workflow

SEO Agencies and Consultants who need scalable reporting.
Digital Marketing Teams automating competitive analysis.
Users looking for advanced examples of external API integration within an n8n workflow.
Anyone seeking efficient, automated documentation for technical audits using n8n templates.

Manually running detailed webpage audits, synthesizing the results, and saving them to a centralized, shared location like Google Docs is time-consuming. This specialized n8n workflow solves this problem by creating an end-to-end automation pipeline. It starts with a simple form submission, utilizes an external AI analysis API (Landing Page Analyzer) to grade the URL's conversion potential, and critically, uses a custom code n8n node to reformat the raw API data into a highly readable professional report structure. The final step of the n8n workflow ensures the formatted audit is immediately accessible in Google Docs, eliminating manual copy-pasting and ensuring proper record-keeping. This robust n8n automation template is crucial for scaling audit operations.

This efficient n8n workflow begins with an explicit n8n trigger to capture the necessary input.

1. Input Capture (On form submission n8n trigger): The automation is initiated when a user submits a URL via the n8n Form Trigger. This captures the target URL for analysis.


2. API Analysis (WebPage Analyzer): The captured URL is passed to an external Landing Page Analyzer AI via an HTTP Request n8n node. This API returns a detailed JSON object containing scores, grades, specific strengths, and actionable suggestions for improvement.


3. Data Structuring (Reformat Code n8n node): The raw JSON output is complex. A crucial Code n8n node transforms this data into a professional, human-readable markdown text report structure (including detailed bullet points for Suggestions, Strengths, and Conversion Scores). This ensures the final output is clean.


4. Report Generation (Upload In Google Docs): The finalized, formatted audit report text is sent to the Google Docs n8n node, which inserts the content into a pre-specified document, completing the automated reporting cycle. This entire process demonstrates the power of a customized n8n workflow.

To deploy this n8n workflow template successfully, follow these steps:

1. Import the JSON: Copy the provided n8n workflow JSON and paste it into your n8n instance using the 'New' -> 'Import from JSON' function.


2. Configure Credentials:

1. Set Google Doc Target: In the 'Upload In Google Docs' n8n node, specify the URL of the Google Document you wish to append the audit reports to.


2. Activate the n8n trigger: Save the n8n workflow and activate the 'On form submission' n8n trigger to enable the public webhook URL for data submission.

On form submission (n8n trigger):
Function: Serves as the starting point, capturing the single required input: the webpage URL.
Key Configuration: Configured to accept a required field named url.
WebPage Analyzer (HTTP Request n8n node):
Function: Executes the API call to the external Landing Page Analyzer service via RapidAPI.
Key Configuration: Uses a POST method, sets Content-Type to multipart-form-data, and dynamically injects the captured url into the body parameters using an expression: ={{ $json.url }}.
Reformat (Code n8n node):
Function: The central logic component that processes the complex JSON response, structures it with markdown headers, lists, and bolding, and compiles it into a single output field named docText.
Key Configuration: Contains custom JavaScript functions (formatSuggestions, formatStrengths, formatScores) to ensure data is clean and professionally presented before being passed to the next n8n node.
Upload In Google Docs (Google Docs n8n node):
Function: Inserts the highly structured docText report into a designated Google Document for permanent storage.
Key Configuration: Operation set to update (implied insertion/appending) and uses Service Account authentication to authorize the write operation. The text input is defined by the expression: ={{ $json.docText }}.