Automation Script for Web Content Extraction

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.