Integração Zazos e Google Sheets

function doPost(e) {
  try {
    // Parse the JSON data from the request body
    var requestBody = JSON.parse(e.postData.contents);
    
    // Check if the 'values', 'spreadsheetId', and 'sheetName' keys are present
    if (Array.isArray(requestBody.values) && requestBody.spreadsheetId && requestBody.sheetName) {
      var spreadsheetId = requestBody.spreadsheetId;
      var sheetName = requestBody.sheetName;
      
      // Open the spreadsheet by ID
      var targetSpreadsheet = SpreadsheetApp.openById(spreadsheetId);
      
      // Get the specified sheet by name
      var targetSheet = targetSpreadsheet.getSheetByName(sheetName);
      
      if (targetSheet) {
        // Append the array of values to the specified sheet as a new row
        targetSheet.appendRow(requestBody.values);
        return ContentService.createTextOutput("Data appended successfully to sheet '" + sheetName + "' in spreadsheet with ID: " + spreadsheetId).setMimeType(ContentService.MimeType.TEXT);
      } else {
        return ContentService.createTextOutput("Sheet '" + sheetName + "' not found in the specified spreadsheet.").setMimeType(ContentService.MimeType.TEXT);
      }
    } else {
      return ContentService.createTextOutput("Invalid JSON format. 'values', 'spreadsheetId', and 'sheetName' should be provided.").setMimeType(ContentService.MimeType.TEXT);
    }
  } catch (error) {
    return ContentService.createTextOutput("An error occurred: " + error.message).setMimeType(ContentService.MimeType.TEXT);
  }
}