Magic Manager

Connect Web Forms

Route website form submissions directly into Magic Manager in about 10 minutes. 100% free — no paid Zapier tier required.

Watch the walkthrough

Before you start, have these handy

  • ◆
    Copy of Magic Manager (Master Template) — your Google Sheet that runs your Magic Manager app.
  • ◆
    A free Zapier account — sign up at zapier.com (no credit card required).
  • ◆
    Your Gmail account — where your website form notification emails arrive.
1

Create your free Zapier mailbox

  1. Go to parser.zapier.com and log in with your free Zapier account.
  2. Click Create Mailbox.
  3. Copy the generated email address (looks like something@parser.zapier.com) and keep this tab open.
2

Add & verify forwarding in Gmail

  1. In Gmail, open Settings → See all settings → Forwarding and POP/IMAP.
  2. Click Add a forwarding address, paste your Zapier Parser address, and click Next → Proceed → OK.
  3. Switch to your Zapier Parser tab, click View Emails, open the Google verification email, and copy the numeric code.
  4. Return to Gmail's Forwarding tab, paste the code, and click Verify.
  5. Ensure the option "Keep Gmail's copy in the Inbox" is selected.
Safety tip: Keeping Gmail's copy in your inbox ensures your original form emails are always preserved.
3

Filter web lead emails in Gmail

  1. In Gmail's top search bar, click the Show search options icon.
  2. Enter parameters matching your web leads (e.g., set From to your host domain or Subject to Form Submission).
  3. Click Create filter.
  4. Check Forward it to: and select your verified Zapier Parser email address.
  5. Click Create filter.
4

Train the Zapier Parser

  1. Go to your website form and submit a realistic test lead.
  2. Return to parser.zapier.com, click View Emails, and open the new test email.
  3. Highlight lead details (Name, Email, Phone) with your cursor and assign field names (e.g., {{lead_name}}).
  4. Click Save Address and Template.
5

Connect Zapier to Magic Manager

  1. In Zapier, click Create Zap.
  2. Trigger: Choose Email Parser by Zapier → Event: New Email → Select your parser mailbox.
  3. Action: Choose Google Sheets → Event: Create Spreadsheet Row.
  4. Select your Google Drive and pick your spreadsheet file: Copy of Magic Manager (Master Template).
  5. Map the parsed fields (Name, Email, Phone) to their corresponding spreadsheet columns.
  6. Test the step and turn your Zap ON.

You're automated! ☊

When a prospect fills out your website form, their details now flow through Zapier directly into Magic Manager—100% automatically without any copy-pasting.

Quick fixes

Leads are not showing up in the parser mailbox.
Check your Gmail filter settings. Ensure the "From" address or subject line matches the exact notification email sent by your website builder.
Zapier asks for a paid plan upgrade.
Zapier's free plan allows single-step Zaps (1 Trigger + 1 Action). Ensure you only have 2 steps total in your Zap (Email Parser → Google Sheets).
Data isn't populating the right columns in Magic Manager.
In Zapier under your Action step, re-check your field mapping to ensure each parsed tag aligns with the correct column name in Copy of Magic Manager (Master Template).
Need a hand? Reply to your purchase receipt and we'll get you sorted.