n8n

How to Capture Leads to Google Sheets with Slack Alerts?

Collect newsletter signups, store them in Google Sheets, and alert your team in Slack. After the email is captured, a short multi step survey gathers more details so you can learn about each subscriber and segment them right away.

The flow starts with a form trigger that asks for the email and appends a new row to Google Sheets with the date and a unique execution id. A Slack message notifies your chosen channel immediately. Next, three form pages ask for name, country, role, experience, goals, and beta interest. The same Google Sheets row is then updated using the unique id so all answers stay together. A custom completion screen thanks the user when finished.

You need access to a Google Sheet and a Slack workspace. Make sure your sheet has headers for email, date, execution_id, and the extra profile fields you want to capture. Expect faster lead intake, instant team visibility, and cleaner data for outreach. This setup fits newsletter growth, beta tester lists, and audience research for product teams and marketing teams.

What are the key features?

  • Email capture form with a custom path and required email field
  • Append new rows to Google Sheets with date, email, and a unique execution id
  • Instant Slack notification to a selected channel for each new signup
  • Multi step survey collects name, country, job level, experience, goals, and beta interest
  • Update the same Google Sheets row using the execution id to keep data in one place
  • Custom completion screen thanks the user and confirms the next steps

What are the benefits?

  • Reduce manual data entry from 60 minutes to 5 minutes per 100 signups
  • Streamline lead intake by 80 percent with one flow from form to sheet to Slack
  • Improve data accuracy by 95 percent with required fields and single row updates
  • Handle up to 10 times more signups without extra staff using multi step forms
  • Connect Google Sheets and Slack so teams get instant alerts and can act fast

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 and Slack. See the Tools Required section above for links to create accounts with these services.
  3. Open the node named Capture Email and in the Credential to connect with field click Create new credential for Google Sheets OAuth2. Follow the on screen steps to allow access. Select your spreadsheet and Sheet1. Confirm the headers include date, email, and execution_id.
  4. Open the node named Capture More Info and select the same Google Sheets credential. Pick the same spreadsheet and Sheet1. Map fields like first_name, last_name, country, job_level, experience, goals, and beta_interest to matching column headers. Use execution_id as the key your update relies on.
  5. Open the node named Notify New Signup and click Create new credential for Slack. Authorize your workspace, then choose the channel that should receive alerts. Save the node.
  6. Open the node named Sign Up Form. Confirm the path is newsletter-signup, the email field is required, and the button label is clear. Save changes.
  7. Check the form sequence: Notify New Signup connects to About You, then to Your Interests, then to Join Beta Testers, then to Capture More Info, and finally to Show Completion Screen. Do not break these links.
  8. Prepare your Google Sheet. Add headers for all fields you plan to store such as email, date, execution_id, first_name, last_name, country, job_level, experience, goals, and beta_interest.
  9. Activate the workflow in n8n. Click the Sign Up Form node preview link to open the public form URL in a browser.
  10. Run a test. Submit a test email, confirm a Slack message arrives, check that a new row appears in Google Sheets, complete the survey pages, and verify the same row updates with the extra answers.
  11. Troubleshoot if needed. If Slack does not post, verify the channel and app permission. If the sheet does not update, confirm the execution_id column exists and that header names match the node mappings. If the form does not load, make sure the workflow is active and the path is unique.

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.

Google Sheets

Sign up

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

Slack

Sign up

Free plan: $0 / mo; limited to 10 apps (third-party or custom) and usable via Slack API

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.