LEC 8 IOT

Question 1

What is Google Apps Script (GAS)?

Answer 1

part of google suite ( cloud- based automation platform)
Uses JavaScript for scripting.
ability to extend google apps functionality (docs, sheets etc)

Question 2

What are the three main types of GAS?

Answer 2

Standalone – Stored in Google Drive and runs independently.
Bounded - Embedded to google workspace document
Web apps - Provides execution access via a web browser; standalone & bound scripts can be converted into web apps.

Question 3

What is the programming style of GAS?

Answer 3

Mainly JavaScript.
Uses camelCase for built-in objects and functions.
Object-oriented programming (OOP).

Question 4

How does a GAS Web App work

Answer 4

Client (browser, mobile, PC) sends requests and receives responses.
Server (Google Cloud) runs the script and processes requests.
Uses the concept callback:
“Call” = Sending code to the server.
“Callback” = The result sent back from the server.

Question 5

What are the two types of GAS deployment?

Answer 5

Test Deployment – Used for testing before actual release.
Actual Deployment – Generates a unique URL for web access.
Can be Private or Public.

Question 6

What are the steps to create a Web App in GAS?

Answer 6

Write the script, including doGet(e) or doPost(e).
Activate via Test Deployment or Actual Deployment.
A unique URL is generated only after deployment.

Question 7

What is the difference between doGet(e) and doPost(e)?

Answer 7

doGet(e): Handles GET requests (Fetching data).
Example use case: Displaying a webpage, retrieving data from Google Sheets.
doPost(e): Handles POST requests (Sending data).
Example use case: Submitting a form, storing IoT data in Google Sheets.

Question 8

Example of a simple Web App using GAS (doGet function)

Answer 8

function doGet(e) {
return ContentService.createTextOutput(“Hello, Web App!”);
}

Question 9

Example of a Web App that stores IoT data in Google Sheets (doPost function)

Answer 9

function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
sheet.appendRow([data.time, data.temperature, data.humidity]);
return ContentService.createTextOutput(“Data Saved”);
}

Question 10

What is the hierarchy of Google SpreadSheets in GAS?

Answer 10

Workbook → Worksheet → Cells
Uses A1 notation to access specific cells.

Question 11

What are some basic spreadsheet operations in GAS?

Answer 11

Get active spreadsheet:
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
Read from a cell:
var value = sheet.getRange(“A1”).getValue();
Logger.log(value);
Write to a cell:
sheet.getRange(“A1”).setValue(“New Data”);
Append data to a sheet:
sheet.appendRow([“Time”, “Temperature”, “Humidity”]);

Question 12

What are the limitations of GAS?

Answer 12

Storage limitations – Limited execution time and storage space.
Server response time – Can have delays depending on workload.
Security restrictions – Only accepts secure connections.