<aside>

Goal:

Transform responses from a Google Form into an AI-generated personalized report, convert it to a PDF, store it in Google Drive, notify the user via email, log the activity, and alert the internal team — all automated via n8n.

Problem:

Manually transforming Google Form entries into clean documents, organizing them, notifying stakeholders, and logging the process was time-consuming and error-prone. Needed a scalable, zero-code solution with AI integration.

Solution:

n8n-based automation that integrates OpenAI, PDF.co, Google Drive, Gmail, and Slack to streamline the process end-to-end.

🔹 Step 1:

Triggered by new entries in a Google Form connected to Google Sheets.

🔹 Step 2:

ChatGPT generates a structured prompt from raw form data.

🔹 Step 3:

Manual node to format/rename the incoming fields as needed.

🔹 Step 4:

ChatGPT returns the final written report using the cleaned prompt.

🔹 Step 5:

Converts Markdown report into styled HTML.

🔹 Step 6:

Edits and prepares HTML data for PDF API conversion.

🔹 Step 7:

Uses PDF.co to convert the HTML report into a PDF.

🔹 Step 8:

n8n's HTTP Request node retrieves the generated PDF.

🔹 Step 9:

The PDF file is uploaded to a Google Drive folder.

🔹 Step 10:

Gmail node sends the PDF to the form submitter.

🔹 Step 11:

Appends a row with the PDF link and timestamp in the Google Sheet.

🔹 Step 12:

Slack message is sent to notify the internal team of the new report.

Tools Used:

• n8n
• Google Forms
• Google Sheets
• ChatGPT (OpenAI)
• PDF.co API
• Google Drive
• Gmail
• Slack

Impact:

• Reduced manual reporting workload by 90%
• Delivered AI-generated reports to users in under 2 minutes
• Created an internal audit trail via Sheets & Slack
• End-to-end system with zero-code scalability

🧠Learnings:

• n8n handles end-to-end multi-app automations better than Make in many cases.
• Using ChatGPT for content generation within a workflow unlocks next-level customization.
• Combining PDF.co with HTML formatting allows for highly professional PDF documents.
• Slack notifications help close the loop internally without checking email or dashboards. </aside>

📂 Download & Explore the Workflow

View GitHub Repository :

Automated-Google-Form-to-PDF-Report-System/Automated Google Form to PDF Report System.json at main · AlvLeoAI/Automated-Google-Form-to-PDF-Report-System