Back to Blog

Automate Portfolio Contact Forms: Log to Google Sheets & Email in 3 Mins

N8nPort
Automate Portfolio Contact Forms: Log to Google Sheets & Email in 3 Mins

This n8n automation, provided by n8nPort, is designed for professionals and businesses using a portfolio website who need to efficiently manage contact form submissions. It automatically captures inquiries, validates them, logs them into a Google Sheet for easy tracking, and sends an immediate, personalized confirmation email via SMTP. This ensures a professional and responsive experience for your visitors while freeing you from manual data entry.

What this automation actually does

This automation efficiently processes contact form submissions from end-to-end, ensuring no lead is missed and communication is instant.

  1. Receives Submissions: The workflow starts by listening for POST requests from your contact form on a dedicated webhook URL.

  2. Validates Input: It checks incoming data for essential fields like name, email, and message, ensuring they meet format and length requirements. Invalid submissions receive an immediate 400 JSON error.

  3. Normalizes Data: Valid submissions are cleaned and standardized: text is trimmed, emails are lowercased, and a timestamp and source are added for consistency.

  4. Logs to Google Sheets: The normalized submission details are then automatically appended as a new row to your specified Google Sheet, complete with columns for Name, Email, Subject, Message, Phone, Timestamp, and Source.

  5. Sends Confirmation Email: A personalized HTML confirmation email is sent to the submitter using your configured SMTP service, acknowledging their message.

  6. Returns Success Response: Finally, the workflow sends a 200 JSON success response back to the contact form, including basic submission details and necessary CORS headers.

What it replaces

This n8nPort automation eliminates the manual, error-prone tasks associated with managing portfolio contact forms, saving you significant time and cost.

| Feature | Manual Process | n8nPort Automation | | :----------- | :-------------------------------------------------------------------------- | :------------------------------------------------------------------------------------------------------------------------ | | Time | Hours per week manually checking inboxes, copy-pasting, sending replies. | Seconds per submission—fully automated from form submission to confirmation. | | Cost | High opportunity cost of your time, potential missed leads. | From $10/month for unlimited runs; dramatically reduces administrative overhead. | | Tools | Email client, spreadsheet software, manual tracking. | n8nPort managed n8n instance, Google Sheets, SMTP service. | | Accuracy | Prone to human error during data entry and email replies. | Consistent, validated data entry and standardized email responses every time. | | Response | Delayed, dependent on when you check and reply. | Instantaneous confirmation email, ensuring professional and timely communication. | | Scalability | Becomes unsustainable with increased submission volume. | Scales effortlessly with n8nPort's unlimited workflow runs, handling any volume without extra effort. |

Why run it on n8nPort

When you choose n8nPort, you're not just getting an automation; you're getting a complete, secure, and hassle-free solution. Every workflow in our catalogue is hand-picked and tested by n8nPort automation editors, meaning you never have to sift through thousands of community templates. This specific workflow installs into your own managed n8n workspace with one click, eliminating complex server setup, Docker configurations, or deployment knowledge. The entire process, from subscribing to activating, takes realistically about 3 minutes. Crucially, n8nPort never asks for your third-party API keys; all your credentials stay securely inside your own private workspace. Furthermore, plans start at an unbeatable $10/month, offering unlimited workflow runs on your own managed instance, so even heavy automation won't be metered per task.

What you need before you start

Before you install this powerful automation, ensure you have the following ready:

  • A Google Sheets account, with a spreadsheet set up containing columns for Name, Email, Subject, Message, Phone, Timestamp, and Source. You will need to grant OAuth2 access.

  • SMTP credentials for sending emails. This includes your SMTP host, port, username, and password, as well as the desired 'From' email address.

  • A contact form on your portfolio website capable of sending POST requests to a webhook URL.

Install it in 3 minutes

Getting this automation up and running on n8nPort is designed for speed and simplicity:

  1. Open your n8nPort dashboard and navigate to your active managed instance.

  2. Your managed n8n workspace will be provisioned and ready. Click to open n8n via secure SSO.

  3. Once inside your n8n interface, go to the "Workflow Templates" section in the left sidebar.

  4. Locate the "Automate Portfolio Contact Forms: Google Sheets & Email" template and click "Install".

  5. Wait a few moments for the workflow to be fully installed into your workspace.

  6. Open the newly installed workflow and click on the Google Sheets and SMTP nodes to add your respective third-party API credentials directly inside your own workspace.

  7. Finally, activate the workflow by toggling the "Active" switch in the top right corner. Your contact form automation is now live!

Tips to get more out of it

  • Custom Thank You Pages: Instead of just a JSON success response, modify the webhook to redirect users to a custom "Thank You" page on your website after a successful submission. This enhances user experience and allows for further tracking.

  • Spam Filtering: Implement basic spam protection by adding a simple text input field (e.g., "What is 2+2?") to your form and a conditional check in n8n. If the answer is incorrect, the workflow can discard the submission or mark it as potential spam in Google Sheets.

  • CRM Integration: Extend the workflow by adding another step to push validated contact form data directly into your CRM system (e.g., HubSpot, Salesforce, Zoho CRM) to centralize lead management.

  • SMS Notifications: For urgent inquiries or high-value leads, integrate an SMS notification service (like Twilio) to send you an instant text message whenever a new form is submitted.

FAQ

Question: What does this n8n automation do?

This n8nPort automation streamlines your portfolio's contact form submissions. It automatically captures incoming messages via a webhook, validates the data, logs it into a Google Sheet for easy tracking, and then sends a personalized confirmation email to the sender. This ensures no lead is missed and provides immediate professional communication.

Question: How does n8nPort handle my API credentials?

n8nPort prioritizes your security. When you install this workflow, you add your third-party API credentials (like Google Sheets OAuth2 and SMTP) directly into your own secure, managed n8n workspace. n8nPort never asks for or stores your credentials, giving you full control and peace of mind.

Question: Can I customize the confirmation email?

Absolutely. Once the workflow is installed in your n8nPort workspace, you have full control to edit the SMTP node. You can customize the 'From' address, subject line, and the entire HTML content of the confirmation email to match your brand and messaging perfectly.

Question: What if I receive a lot of form submissions?

n8nPort plans start at just $10/month and include unlimited workflow runs on your dedicated managed instance. This means your contact form automation will scale effortlessly, processing hundreds or thousands of submissions without additional task-based metering or unexpected costs.

Question: Is this suitable for any website contact form?

This automation is designed for contact forms that can send data via a POST request to a webhook URL. Most modern website builders and custom forms offer this functionality. You'll simply configure your form to point to the unique webhook URL provided by the n8n workflow.

This powerful automation is just one example of how n8nPort empowers you to take control of your workflows. Stop spending valuable time on repetitive tasks and start focusing on what truly matters for your portfolio or business. Visit n8nport.com today to explore our curated template catalogue and launch your first automation in minutes.