How to Use ChatGPT Inside Google Sheets for Automation

# Connecting ChatGPT to Google Sheets for Product Descriptions

For 200 rows and a non-developer, I recommend **Google Apps Script with the OpenAI API**. It's free (beyond OpenAI usage costs), gives you a custom `=GPT()` formula, and takes ~10 minutes to set up.

---

## Setup

### 1. Get your OpenAI API key
- Go to https://platform.openai.com/api-keys
- Click **Create new secret key**, copy it (starts with `sk-...`)
- Add a small amount of credit at **Billing → Add payment method** ($5 is plenty for 200 rows — actual cost ~$0.10 with `gpt-4o-mini`)

### 2. Open Apps Script in your sheet
- In your Google Sheet: **Extensions → Apps Script**
- Delete any default code in the editor

### 3. Paste the code below
- Paste the script (next section), **replace `YOUR_API_KEY_HERE`** with your key
- Click the 💾 **Save** icon, name the project "GPT Rewriter"
- Close Apps Script and return to your sheet

---

## Code

```javascript
/**
 * Rewrites a product description into a punchy 2-sentence version.
 * Usage in a cell: =GPT(A2)
 */
function GPT(prompt) {
  const API_KEY = "YOUR_API_KEY_HERE"; // paste your key here
  const url = "https://api.openai.com/v1/chat/completions";

  const payload = {
    model: "gpt-4o-mini", // cheap + fast; good for bulk rewrites
    messages: [
      { role: "system", content: "Rewrite product descriptions into a punchy, engaging 2-sentence version. Return only the rewrite." },
      { role: "user", content: String(prompt) }
    ],
    temperature: 0.7
  };

  const options = {
    method: "post",
    contentType: "application/json",
    headers: { Authorization: "Bearer " + API_KEY },
    payload: JSON.stringify(payload),
    muteHttpExceptions: true
  };

  const response = UrlFetchApp.fetch(url, options);
  const data = JSON.parse(response.getContentText());

  if (data.error) return "Error: " + data.error.message;
  return data.choices[0].message.content.trim();
}
```

---

## Usage

1. Assume original descriptions are in **column A** (A2:A201).
2. In **B2**, type: `=GPT(A2)`
3. Press Enter. First run, Google will ask to **authorize** — click **Review permissions → Advanced → Go to GPT Rewriter (unsafe) → Allow**. (It's "unsafe" only because it's your own script.)
4. Drag the B2 fill handle down to B201. Cells will show `Loading...` then fill in.
5. **Important:** Once done, copy column B → **Paste Special → Values only**. This locks in the text so it doesn't re-run and cost you again.

---

## Troubleshooting

- **`Error: Rate limit`** — Fill ~50 rows at a time instead of all 200. Free-tier API keys have low rate limits; paid accounts are fine.
- **`#ERROR!` or blank cells** — Select the cell and press **Delete**, then re-enter the formula. Apps Script custom functions sometimes time out after 30s.
- **Inconsistent tone** — Edit the `system` prompt (e.g., "Use a playful tone with emojis" or "Keep under 25 words per sentence").
- **Cost control** — Stick with `gpt-4o-mini` (~$0.0005 per rewrite). Avoid `gpt-4o` for bulk jobs unless you need higher quality.
- **Key safety** — Never share the sheet's Apps Script with others; your API key is inside it.

That's it — you'll have 200 punchy descriptions in under 10 minutes. 🚀

# ChatGPT Product Description Shortener for Google Sheets

## Best Integration Method
**Recommendation: OpenAI API + Google Apps Script**

This is ideal for your use case because:
- Cost-effective (you pay per API call, ~$0.001 per description)
- Works directly in Sheets with no add-ons
- Handles 200 descriptions reliably
- No monthly subscription fees

---

## Setup Instructions

