Most Captain Data workflows need inputs to run.
You can either add inputs one-by-one, or upload a CSV of inputs.
If you decide to update them one by one, simply copy and paste the url for each input.
You add as many inputs as you want by clicking on "+ new".
There's always a how-to on the right-panel if you need any help 🙌
IMPORTANT NOTE: A maximum of 1000 inputs is definitely recommended.
Import from a file
If you already have a file ready for import, you can upload inputs from a file.
You can upload any .csv or .xls with any set of columns.
Important: The file needs to follow a specific formatting to be processed properly.
In our example above, we expect a column "linkedin_profile_url" to validate your file.
You can drag & drop a file in the zone.
The column are perfectly mapped and you visualize all the imported data!
If you have an error, you probably don't have the appropriate headers on your CSV file.
You can also filters columns you want to see:
Additionally, to the primary column, you can add as many columns as you want as "meta".
They will be mapped as extra column:
Columns are mapped as-is, e.g. we do not change them.
⚠️ We do recommend though that you use first_name instead of First Name.
(No capital letters and no spaces)
You will find this data in the meta column, all in JSON at the first step, and last step:
If you want to convert this JSON data into separates columns, you will need to add a JSON Iterator (Captain Data application) as a last step and put meta in the key field.
Some workflows require additional data validation.
For example here it absolutely needs a linkedin_profile_url to be working so it gives you an error:
If you need, you can filter only invalid inputs by click "Show X input(s) with error(s)".
And if you hit the "Clear" button while selecting only inputs in errors, it will remove only the wrong inputs:
If you're working with Google Sheets, you can download the spreadsheet as a CSV.