n8n

How to Automate Gmail Sheets Lead Management?

Turn website form entries into clean, usable leads. Submissions are checked, saved, and shared with your team in seconds. Ideal for marketing teams that need quick lead capture without manual copy and paste.

An n8n hosted form collects Name, Email, and a message. The email goes to Hunter for instant verification. If the address is valid, three actions run at once. A Gmail alert lands in your inbox with the details, a Google Sheet logs Name, Email, Query, and Submitted On, and a Discord webhook posts a rich embed for the team. The If node blocks invalid addresses so fake emails never reach your sheet or inbox. You can keep Discord updates on when volume is high and rely on email for lower traffic.

Setup needs accounts for Gmail, Google Sheets, Discord, and a Hunter API key. Map each field to the correct sheet columns and set the Gmail To address. Expect faster response times, cleaner data, and less inbox noise, since only real contacts pass through. Common uses include contact pages, demo requests, and event signups. Many teams cut manual logging and avoid chasing bad emails, which saves time and improves follow up.

What are the key features?

  • Hosted form collects Name, Email, and a message with a simple link path
  • Hunter email verification screens out invalid or fake addresses before any storage
  • If gate stops the flow when the email is not valid so nothing noisy reaches your tools
  • Gmail sends a plain text alert with the lead details and a clear subject line
  • Google Sheets writes Name, Email, Query, and Submitted On into the selected sheet
  • Discord webhook posts a styled embed so the team gets instant updates
  • NoOp path ensures failed checks end cleanly without side effects

What are the benefits?

  • Reduce manual logging from 60 minutes to 5 minutes per day
  • Automate over 90% of lead routing steps from form to inbox and sheet
  • Validate 100% of emails before saving to improve data quality
  • Handle up to 5 times more submissions without inbox overload by using Discord alerts
  • Connect four systems so your team sees the same lead data everywhere

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets, Gmail, Discord and Hunter. See the Tools Required section above for links to create accounts with these services.
  3. Open the Form Trigger node. Review the form title and fields for Name, Email, and the message. Copy the form URL and decide where you will share or embed it.
  4. Connect Google Sheets: double click the Google Sheets node, then on the 'Credential to connect with' dropdown click 'Create new credential' and follow the on screen instructions to integrate your Google Sheets account using OAuth2.
  5. In the Google Sheets node, select the correct spreadsheet and sheet. Map Name, Email, Query, and Submitted On to the matching columns so each value lands in the right place.
  6. Connect Gmail: open the Gmail node, create a new Gmail OAuth2 credential, and grant access. Set the To address to your work email so you receive new lead alerts.
  7. Set up Discord: in your Discord server, create an incoming webhook and copy the URL. In the Discord node, create a new Discord Webhook credential and paste the webhook URL. Review the embed title and description placeholders.
  8. Connect Hunter: open the Hunter node, click Create new credential, and paste your Hunter API key from the Hunter dashboard API page. Save and test the credential.
  9. Verify the If node condition points to the Hunter result so only valid emails continue. Submit a test with a fake address to confirm the flow stops at No Operation.
  10. Run a full test with a valid email. Check that you receive the Gmail alert, see a new row in Google Sheets, and get a Discord message.
  11. If emails do not arrive, confirm the Gmail To field, check spam, and make sure the workflow is active. If the sheet does not update, verify spreadsheet permissions and the selected sheet.
  12. Activate the workflow. Share the form link on your contact page, demo page, or event signup page to start capturing verified leads.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Discord

Sign up

Free: $0 / mo (no API usage fees; standard rate limits apply)

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Hunter

Sign up

Free plan: $0 / mo, 50 credits / mo, API access included (0.5 credit per email verification)

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.