To send PhantomBuster data to a spreadsheet using n8n, add a PhantomBuster node to your n8n workflow, select "Get the output of an agent" to fetch your Phantom's latest results, then connect a Google Sheets node with "Append Row" to map each output field to your spreadsheet columns. This automates lead collection and campaign tracking without manual downloads or copy-pasting.
Before you start
Make sure the Phantom you want to pull data from has already been created and run in your PhantomBuster workspace.
In this guide, you'll use n8n to fetch output from an existing Phantom and send that data into a spreadsheet. You won't set up or launch the Phantom from within n8n, you'll only retrieve results that already exist.
Step 1: Open or create a new workflow in n8n
- Open n8n and log into your account.
- From your dashboard, open an existing workflow or click New Workflow to start from scratch.
Step 2: Add the PhantomBuster node
- Click the plus (+) icon, and in the search bar, type PhantomBuster and select it from the list.
Step 3: Choose the “Get the output of an agent” action
In the Action dropdown of the PhantomBuster node, you'll see a list of available actions:
- Delete an agent
- Get an agent
- Get many agents
- Get the output of an agent
- Add an agent to the launch queue
For our example, we'll select Get the output of an agent, this is the action that retrieves results from a Phantom that has already run.
In PhantomBuster’s API, “agent” means Phantom. So when you see “agent” in n8n, it refers to a Phantom you’ve created in your PhantomBuster workspace.
Step 4: Select your Phantom and execute the step
- Use the Agent Name or ID dropdown to select the Phantom. For our example, we'll select a LinkedIn Profile Scraper Phantom.
→ This list will include all Phantoms that are already set up in your PhantomBuster workspace. - Once selected, click Execute step to fetch the most recent output from that Phantom.
→ You’ll see the output displayed in the Execution pane: this is the data you’ll send to your spreadsheet in the next step.
Step 5: Add and configure Google Sheets node
Now that you've retrieved your PhantomBuster data, it’s time to send that data into a Google Sheet.
- Click the plus (+) icon to add a new node to your workflow, and search for Google Sheets.
- Select the Append Row action.
→ This lets you send new data into an existing spreadsheet. - If you haven’t already connected your Google account in n8n, you’ll be prompted to do so here.
-
Before continuing, make sure your Google Sheet is already created and includes the appropriate column headers (e.g., First Name, Last Name, Company, LinkedIn URL, etc.).
Your Google Sheet must be accessible to the Google account you've connected in n8n. It doesn't need to be public, but make sure it's either owned by that account or shared with it directly.
Once connected:
- Under Document, select the name of your Google Sheets file.
- Under Sheet, choose where you want to send your data.
- Set the Mapping Mode to Manual so you can decide exactly what data goes into each column.
- Manually map each field from the PhantomBuster output to the corresponding column in your sheet.
Step 6: Run the step and check your results
- Once you’ve finished mapping your fields, click Execute step.
- If everything is set up correctly, the data from your PhantomBuster output will appear as new rows in your selected Google Sheet.
To run the full workflow from start to finish, click Execute Workflow at the top. Check your spreadsheet to make sure the data has been added correctly.
Troubleshoot spreadsheet sync issues
If no data appears in your sheet:
- Confirm the Phantom you selected has output data available.
- Make sure the Google Sheets file is shared with your connected account.
- Double-check that field names in the sheet match the data you’re sending.
- Ensure the Google Sheets node is mapped manually and the workflow is saved.
- Get in touch with our Customer Care Team.
Watch the video tutorial
Frequently asked questions
Does my Phantom need to have run before I can send data to a sheet?
Yes. This workflow retrieves results from a Phantom that has already run. You aren't launching the Phantom from n8n, only pulling its output.
Can I use a spreadsheet other than Google Sheets?
n8n supports other spreadsheet nodes like Microsoft Excel and Airtable. The process is similar: connect the node, select your file, and map the fields.
What does "agent" mean in the PhantomBuster node?
In PhantomBuster's API, "agent" is the technical name for a Phantom. When you see "agent" in n8n, it refers to a Phantom in your PhantomBuster Workspace.
Why is no data appearing in my spreadsheet?
Check that your Phantom has output data available, that the Google Sheet is accessible to the Google account connected in n8n, and that the field names in the sheet match the data you are mapping.