function doGet() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form Responses 1');

  const data = sheet.getDataRange().getValues();
  const headers = data.shift();

  const reviews = data
    .filter(row => {
      const showOnSite = row[headers.indexOf('Show on site')];

      // Hide only if explicitly set to "No"
      return String(showOnSite).trim().toLowerCase() !== 'no';
    })
    .map(row => {
      return {
        timestamp: row[headers.indexOf('Timestamp')],
        name: row[headers.indexOf('Your name')],
        designation: row[headers.indexOf('Your designation/job')],
        review: row[headers.indexOf('Review')],
        rating: Number(row[headers.indexOf('Give us a rating')])
      };
    });

  return ContentService
    .createTextOutput(JSON.stringify(reviews))
    .setMimeType(ContentService.MimeType.JSON);
}