Using spreadsheets as input: specifying where input is located

If you use a spreadsheet as input, the Phantom will take the data from Column A of your Google Sheet by default. If you'd like it to take data from another column, you need to specify the name of that column within your setup!

To specify the name of the column that you would like your Phantom to process, navigate to the "Spreadsheet settings":

mceclip1.png

If your input spreadsheet contains multiple columns, identify the specific "Column name." This corresponds to the title found in row 1:

Column_names.jpg

If you don't specify anything, your Phantom will process the 1st column of your spreadsheet by default. 

To process a different column, such as the 8th column named "twitterProfile" in this example, inform the Phantom by selecting that title in the setup field:

mceclip3.png

What if my spreadsheet does not contain a column title?

If you would like to scrape several Twitter profiles, and your spreadsheet will only contain the profile URLs, you can put all the URLs under column A:

mceclip4.png

And on the Phantom setup, since the column does not have a name, you set this field up as "-":

mceclip5.png

Like this, the Phantom will read column A by default.

 

If you think this article does not address your issue, please contact Support directly. We are continuously improving, so your feedback means the world to us!

Was this article helpful?
17 out of 61 found this helpful