Import a CSV file from an attachment field in an Airtable Automation
Hello, So Airtable has a script that allows importing a CSV file to update records, I am trying to use this script in an Automation but instead of uploading the CSV to the script, I need it to grab it from an attachment field. The Airtable Script: // Ask the user to import a CSV file containing a header row
let csvFileResult = await input.fileAsync(
'Upload a CSV file',
{allowedFileTypes: ['.csv'], hasHeaderRow: true}
);
// The file importer will automatically parse contents for many file types, including CSV files
let csvRows = csvFileResult.parsedContents;
// Edit this to the name of a table in your base
let table = base.getTable('Purchases');
let shouldContinue = await input.buttonsAsync(
`Import ${csvRows.length} records from ${csvFileResult.file.name} into ${table.name}?`,
[{label: 'Yes', variant: 'primary'}, 'No']
)
if (shouldContinue === 'Yes') {
// Create new records from the CSV.
// Edit these field and property names to match your
