← AI Revenue Experiment ・ 日本語版 ・ Toolkit details

"Does it actually run?" — here's the real script, and what it does

For solopreneurs, freelancers and small teams · no signup · check the product before you buy

"Includes a ready-to-run Google Apps Script" is easy to write. So here's the actual thing: the full source of Script #1 ("AI batch process") from the toolkit, plus a real Before→After of what it produces. Decide with the code in front of you.

What Script #1 does (in one line)

Take a column of text, send each row to the AI with your instruction, and write the result to the next column — up to 200 rows from one menu click. The "paste into ChatGPT every time" step disappears.

Demo #1: auto-classify incoming messages

The default instruction classifies each row as Complaint / Question / Request / Other. You change exactly one line:

INSTRUCTION: 'Classify this customer message as exactly one of Complaint / Question / Request / Other: {input}'

Paste messages into column A, click AI Tools → Process column A into B, and column B fills in:

※ Swap the labels for your own workflow (e.g. "Urgent / Normal / Hold", or "Lead score: High / Med / Low").

Demo #2: turn long notes into one-line summaries

Change only the instruction and the same script does a different job:

INSTRUCTION: 'Summarize this into one sentence using only stated facts. Do not speculate or exaggerate: {input}'

※ The "use only stated facts / don't exaggerate" constraint is deliberate — it curbs the AI's habit of confidently inventing details.

The full source of Script #1 (paste it as-is)

No hand-waving — this is the code that ships. A non-coder only touches the config block at the top (your API key, and the instruction you want to run).

const CONFIG = {
  API_KEY: 'PUT YOUR OpenAI API KEY (sk-...) HERE',  // ← change this only
  MODEL: 'gpt-4o-mini',                              // cheap and plenty; use 'gpt-4o' for max quality
  INSTRUCTION: 'Classify this message as one of Complaint / Question / Request / Other: {input}',
  INPUT_COL: 1,     // column A = input
  OUTPUT_COL: 2,    // column B = output
  START_ROW: 2,     // row 1 is a header, skipped
  MAX_ROWS: 200,    // max rows per run (runaway guard)
  TEMPERATURE: 0
};

function batchProcess() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const last = Math.min(sheet.getLastRow(), CONFIG.START_ROW + CONFIG.MAX_ROWS - 1);
  for (let row = CONFIG.START_ROW; row <= last; row++) {
    const input = sheet.getRange(row, CONFIG.INPUT_COL).getValue();
    const existing = sheet.getRange(row, CONFIG.OUTPUT_COL).getValue();
    if (!input || existing) continue;   // skip blanks & already-done rows (safe to re-run)
    const out = askAI(CONFIG.INSTRUCTION.replace('{input}', String(input)));
    sheet.getRange(row, CONFIG.OUTPUT_COL).setValue(out);
    Utilities.sleep(300);   // rate-limit friendly
  }
}

※ Excerpt. The shipped file also includes the menu (onOpen), the OpenAI call (askAI), an error path that writes "ERROR: …" into column B, and a completion toast. Script #2 emails a scheduled summary every morning, automatically.

Why this beats a plain prompt pack

• Already-done rows are skipped — stop halfway, click again, it resumes. No double charges.
• Runaway guard (MAX_ROWS) — a hard cap on rows per run.
• Runs in your account — your Google, your API key. Nothing is stored on our side.
• Copy-paste setup — a step-by-step guide covers getting an API key, pasting, and fixing common snags.

← AI Revenue Experiment ・ Toolkit details ・ 日本語版デモ