How to Send Phantom Results to HubSpot, Email, and Google Sheets with a Zapier "New Output" Zap

Sophie
Sophie This badge shows you’re hearing straight from the source! Team members are here to share insider tips, answer questions, and guide you through PhantomBuster with expert knowledge. They’re dedicated to helping you succeed and making sure your automation journey feels easy and exciting. PhantomBuster Official
  • Updated

To act on your Phantom's results automatically, build a Zap that starts with the PhantomBuster New Output trigger - it fires whenever your Phantom finishes - then add action steps for each thing you want to happen. In this example, each new lead is created as a HubSpot contact, emailed via Gmail, and added as a row in Google Sheets. You can keep, drop, or swap any of those action steps for the apps you use.

Before you start

  • You've connected PhantomBuster to Zapier. If not, see How to Connect PhantomBuster with Zapier.
  • The Phantom is set up and has run at least once, so it has output for Zapier to read.
  • You have connected accounts in Zapier for each destination you'll use (here: HubSpot, Gmail, Google Sheets), and a Google Sheet ready to receive rows.
full Zap overview: 1. New Output → 2. Create Contact (HubSpot) → 3. Send Email (Gmail) → 4. Create Multiple Spreadsheet Rows (Google Sheets)

Step 1: Set the trigger to "New Output"

  1. Create a new Zap. For the trigger app, choose PhantomBuster and the New Output event ("Triggers when a specific Phantom finishes"). Confirm your connected account.
    trigger step with PhantomBuster and the New Output event selected
  2. In Configure, select the Phantom whose results should start the Zap, then test the trigger to pull in a sample result.
    New Output configure step with the Phantom selected

Step 2: Create the contact in HubSpot

  1. Add an action step, choose HubSpot, and select the Create Contact event.
    HubSpot action step with Create Contact selected
  2. In Configure, map the Phantom's output fields to the HubSpot contact properties you want - for example, map City to the Phantom's Result Object Location, and similarly for name, email, company, etc.
    Create Contact configure step mapping Result Object fields to HubSpot properties
  3. After the Zap runs, the lead appears in your HubSpot Contacts.
    HubSpot Contacts list showing the created contact

Step 3: Email the lead with Gmail

  1. Add a Gmail → Send Email action.
  2. In the To field, insert the lead's email from the trigger data, the Phantom's Result Object Professional Email, then fill in the subject and body.
Gmail Send Email step with the To field mapped to the scraped email

Step 4: Add the lead to Google Sheets

  1. Add a Google Sheets → Create Multiple Spreadsheet Rows action.
    Google Sheets action step with Create Multiple Spreadsheet Rows selected
  2. Choose your spreadsheet and Worksheet, then map each column. Name → Result Object First Name, Last Name → Result Object Last Name, LinkedIn URL → Result Object Profile Url.
    configure step mapping Result Object fields to sheet columns
  3. After the Zap runs, each lead is added as a new row.
    Google Sheet showing the new lead row

Step 5: Test and publish

Run a test to confirm each step works, then Publish the Zap. From now on, every time your Phantom produces new output, the contact is created, the email is sent, and a row is added in your sheet.

Troubleshooting

  • The Zap doesn't fire: confirm the Phantom actually finished and produced output; the New Output trigger only fires on a completed run.
  • A field comes through empty: the mapped field may not exist for that lead. Re-check the mapping against the trigger's sample data.
  • HubSpot contact isn't created: on free HubSpot plans, contact limits can block new records - check your HubSpot plan limits.
  • Wrong data lands in a column: open the action's Configure step and confirm each column maps to the intended Result Object field.

Frequently asked questions

How do I send PhantomBuster results to HubSpot automatically?

Build a Zap with the PhantomBuster New Output trigger, add a HubSpot → Create Contact action, and map the Phantom's output fields to the contact properties.

What does the "New Output" trigger do?

It fires whenever a specific Phantom finishes a run, passing that run's results into your Zap.

Can I send results to more than one app at once?

Yes. Add as many action steps as you like after the trigger. For example: HubSpot, Gmail, and Google Sheets in a single Zap.

Can I swap Google Sheets or HubSpot for another tool?

Yes. The trigger stays the same; just add the action steps for whichever apps you use.

Was this article helpful?

0 out of 0 found this helpful