Lead Magnet Generation

# 🚀 Lead Magnet Idea Generation Workflow

## 🧩 Purpose
Automatically generates **lead magnet content ideas** based on a Google Sheet containing topics and website URLs. It checks for rows where content is missing and fills it using an AI API.

---

## ✅ Problem Solved

| ❌ Problem                            | ✅ Solution                                                                 |
|--------------------------------------|-----------------------------------------------------------------------------|
| Manual content idea generation       | Automatically generates using a Lead Magnet AI API                          |
| Missing content in sheet rows        | Detects missing "Content" and fills it intelligently                        |
| No record of when ideas were created | Appends current date/time on content creation                               |
| Repeated manual checks               | Uses Google Drive Trigger to monitor changes every minute                   |

---

## 🔄 Workflow Overview

```mermaid
graph TD
    A[Google Drive Trigger] --> B[Google Sheets1 (Read Data)]
    B --> C[Loop Over Items]
    C --> D{If: Topic not empty AND Content empty?}
    D -->|Yes| E[HTTP Request (Generate Content)]
    E --> F[Google Sheets2 (Write Data)]
    F --> G[Wait (10s)]
    G --> C
    D -->|No| C