const currentDateAndTime = luxon.DateTime.now().toISO()
const webhookUrl = 'https://hook.us1.make.com/<your_scenario_id>'
try {
  const response = await axios.post(webhookUrl, { currentDateAndTime })
  const webhookResponse = response.data
  console.log(webhookResponse)
  const { sheetsData } = webhookResponse // Extract the array
  console.log(sheetsData)
  await removeAllRecords()
  await insertRecords(sheetsData)
} catch (error) {
  console.log(error)
}

async function removeAllRecords() {
  try {
    const data = await SheetsDataTable.findRecords({ selectorName: 'allRecords' })
    const recordIDsToDelete = data.map((data) => data.id)
    await SheetsDataTable.deleteRecords(recordIDsToDelete)
  } catch (error) {
    console.log(error)
  }
}

async function insertRecords(sheetsData) {
  try {
    await SheetsDataTable.createRecords(sheetsData)
  } catch (error) {
    console.log(error)
  }
}