### Step 1: Get Your OpenAI API Key
1. Go to [platform.openai.com](https://platform.openai.com)
2. Sign up or log in
3. Click **API keys** (left sidebar) → **Create new secret key**
4. Copy and **save it somewhere safe** (you'll need it in 10 minutes)
5. Set a usage limit in **Billing** → **Usage limits** (~$20 recommended)

### Step 2: Open Apps Script in Google Sheets
1. Create or open your Google Sheet with products in column A
2. Go to **Extensions** → **Apps Script**
3. Delete any default code and paste the code block below

### Step 3: Add Your API Key
1. In Apps Script, go to **Project Settings** (gear icon)
2. Enable **Apps Script API**
3. Return to the editor and add your key to line 2 of the script

---

## Code Block (Copy-Paste Ready)

```javascript
// ⚠️ REPLACE 'YOUR_API_KEY_HERE' with your actual key from OpenAI
const OPENAI_API_KEY = 'YOUR_API_KEY_HERE';

function shortenDescription(productDescription) {
  if (!productDescription || productDescription.trim() === '') {
    return 'Error: Empty description';
  }

  const url = 'https://api.openai.com/v1/chat/completions';
  
  const payload = {
    model: 'gpt-3.5-turbo',
    messages: [
      {
        role: 'system',
        content: 'You are a copywriter. Rewrite product descriptions into exactly 2 punchy sentences (under 30 words total). Be compelling and focus on benefits.'
      },
      {
        role: 'user',
        content: productDescription
      }
    ],
    max_tokens: 50,
    temperature: 0.7
  };

  const options = {
    method: 'post',
    headers: {
      'Authorization': 'Bearer ' + OPENAI_API_KEY,
      'Content-Type': 'application/json'
    },
    payload: JSON.stringify(payload),
    muteHttpExceptions: true
  };

  try {
    const response = UrlFetchApp.fetch(url, options);
    const result = JSON.parse(response.getContentText());
    
    if (result.error) {
      return 'Error: ' + result.error.message;
    }
    
    return result.choices[0].message.content.trim();
  } catch (error) {
    return 'Error: API call failed';
  }
}

// Run this to shorten ALL descriptions in column A, output to column B
function processAllDescriptions() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const range = sheet.getRange('A:A');
  const values = range.getValues();

  for (let i = 0; i < values.length; i++) {
    if (values[i][0] && i > 0) { // Skip header row
      const shortened = shortenDescription(values[i][0]);
      sheet.getRange(i + 1, 2).setValue(shortened); // Write to column B
      Utilities.sleep(300); // Avoid rate limits (300ms delay)
    }
  }
  SpreadsheetApp.getUi().alert('✓ Done! Check column B.');
}
```

---

## Usage

1. **First test**: In column B, cell B2, enter formula: `=shortenDescription(A2)` and press Enter
2. **Process all**: Click **Run** button and select `processAllDescriptions`
3. Monitor **Execution log** (bottom of Apps Script editor) for errors

---

## Troubleshooting

| Issue | Solution |
|-------|----------|
| "Invalid API key" | Verify key copied correctly; check it's not expired |
| Rate limit errors | Already built in (300ms delays). Increase to 500ms if needed |
| Timeout errors | Split 200 descriptions into batches of 50 |
| Blank outputs | Check original description isn't empty; increase `max_tokens` to 60 |

**Estimated cost**: 200 descriptions × ~$0.0005 = **~$0.10 total**

Of course. For your goal of batch-rewriting 200 product descriptions, the most direct and cost-effective method is using the **OpenAI API with Google Apps Script**. This avoids third-party subscription fees and gives you a reusable tool right inside your sheet.

Here is your step-by-step guide.

### 1. Setup

First, you need to get an OpenAI API key and open the script editor in your Google Sheet.

1.  **Get OpenAI API Key:**
    *   Go to [platform.openai.com](https://platform.openai.com/) and log in or create an account.
    *   Go to the API Keys section (click your profile icon in the top-right).
    *   Click "**Create new secret key**". Name it something like "GoogleSheets" and copy the key immediately. **You will not be able to see it again.**
    *   You must also set up billing by adding a payment method under the "Billing" section. You'll only be charged for what you use, which will be very low for this task (likely less than $0.20).

2.  **Open Apps Script Editor:**
    *   In your Google Sheet, click **Extensions** > **Apps Script**.
    *   A new browser tab will open with a code editor. Delete any placeholder code in the `Code.gs` file.

### 2. Code

Copy the entire code block below and paste it into the Apps Script editor.

```javascript
// Replace "YOUR_API_KEY" with the key you copied from OpenAI.
const SECRET_KEY = "YOUR_API_KEY";

/**
 * Rewrites a long product description into a punchy 2-sentence version.
 *
 * @param {string} long_description The text from the source cell to rewrite.
 * @return The rewritten description from ChatGPT.
 * @customfunction
 */
function GENERATE_DESCRIPTION(long_description) {
  // Check if the input is empty to avoid unnecessary API calls.
  if (!long_description) {
    return "Input cell is empty.";
  }

  // The API endpoint for chat models

### Best Method: OpenAI API + Google Apps Script
Perfect for batch-rewriting 200 descriptions in one click—no per-cell formulas, low cost (~$0.05 total with GPT-4o-mini), fully customizable.

### Setup
1. Get OpenAI API key: Visit [platform.openai.com/api-keys](https://platform.openai.com/api-keys), sign up/log in, click "Create new secret key". Copy it (starts with `sk-`).
2. Open your Sheet > **Extensions > Apps Script**.
3. Delete default code, paste the script below. Replace `YOUR_API_KEY_HERE` with your key.
4. Save project (name it "Product Rewriter"). Click **Run** > authorize permissions (review scopes: Sheets, external requests).

```javascript
function rewriteDescriptions() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getRange('A2:A201').getValues(); // Assumes descriptions in A2:A201
  const apiKey = 'YOUR_API_KEY_HERE'; // Paste your key here
  const url = 'https://api.openai.com/v1/chat/completions';
  
  for (let i = 0; i < data.length; i++) {
    const desc = data[i][0];
    if (!desc) continue; // Skip empty cells
    
    const prompt = `Rewrite this product description into a punchy 2-sentence version:\n\n${desc}`;
    
    const payload = {
      model: 'gpt-4o-mini', // Cheap & fast
      messages: [{role: 'user', content: prompt}],
      max_tokens: 100
    };
    
    const options = {
      method: 'POST',
      headers: {
        'Authorization': `Bearer ${apiKey}`,
        'Content-Type': 'application/json'
      },
      payload: JSON.stringify(payload)
    };
    
    try {
      const response = UrlFetchApp.fetch(url, options);
      const json = JSON.parse(response.getContentText());
      const result = json.choices[0].message.content.trim();
      sheet.getRange(i + 2, 2).setValue(result); // Writes to B column
      Utilities.sleep(100); // Avoid rate limits
    } catch (error) {
      console.log(`Row ${i+2} error: ${error}`);
      sheet.getRange(i + 2, 2).setValue('Error');
    }
  }
}
```

### Usage
1. In Apps Script, select `rewriteDescriptions` > **Run**. It processes A2:A201 → B2:B201 automatically.
2. Refresh Sheet. Add **Insert > Drawing > Save and Close** for a button: Right-click drawing > **Assign script > rewriteDescriptions**.

### Troubleshooting
- **Auth error**: Re-authorize in Apps Script (clock icon > latest run > authorize).
- **Rate limits**: If throttled, increase `sleep(100)` to 500ms or run in batches (edit range to A2:A50).
- **Costs**: Monitor at [platform.openai.com/usage](https://platform.openai.com/usage); ~$0.00015/1K tokens.
- **Quota exceeded**: Use cheaper `gpt-4o-mini` or check OpenAI billing.
- Logs: **View > Logs** for errors. Test on 1 row first.

Total time: ~2-5 mins for 200 rows. Done! (298 words)