Automation Script for Web Content Extraction
Publicada el 2026-07-31
Descripción de la oferta
Description: Need a small automation task built using Google Sheets + Apps Script + Gemini API (paid tier). Input: Google Sheet with 22,000 rows. Column F has company website URLs. What's needed: Script that visits each website URL (Column F), extracts text content. Sends extracted text to Gemini API (structured JSON output) to generate: Company summary (100-150 words) Personalized first cold email (60-70 words) — fixed template with variable opening line Personalized follow-up email (30 words) — fixed template with variable opening line Short catchy subject line (3-4 words, personalized) Outputs go into 4 separate columns without breaking formatting (clean text, no stray line breaks/commas that would break CSV export). Handle failed/blocked websites gracefully (use Google Search grounding fallback, don't leave blank or hallucinate). Final deliverable: working script + fully populated sheet + clean CSV export ready for Instantly.ai import (custom variable columns properly structured). I will provide: API key, email template structure (fixed CTA/body, personalization points), and the Google Sheet.
Skills
Fuente original: freelancer