Differences

This shows you the differences between two versions of the page.

--- amc:ss2025:group-f:start [2025/07/28 21:22] – [3.6 Google Apps Script and Google sheets] 33784_students.hsrw
+++ amc:ss2025:group-f:start [2025/10/17 09:58] (current) – elham.mohammadi
@@ Line 1: / Line 1: @@
 ======  Smart Plant Watering with ESP32 and MQTT======
+**Applied Measurement and Control 2025**
 Paul-Christian Thoma(32436)-Elham Mohammadi(32475)-Deniz-Zeynep Adem(33784)
@@ Line 16: / Line 18: @@
 By combining local sensing, cloud-based logic, and remote monitoring tools, this system provides a scalable, modular approach to smart irrigation in home or laboratory environments.
-{{ amc:ss2025:group-f:prototype2.jpeg |}}
+{{ :amc:ss2025:group-f:prototype2.jpeg?direct&600 |{{ amc:ss2025:group-f:prototype2.jpeg |}}
 **Figure 1.** Automated Plant Watering System Prototype
@@ Line 123: / Line 126: @@
 The following diagrams, created using Tinkercad, illustrate the complete hardware connections for both the Sensor and Pump nodes in the system.
-{{ amc:ss2025:group-f:moisture_sensor_circuit.png |}}
+{{ :amc:ss2025:group-f:moisture_sensor_circuit.png?direct&600 |}}
 **Figure 2.** Schematic Diagram of Sensor Setup (designed by Deniz-Zeynep Adem)
-{{ amc:ss2025:group-f:pump_wiring_with_adaptor.png |}}
+{{ :amc:ss2025:group-f:pump_wiring_with_adaptor.png?direct&600 |}}
 **Figure 3.** Schematic Diagram of Pump Setup (designed by Deniz-Zeynep Adem)
@@ Line 532: / Line 535: @@
 **Google Apps Script Codes:**
+<code cpp>
-  function doPost(e) {
+function doPost(e) {
   try {
     const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
@@ Line 543: / Line 546: @@
     const timestamp = new Date();
-    // Yeni veriyi en üste ekle (2. satıra)
+    // Add new data to top (2nd row)
     sheet.insertRows(2, 1);
     sheet.getRange(2, 1).setValue(timestamp);
-    sheet.getRange(2, 2).setValue(status);
+    sheet.getRange(2, 2).setValue(action);
     sheet.getRange(2, 3).setValue(moisture);
-    sheet.getRange(2, 4).setValue(action);
+    sheet.getRange(2, 4).setValue(status);
-    // Alert varsa e-posta gönder
+    // Send emails if there is an alert
     if (action.toLowerCase().includes("alert")) {
       MailApp.sendEmail("youremail@example.com", "⚠️ Plant Alert",
@@ Line 563: / Line 566: @@
 }
+</code>
 ======  4. Node-RED Overview======
@@ Line 573: / Line 577: @@
 Below is a video showcasing the node-Red flow and showing the code and possible errors that came up and how they were fixed. Starting with the discussion part of this documentation.
-https://student-wiki.eolab.de/lib/exe/fetch.php?w=120&h=120&tok=b20d52&media=amc:ss2025:group-f:whatsapp_image_2025-07-28_at_12.23.27_am.jpeg
+{{ :amc:ss2025:group-f:file_2025-07-28_14.25.34.png?direct&600 |}}
 **Figure 4.** Documentation of the data in note-red (designed by Paul-Christian Thoma)
@@ Line 622: / Line 625: @@
 {{youtube>sK5l7mIVL0s?}}
+{{youtube>vU9CFVkbPiY?}}
+{{youtube>XZt8VXC4Ths?}}