const API_URL = https://script.google.com/macros/s/AKfycbz4AM6xgnG2upAGHSpLxMIJYMbyDfLleEOsnhZkx1CVBO5FK37N5lJ-iYGNmGwHvJ44/exec
async function saveToGoogleSheets(member) {

  await fetch(API_URL, {
    method: "POST",
    body: JSON.stringify({
      Week: state.week,
      Name: member.name,
      Core40: member.core40,
      TwoWay: member.twoWay,
      OneWay: member.oneWay,
      ALeads: member.aLeads,
      BLeads: member.bLeads,
      Notes: member.notes
    })
  });

}
async function saveAllData() {

  const weekData = Object.values(getWeekData());

  for (const member of weekData) {
    await saveToGoogleSheets(member);
  }

  alert("Saved to Google Sheets!");

}