n8n Workflow: Create Verified User Profiles with Email Validation and PDF Generation (Gmail Delivery)

This n8n workflow streamlines the process of creating verified user profiles by integrating data from Google Sheets, validating email addresses, generating a PDF, and delivering it via Gmail. It's designed to automate a common business process, ensuring data accuracy and efficient communication.

What it does

This workflow automates the following steps:

1. Triggers on Webhook: The workflow starts when it receives data via a webhook, likely containing new user profile information.
2. Retrieves Data from Google Sheets: It fetches additional user data from a specified Google Sheet, enriching the initial profile information.
3. Validates Email Address: An HTTP Request node likely interacts with an external service to validate the provided email address, checking for deliverability and authenticity.
4. Conditional Processing: An "If" node checks the result of the email validation.
   • If Valid: If the email is valid, the workflow proceeds to process the user profile.
   • If Invalid: If the email is invalid, the workflow might take an alternative path (not explicitly shown in the provided JSON, but implied by the "If" node's function), such as logging the error or sending a notification.
5. Edits Fields (Set): A "Set" node is used to transform or add data fields, preparing the information for PDF generation. This could involve formatting names, dates, or combining data points.
6. Generates PDF (Implied): While not explicitly named as a PDF generation node, the "Edit Fields (Set)" node followed by Gmail suggests that the data is prepared for a PDF creation step, which might be handled by a custom script or an external service via another HTTP Request (not fully detailed in the provided JSON).
7. Sends Email via Gmail: Finally, the workflow uses Gmail to send an email. This email likely contains the generated PDF (e.g., a welcome kit, a verified profile document) to the newly processed user.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: Configured with the necessary credentials to read data from your specified spreadsheet.
• Email Validation Service: An API key or access to an external service for email validation (e.g., ZeroBounce, Hunter.io, Mailgun). This would be configured within the "HTTP Request" node.
• Gmail Account: Configured with the necessary credentials to send emails.
• Webhook Endpoint: An application or service that can send data to the n8n webhook URL to trigger the workflow.

Setup/Usage

1. Import the workflow: Download the JSON provided and import it into your n8n instance.
2. Configure Credentials:
   • Google Sheets: Set up your Google Sheets OAuth2 credentials.
   • Gmail: Set up your Gmail OAuth2 credentials.
   • HTTP Request (Email Validation): Configure the HTTP Request node with the API key and endpoint for your chosen email validation service.
3. Configure Nodes:
   • Webhook: Activate the webhook and copy its URL. This is the endpoint your external system will send data to.
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name from which to read user data.
   • HTTP Request: Adjust the URL, headers, and body to match the requirements of your email validation service.
   • If: Ensure the conditions in the "If" node correctly evaluate the email validation response.
   • Edit Fields (Set): Customize the fields to be added or transformed for PDF generation.
   • Gmail: Configure the recipient email address (using data from previous nodes), subject, and body of the email. Attach the generated PDF (the method for PDF generation and attachment needs to be implemented, potentially via a custom code node or another HTTP request to a PDF generation API).
4. Activate the Workflow: Once configured, activate the workflow in n8n.
5. Trigger the Workflow: Send data to the webhook URL from your external application to initiate the user profile creation process.