Initiative Feedback Collection via Google Sheets and Webhook

[4tal]

1. Overview:
   A Google Spreadsheet will use Google Apps Script to provide a webhook endpoint. This endpoint will handle incoming HTTP POST requests containing feedback about a specific initiative, including its current status and various contact methods, storing them directly into the spreadsheet.

2. Google Spreadsheet Setup:

Create a new Google Spreadsheet.
Define columns: "InitiativeName", "IsActive", "Feedback", "Telegram", "WhatsApp", "Website", "LinkedIn".
3. Google Apps Script:

Create a new script file from the Google Spreadsheet by clicking on Extensions > Apps Script.
Write a script that:
Creates a doPost(e) function to handle HTTP POST requests.
Parses and validates the request body content.
Appends valid data to the spreadsheet.
4. Script Example:

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var postData = JSON.parse(e.postData.contents);
  
  // Extract data from the POST request body
  var initiativeName = postData.initiativeName;
  var isActive = postData.isActive ? "Yes" : "No"; // Expecting a boolean value
  var feedback = postData.feedback;
  var telegram = postData.telegram || ""; // Optional fields
  var whatsapp = postData.whatsapp || "";
  var website = postData.website || "";
  var linkedin = postData.linkedin || "";

  // Append data to the sheet
  sheet.appendRow([initiativeName, isActive, feedback, telegram, whatsapp, website, linkedin]);

  // Return a success message
  return ContentService.createTextOutput(
    JSON.stringify({"status": "success"})
  ).setMimeType(ContentService.MimeType.JSON);
}

[ohadschn]

@4tal

1. how is this backend and not devops? As I see it we still don't have a backend...
2. what about creating Github issues from those GSheet records (presumably of the type Auto PR - support editing existing initiatives #428, where edit in the broad sense could also include "delete")?

[4tal]

Exactly, automated PR is the next step.

[4tal]

Because it function as a backend and not proper DevOps/infra area