Google sheets functions for meetup

google-sheets.js

function getCost(cell) {
  return cell.match(/\$[\d.,]+\d/)[0]
}

function getCondition(cell) {
  return cell.match(/((like )?new|used|mint|good|great|excellent)/i)[0]
}

function getEmail(cell) {
  return (cell.match(/[^\s@]+@[^\s@]+/i) || ['N/A'])[0]
}

var phoneRegex = /\(?([0-9]{3})\)?[-.●]?([0-9]{3})[-.●]?([0-9]{4})/

function getPhone(cell) {
  return (cell.match(phoneRegex) || ['N/A'])[0]
}