Quick overview
Youtube Video: https://youtu.be/Zi872Mz4GnE?si=5yhYcMMH633Sqdd9
This workflow captures medical equipment enquiries via an n8n form, stores or updates each submission in Google Sheets, flags low-quality leads based on free email domains, and routes qualified enquiries to the right Slack channel depending on the stated purchase timeline.
How it works
- Receives a submission from an n8n form collecting company, contact, and equipment interest details.
- Appends or updates the enquiry in Google Sheets, matching on the Work Email Address.
- Checks whether the email domain is a free provider (for example, gmail.com or outlook.com) and posts a “Low Quality Lead” alert to Slack when it is.
- For non-free domains, looks up the matching row in Google Sheets and continues only when a record is found.
- Routes qualified enquiries based on Purchase Timeline, sending “Immediate Need” submissions to a dedicated Slack channel and “Budgeting for Next Fiscal Year” submissions to a follow-up campaign Slack channel.
Setup
- Set up the n8n Form Trigger and publish the form so users can submit enquiries.
- Add a Google Sheets Service Account credential, share the target spreadsheet with the service account email, and confirm the document ID and sheet tab are correct.
- Add a Slack credential and set the destination channels for low-quality alerts, immediate action, and follow-up campaign messages.
- Update the list of free email domains if you want stricter or broader lead-quality filtering.