Airtable scraper script (DevTools)

airtablescrape.js

let columns = temp1.table.columns,
  identifiers = {
    'Company name': 'name',
    'City': 'city',
    'Where to apply': 'url',
    'Status': 'status'
  };

function getData (row) {
    return _.reduce(columns, (acc, column) => {
        if (_.includes(Object.keys(identifiers), column.name)) {
            if (row.cellValuesByColumnId[column.id]){
                if (column.name === 'Status') {
                    let statuses = row.cellValuesByColumnId[column.id];
                    statuses = _.map(statuses, (status) => {
                        return _.find(temp1.table.columns[1].typeOptions.choices, { id: status }).name;
                    });
                    acc.status = statuses;
                }
                else {
                    acc[identifiers[column.name]] = row.cellValuesByColumnId[column.id];
                }
            }
        }
        return acc;
    }, {});
}

let data = _.map(temp1.table.rows, (row) => {
    return getData(row);
}, {});

copy(data); // Copy the entire data to clipboard