Scribd
Upload
6 views2 pages

Google Sheets Data Logger for Sensors

The function 'doPost' processes incoming JSON data and logs it into a Google Sheet. It ensures a header row exists and formats the ESP32 timestamp before appending sensor data such as CO levels, vibration intensity, humidity, and roll angle. Finally, it confirms successful data receipt with a text output message.

Uploaded by

romaehab201912
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

Google Sheets Data Logger for Sensors

The function 'doPost' processes incoming JSON data and logs it into a Google Sheet. It ensures a header row exists and formats the ESP32 timestamp before appending sensor data such as CO levels, vibration intensity, humidity, and roll angle. Finally, it confirms successful data receipt with a text output message.

Uploaded by

romaehab201912
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

function doPost(e) {

var sheet = [Link]().getActiveSheet();


var data = [Link]([Link]); // Parse incoming JSON

// Ensure the sheet has a header row if it doesn't exist


if ([Link]() === 0) {
[Link]([
"Sheet Time", // Current time of data logging
"Timestamp (MM:SS)", // ESP32 timestamp in minutes and seconds
"CO (ppm)", // CO level from MQ sensor
"Vibration Intensity", // Vibration intensity
"Humidity (%)", // Humidity from DHT sensor
"X Angle (°)", // Roll angle
]);
}

// Extract ESP32 timestamp and format it to MM:SS


var esp32Time = new Date([Link] || new Date()); // Fallback tto
current time
var minutes = [Link]();
var seconds = [Link]();
var formattedTimestamp = `${minutes}:${seconds}`;

// Append new sensor data to the Google Sheet


[Link]([
new Date(), // Current time in sheet
formattedTimestamp, // ESP32 timestamp in MM:SS
[Link] || "N/A", // CO level
data["vibration Intensity"] || "N/A", // Vibration intensity
[Link] || "N/A", // Humidity
[Link] || "N/A", // X angle (roll)
]);

// Confirm data receipt


return [Link]("Data received successfully");
}

You might also like