generate.js

const fs = require('fs')
const got = require('got')
const spreadsheetId = '1x_W7Z2o_TGmEjL5cLTFbjO1R3KzQOqIhQKu9RQ4a_P4'
const apiKey = 'AIzaSyA5el9Fo8rMSYkcMjUqLfJi4tDB5_n0bzY'
const slugify = require('slugify')

const slugger = text =>
  slugify(text, {
    replacement: '-',
    lower: true,
    locale: 'tr'
  })

const mapper = (posts) => {
  const keys = posts.slice(0, 1)[0]
  return posts.slice(1).map((row) => {
    const rowData = {}
    keys.map((key, index) => {
      key = key.toLowerCase().replace(/\W/g, '_')
      rowData[key] = row[index]
    })
    return rowData
  })
}

const generateAvatar = ({ name, github }) => {
  let avatar
  if (github) {
    const githubUsername = github.split('/')[3];
    avatar = `https://avatars.githubusercontent.com/${githubUsername}`
  } else {
    avatar = `https://ui-avatars.com/api/?name=${name}`
  }
  return avatar
}

const fixProtocol = (url) => {
  return url ? 'https://' + url.replace(/https?:\/\//gi, '').replace(/\/$/gi, '') : ''
}

const clearData = (posts) => {
  return posts.map((post) => {
    post.slug = slugger(post.name)
    post.github = fixProtocol(post.github)
    post.twitter_handle = fixProtocol(post.twitter_handle)
    post.linkedin = fixProtocol(post.linkedin)
    post.avatar = generateAvatar(post)
    return post
  })
}

async function getData () {
  try {
    const url = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}/values:batchGet?key=${apiKey}&fields=valueRanges(range,values)&ranges=Mentees`
    let response = await got(url)
    response = JSON.parse(response.body)
    let [persons] = response.valueRanges
    persons = mapper(persons.values.slice(4).filter(r => r.length))
    const mentors = persons.filter((person) => {
      if (person.mentor === 'Mentor' || person.mentor === 'İkisi de') {
        return person
      }
    })
    const mentees = persons.filter((person) => {
      if (person.mentor === 'Mentee' || person.mentor === 'İkisi de') {
        return person
      }
    })

    const data = { persons, mentees, mentors }
    return { status: 200, data }
  } catch (err) {
    console.log(err)
    return { status: 404 }
  }
}

getData().then(({ status, data: { persons, mentees, mentors } }) => {
  if (status !== 200) {
    throw new Error('Error when fetching data from spreadsheet')
  }
  fs.writeFileSync('content/persons.json', JSON.stringify(clearData(persons), null, 2))
  fs.writeFileSync('static/persons.json', JSON.stringify(clearData(persons), null, 2))
  fs.writeFileSync('static/mentees.json', JSON.stringify(clearData(mentees), null, 2))
  fs.writeFileSync('static/mentors.json', JSON.stringify(clearData(mentors), null, 2))
})