Pull from Google Sheets

 
export default async function main(args) {
  const { google_sheets_api_key, spreadsheet_link, range } = args.inputVars;

  if (!google_sheets_api_key || !spreadsheet_link || !range) {
    return {
      next: { path: 'error' },
      trace: [{ type: "debug", payload: { message: "Missing required input variables for Google Sheets API function" } }]
    };
  }

  const spreadsheetIdRegex = /\/d\/([a-zA-Z0-9-_]+)/;
  const match = spreadsheetIdRegex.exec(spreadsheet_link);
  if (!match) {
    return {
      next: { path: 'error' },
      trace: [{ type: "debug", payload: { message: "Invalid Google Sheets URL" } }]
    };
  }
  const spreadsheet_id = match[1];

  const url = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheet_id}/values/${range}?key=${google_sheets_api_key}`;

  try {
    const response = await fetch(url, { method: 'GET', headers: { 'Content-Type': 'application/json' } });
    const responseBody = response.json;

    if (!responseBody || typeof responseBody !== 'object') {
      return {
        next: { path: 'error' },
        trace: [{ type: "debug", payload: { message: "Invalid or missing response body from Google Sheets API" } }]
      };
    }

    // Simplifying the return object for testing
    return {
      outputVars: { sheetData: JSON.stringify(responseBody) }, // Temporarily return the response as a string
      next: { path: 'success' },
      trace: [{ type: "debug", payload: { message: "Response Body: " + JSON.stringify(responseBody) } }]
    };
  } catch (error) {
    return {
      next: { path: 'error' },
      trace: [{ type: "debug", payload: { message: "Error fetching data from Google Sheets: " + error.message } }]
    };
  }
}