Access and Export your Phantom Results to CSV, Google Sheets, or Other Tools

This guide explains how to access, download, and use the data generated by your automations. Whether you're exporting to a spreadsheet, integrating with another tool, or chaining automations together, you'll learn where to find your results and what to do with them.

What kinds of results do automations generate

After each run, your Phantom creates result files that contain the data it collected or the actions it completed.

There are two types of result files:

  • CSV File: Combines results from all runs so far (cumulative).
  • JSON File: Includes only the results from the most recent run.

CSV is the most commonly used format, it's great for spreadsheets, reviews, and exports. JSON is useful for detailed data and integrations.

Where to find and download your Phantom results 

You can access your results in two main places:

From the Phantom’s console page

You can always download CSV or JSON results directly from the console page.

  1. Go to your PhantomBuster Dashboard, and click on your Phantom to open the Phantom’s console.
  2. From the Results tab, click the Download results button to get the latest results as a CSV file.
    → If you want to choose the format, click the More dropdown next to the Download results button and select CSV, JSON, or Download all files from this Phantom.

Note: If you're on the Free plan or Free Trial, you'll only be able to download the first 10 rows of results. Advanced export options including access to the More button, the full CSV URL, and the results.json file, are not available.

ex-phantom-results-tab-download-results-&-more.jpeg

From the LinkedIn Leads page (for LinkedIn and Sales Navigator Phantoms)

If you're using LinkedIn or Sales Navigator Phantoms, your results are automatically organized into dynamic Leads lists.

You can access them in two ways:

  • From your workspace:
    → Go to the LinkedIn Leads page and open a saved list or apply filters to view the leads you want and create a new list.
    LinkedIn-leads-page.jpeg

  • From the Phantom console:
    → Go to your PhantomBuster Dashboard, and click on your Phantom to open the Phantom’s console. 
    Open the Leads tab and click View my leads to jump directly to the LinkedIn Leads page, with the filter for that specific Phantom already applied.
    Access leads from LI:SN Phantom console.gif

Once you're viewing your list:

  1. Use filters or select an existing Leads List.

  2. Click Export to download the leads as a CSV file.
    LinkedIn-leads-export-all-leads-option.jpeg

These lead lists are dynamic: when new matching leads are added from compatible Phantoms, they appear automatically if they match the list’s filters.

How to export your data to Google Sheets

Option 1: Manual import to Google Sheets (one-time)

Use this method when you want to upload your results once, ideal for reviewing or sharing a static file.

  1. Download your results file:

    • Go to your PhantomBuster Dashboard, and click on your Phantom to open the Phantom’s console. 

    • Click the Results tab and on Download results to save the CSV file to your computer.
      ex-phantom-results-tab-download-results-csv.jpeg

  2. Open Google Sheets and create a new sheet.

  3. Import the file:

    • In Google Sheets, click File > Import > Upload, and select the CSV file you just downloaded.

    • Choose Replace current sheet, then click Import data.
      Manual import to G-Sheet.gif

    • Your results are now being loaded into the Google Sheet.
      results-csv-g-sheet.jpeg

To get updated data, repeat this process the next time your Phantom runs.

Option 2: Dynamic import using “Importdata” function (auto-updating)

Use this when you want your Google Sheet to stay in sync with your latest Phantom results.

Note: Only paid plans have access to CSV file URLs. Free plan users won’t be able to retrieve the link needed for the "Importdata" function.

  1. Open a new Google Sheets file.
  2. In cell A1, enter the following formula:
    =IMPORTDATA("https://yourcsv.csv")
    Replace this part of the formula "https://yourcsv.csv" with the actual URL of the CSV file you want to import. This will automatically pull data from the specified URL into your Google Sheet, starting from cell A1.
    Example: Importing live data from a LinkedIn Search Export Phantom
    Add csv link to G-sheet formula.gif
  3. To get the CSV URL:
  • If you're using a Phantom that performs one action (like visiting profiles or extracting leads): Go to the Phantom's console, in the Results tab click More, and select Copy link.How to Find, View And Export Phantom Output Data - Copy link.jpeg.png
  • If you're using a Phantom that performs multiple actions in a sequence (like extracting leads and sending messages): Go to the Phantom's console, and click the download iconflow-console-csv-link.jpeg

Google Sheets has size limits for IMPORTDATA. If your file is large, use the manual method instead.

How to use your results in other automations

Use results as input for other Phantoms 

Your exported data can be used as input for other Phantoms, enabling you to automate further actions based on your collected results.
For example:

For more details on how to chain Phantoms, check out our guide on How to Chain Phantoms to Build Automated Sequences.

Integrate with Zapier, Make.com, or API

You can integrate your exported data with other platforms for more extended workflows:

  • Zapier: Create automated workflows to send data from your Phantom to apps like Google Sheets or CRMs.
  • Make.com: Build scenarios to process data automatically.
  • API: Use PhantomBuster’s API for advanced custom integrations.

Special case: LinkedIn Profile Visitor results

If you're using the LinkedIn Profile Visitor Phantom, your CSV file will only include basic profile details, like the name and headline, and just the first two job experiences.

To get full profile data (including complete job history and more fields), you’ll need to switch to JSON-only mode:

  1. During setup, in the Behavior step, open the Advanced behavior settings dropdown menu.

  2. Select Keep only current results in JSON.
    ex-phantom-LI-Profile-Visitor-behavior-JSON.jpeg
    → This ensures each launch returns just the most recent data in the JSON file, with the full profile included.

  3. After launch, download the results as JSON from the Results tab in your Phantom console.

Was this article helpful?

1 out of 2 found this helpful