Fetch data from Google Sheets API in TypeScript

spreadsheet.ts

export interface SpreadsheetValues {
  majorDimension: "DIMENSION_UNSPECIFIED" | "ROWS" | "COLUMNS";
  range: string;
  values: string[][];
}

export async function getSpreadsheetValues(
  id: string,
  sheet: string
): Promise<Record<string, string>[]> {
  let data: SpreadsheetValues;

  try {
    const response = await fetch(
      `https://sheets.googleapis.com/v4/spreadsheets/${id}/values/${sheet}?key=${
        import.meta.env.VITE_GOOGLE_API_KEY
      }`
    );
    data = await response.json();
  } catch (e) {
    console.error("Error fetching spreadsheet data:", e);
    return [];
  }

  const rows: Record<string, string>[] = [];
  const rawRows: string[][] = data.values || [[]];
  const headers: string[] = rawRows.shift() || [];

  for (const row of rawRows) {
    const rowData = row.reduce<Record<string, string>>((acc, cell, index) => {
      acc[headers[index]] = cell;
      return acc;
    }, {});

    rows.push(rowData);
  }

  return rows;
}