Competitor Research Automation

// ===== Google Apps Script - Competitor Research DB ===== // Deploy as Web App (Execute as: Me, Access: Anyone) const SHEET_NAME = 'CompetitorData'; function doPost(e) { const data = JSON.parse(e.postData.contents); const sheet = SpreadsheetApp .getActiveSpreadsheet() .getSheetByName(SHEET_NAME); // Auto-create headers if sheet is empty if (sheet.getLastRow() === 0) { sheet.appendRow([ 'Timestamp', 'Source', 'Quadrant', 'Signal', 'UseCase', 'Frequency', 'RawText' ]); } // Save each signal row data.signals.forEach(signal => { sheet.appendRow([ new Date().toISOString(), data.source, signal.quadrant, signal.signal, signal.useCase, signal.frequency, signal.rawText ]); }); return ContentService .createTextOutput(JSON.stringify({status: 'OK', saved: data.signals.length})) .setMimeType(ContentService.MimeType.JSON); } function doGet(e) { const sheet = SpreadsheetApp .getActiveSpreadsheet() .getSheetByName(SHEET_NAME); const rows = sheet.getDataRange().getValues(); const headers = rows[0]; const data = rows.slice(1).map(row => { const obj = {}; headers.forEach((h, i) => obj[h] = row[i]); return obj; }); return ContentService .createTextOutput(JSON.stringify(data)) .setMimeType(ContentService.MimeType.JSON); }

// Make.com Scenario - Paste in Scenarios → Import { "name": "Competitor Research Auto", "flow": [ { "module": "schedule", "cron": "0 9 * * 1", // Every Monday 9am }, { "module": "http.request", "url": "https://api.apify.com/v2/acts/junglee~amazon-crawler/runs", "method": "POST", "body": { "startUrls": ["{{COMPETITOR_URL}}"], "maxItems": 100 } }, { "module": "http.request", "url": "https://api.anthropic.com/v1/messages", "method": "POST", "headers": { "x-api-key": "{{CLAUDE_API_KEY}}" }, "body": { "model": "claude-sonnet-4-20250514", "messages": [{ "role": "user", "content": "Analyze these reviews: {{REVIEWS_DATA}}" }] } }, { "module": "http.request", "url": "{{GOOGLE_APPS_SCRIPT_URL}}", "method": "POST", "body": "{{CLAUDE_RESPONSE}}" } ] }