Audit website lead capture and email reports with Groq, Gmail and Sheets

Quick overview

This workflow collects a website URL via an n8n form, checks the page for lead-capture signals, uses Groq to generate a short audit summary, then logs the request to Google Sheets and emails a scored HTML report to the visitor and an alert to you via Gmail.

How it works

1. Receives an audit request from an n8n form submission with the visitor’s name, email, business name, and website.
2. Normalizes the inputs (including adding https:// when missing) and fetches the website HTML via an HTTP request.
3. Runs rule-based checks on the page to detect lead-capture elements (WhatsApp, booking, tap-to-call, contact form, live chat, opening hours, response-time promise, and mobile readiness) and calculates a weighted score out of 100.
4. If the page is readable, sends the check results and a text excerpt to Groq to generate a JSON audit summary with strengths, top fixes, and a quick win, then composes a branded HTML report.
5. If the page cannot be read or is unreachable, builds a “could not audit” email and marks the request for manual review or unreachable status.
6. Appends the audit outcome to an Audits tab in Google Sheets and emails the visitor their report and you an owner alert via Gmail.

Setup

1. Create a Groq API key and connect it in the Groq chat model used to write the audit summary.
2. Connect a Gmail account for sending the visitor report and the owner alert.
3. Connect Google Sheets, set the target spreadsheet document ID, and ensure a sheet tab named Audits exists with the expected columns.
4. Open the configuration step and replace the placeholders for your agency name, owner alert email, and booking link (and optionally update the CTA text and minimum readable character threshold).
5. Activate the workflow and publish or embed the n8n form, then share the form URL on your website.