Use Google Sheet to handle Phantombuster's APIs data
An API works like an opaque box. Send specific data, and it will return augmented information. (It depends on each API's purpose, but you get the idea.)
The data you import to the API is called input data, and the data generated by the API 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 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 API input tab because it will contain data that the API needs to do its job.
We'll create a second tab, the API output tab. This tab will be filled automatically by the content of a result.csv (file created by a Phantombuster API, 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 API.
A compatible CSV file should be available through a URL looking like this :
We just have to fill the A1 cell with this function:
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 API and the second is the output of this same API :)