View data in Google Sheets

On Phantombuster, data is handled using CSV files. Google Sheets documents are very convenient because they are available through public URLs as CSVs, and can be used to import (aka load) and view your data dynamically, so that you can keep on top of new data as it's being gathered.

 

 

1. Obtaining your Phantom's results CSV

The result.csv you need is available on the console page of your Phantom, underneath "Files." Click on "Copy link" to obtain its URL:

Copy_CSV_link.jpg

 

2. Import it into Google Sheets

In the A1 cell of your Google Sheet, enter the =IMPORTDATA() function (with the result.csv URL you just copied in quotation marks between the parentheses). It should look something like this:

Spreadsheet_-_import_data.jpg

 When you hit "Enter", the Google Sheet will load the contents of your results file for you.

 

3. Watch your data update dynamically

The beauty of this formula is that it will update your spreadsheet dynamically each time your Phantom launches, without you having to change anything. The results should refresh automatically every 2 hours, whether your file is open or closed. Alternatively, to manually refresh, add '?x' to your URL, where x is a random string.

Was this article helpful?
19 out of 36 found this helpful