Load a Phantom's results into Google Sheet dynamically

Use Google Sheet to handle your Phantoms data

A Phantom works like an opaque box. Send specific data, and it will return augmented information. (It depends on each Phantom's purpose, but you get the idea.)

The data you import to the Phantom is called input data, and the data generated by the Phantom is called output data.

E.g., LinkedIn Search Export takes a list of search words as an input and creates a file containing the list of people found as an output.

On Phantombuster, data are handled using CSV files. This simple format is compatible with Excel, Numbers and of course Google Sheets.

The problem is that the input CSV and the output CSV are different files, on different services. 

How to dynamically handle all the data using only one Google Sheet?

Google Sheets

Google Sheets documents are very convenient. They are available through public URLs as CSVs and can import data using built-in functions.

We'll consider the first tab of the document as the Phantom input tab because it will contain data that the Phantom needs to do its job.

We'll create a second tab, the Phantom output tab. This tab will be filled automatically by the content of a result.csv (file created by a Phantom, after its first launch.)

To do that, we'll use the built-in function "=IMPORTDATA()" in the A1 cell of the tab. This function takes only one argument between the parentheses: the URL of a result.csv file.

The result.csv you need is available on the console page of your Phantom.



Right-click on result.csv and copy its link. 

A compatible CSV file should be available through a URL looking like this :

https://phantombuster.s3.amazonaws.com/xxxxxxxxx/yyyyyyyyy/result.csv
We just have to fill the A1 cell with this function:

=IMPORTDATA("https://phantombuster.s3.amazonaws.com/xxxxxxxxx/yyyyyyyyy/result.csv")
This example will not work directly, use a result.csv file of yours.

When you hit "Enter", the Google Sheet tab will load result.csv for you.

We're done! Now your Google Sheet is composed of two tabs. The first one is the input of your Phantom and the second is the output of this same Phantom :)