fx Automation

Google Apps Script for Sheets

90 मिनट6 पाठ18 प्रश्न

पाठ

1. Apps Script editor, SpreadsheetApp basics15 min 2. getRange / getValues / setValues — and why batch operations matter15 min 3. Custom functions — your own =MYFUNC()15 min 4. Triggers: onOpen, onEdit, time-driven (daily 9 AM report)15 min 5. Automated alerts with MailApp / GmailApp15 min 6. UrlFetchApp — pulling live data from an API15 min

अभ्यास फ़ाइल

⬇ डाउनलोड करें automation-practice.zip

Automation practice bundle

One ZIP serves all seven modules. It contains a generated, macro-free automation-practice.xlsx, bilingual solutions, three intentionally messy CSVs, Python report/email/pipeline scripts, requirements, a Windows launcher, a sample GitHub Actions workflow, and a README. No credentials or executable VBA are embedded.

The workbook contains Read Me, ROI, Data, Output, Sales, Products, Customers, Invoices, Statement, Orders, Rates, and Log. Data has 30 stock rows (15 reorder, 3 out of stock, total shortfall 45). Sales has 30 rows: North/South 8 each and East/West 7 each; three salespeople have 10 rows each. Five customer balances are 1200, 0, 800, 0, 500. Statement is an exercise template, not a completed statement.

The separate CSV project has 10 input rows: 7 valid unique, 2 rejected and 1 duplicate. Regional totals: South 96000, North 92000, West 61000; overall 249000. Rejected rows preserve original field values, including the literal NA amount.

Extract the ZIP and follow README.md to install the Python requirements and run the examples. Start with python pipeline.py --no-email using copies of the sample data. Desktop VBA, Outlook and xlwings exercises require the applications listed in their respective lessons. The bundle includes no credentials or enabled schedules.

मॉड्यूल प्रश्नोत्तरी (18)

1. Menu to open Apps Script from a sheet?

Extensions → Apps Script

2. What does getSheetByName return if the tab doesn't exist?

null

3. Where do you see Logger.log output?

Execution log

4. What does getValues() return?

A 2D array — rows of cells

5. values[0][0] refers to which cell of the range?

The top-left one

6. Maximum run time of a script?

6 minutes

7. Which tag makes a function show in autocomplete?

@customfunction

8. What does a custom function receive when given B2:B10?

A 2D array

9. Can a custom function send an email?

10. Can a simple onEdit trigger send an email?

11. How exact is a daily 9 AM trigger?

It runs sometime between 9 and 10

12. What does appendRow do?

Adds a row after the last filled row

13. Which service needs the smaller permission for sending?

MailApp

14. How do you see how many emails you can still send today?

MailApp.getRemainingDailyQuota()

15. Why return early when the low list is empty?

To avoid sending empty alerts

16. What does muteHttpExceptions: true do?

Returns the error response instead of throwing, so you can check the code

17. Where should an API key be stored?

Script Properties

18. Which function turns JSON text into an object?

JSON.parse