n8n Facebook Lead Management: Automate Email Responses with Gmail & Google Sheets

This n8n workflow automates the process of managing new leads generated through Facebook Lead Ads. It captures lead data, records it in a Google Sheet, and sends a personalized email response via Gmail, with a built-in delay for a more natural interaction.

What it does

This workflow streamlines your lead management by performing the following actions:

1. Triggers on New Facebook Lead: Automatically starts when a new lead is submitted through a configured Facebook Lead Ad.
2. Records Lead Data in Google Sheets: Extracts the lead's information (e.g., name, email) and appends it as a new row in a specified Google Sheet.
3. Introduces a Delay: Pauses the workflow for a set duration (e.g., 5 minutes) to simulate a more natural response time and avoid immediate, robotic replies.
4. Sends Personalized Email via Gmail: Constructs and sends a personalized email to the new lead using Gmail, potentially including information from the lead ad.
5. Loops for Multiple Leads: Processes each lead individually, ensuring every new lead receives the automated response and is recorded.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Facebook Lead Ads Account: An active Facebook account with configured Lead Ads.
• Facebook Lead Ads Credential: An n8n credential configured for your Facebook Lead Ads account.
• Google Sheets Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential configured for your Google Sheets account.
• Gmail Account: A Google account with access to Gmail.
• Gmail Credential: An n8n credential configured for your Gmail account.
• Google Sheet: A pre-existing Google Sheet where lead data will be stored. You'll need to specify the Spreadsheet ID and Sheet Name in the Google Sheets node.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Facebook Lead Ads Credential with the necessary permissions.
   • Set up your Google Sheets Credential with access to the target spreadsheet.
   • Set up your Gmail Credential with permission to send emails.
3. Configure Facebook Lead Ads Trigger (Node: "Facebook Lead Ads Trigger"):
   • Select your Facebook Lead Ads credential.
   • Choose the Facebook Page and the specific Form you want to monitor for new leads.
4. Configure Google Sheets (Node: "Google Sheets"):
   • Select your Google Sheets credential.
   • Set the "Operation" to "Append Row".
   • Enter the "Spreadsheet ID" of your target Google Sheet.
   • Enter the "Sheet Name" within that spreadsheet.
   • Map the incoming Facebook Lead Ads data to the columns in your Google Sheet (e.g., {{ $json.data.full_name }} for a "Name" column, {{ $json.data.email }} for an "Email" column).
5. Configure Wait (Node: "Wait"):
   • Adjust the "Time Amount" and "Time Unit" to your desired delay (e.g., 5 minutes).
6. Configure Gmail (Node: "Gmail"):
   • Select your Gmail credential.
   • Set the "Operation" to "Send an Email".
   • In the "To" field, use an expression to dynamically set the recipient's email address (e.g., {{ $json.email }} if the email is mapped directly from the Google Sheet or Facebook Lead Ads data).
   • Compose your "Subject" and "Body" for the email. You can use expressions to personalize the content with lead data (e.g., Hello {{ $json.full_name }}).
7. Activate the Workflow: Once all configurations are complete, activate the workflow to start processing new Facebook leads automatically.