AI-Written Tutorials — Step-by-Step Guides in 60 Seconds

# How to Set Up Automated Email Reports with Google Sheets & Apps Script

## Prerequisites
- Google account with access to Google Sheets
- Basic familiarity with spreadsheets (no coding needed)
- A dataset in Google Sheets you want to report on

## What You'll Build
An automated script that summarises your spreadsheet data and
emails a formatted report to your team every Monday at 9 AM.

---

## Step 1: Prepare Your Spreadsheet
1. Open your Google Sheet containing the data
2. Ensure headers are in Row 1 (e.g., Date, Sales, Region)
3. Name the sheet tab "Data" (right-click the tab → Rename)

> **Tip:** Remove any merged cells — they break script data reading.

## Step 2: Open the Apps Script Editor
1. Click **Extensions → Apps Script**
2. Delete any placeholder code in the editor
3. Rename the project to "Weekly Report Automation"

## Step 3: Write the Report Function
Paste the following code:

```javascript
function sendWeeklyReport() {
  const sheet = SpreadsheetApp.getActive().getSheetByName("Data");
  const data = sheet.getDataRange().getValues();
  const headers = data[0];
  const rows = data.slice(1);

  // Calculate summary
  const totalSales = rows.reduce((sum, row) => sum + row[1], 0);
  const avgSales = totalSales / rows.length;

  // Build email body
  const body = `Weekly Sales Summary\n\n`
    + `Total: $${totalSales.toFixed(2)}\n`
    + `Average: $${avgSales.toFixed(2)}\n`
    + `Records: ${rows.length}`;

  MailApp.sendEmail("team@example.com", "Weekly Report", body);
}
```

## Step 4: Set Up the Weekly Trigger
1. Click the clock icon (Triggers) in the left sidebar
2. Click **+ Add Trigger**
3. Set: Function = sendWeeklyReport, Event = Time-driven,
   Type = Week timer, Day = Monday, Time = 9-10 AM

---

## Troubleshooting
| Issue | Solution |
|-------|----------|
| "Sheet not found" error | Check tab is named exactly "Data" |
| Email not sending | Authorise Gmail access when prompted |
| Numbers showing as text | Format the Sales column as Number |