Upwork Jobs to google sheets

## 🌐 **Section 1: Data Scraping Automation**

> 🧠 *“Tell me what’s trending!”*

### 🔁 Nodes Combined:

* 🕒 `Check Upwork Jobs - Trigger`
* 🌐 `Fetch Upwork Jobs from Apify`

---

### ⚙️ What This Section Does:

This section automates the process of **scraping fresh job listings from Upwork** using Apify.

### 🧩 Step-by-Step Breakdown:

#### 🕒 1. `Check Upwork Jobs - Trigger`

🕰 **Trigger Type**: Scheduled
This node automatically **starts the workflow at specific times** (e.g., every hour, daily, etc.).

📌 **Why this matters**:
You don’t have to manually run anything! Just set it once, and n8n will check for new job listings on its own — like a robot assistant.

---

#### 🌐 2. `Fetch Upwork Jobs from Apify`

📤 **HTTP Request** → **Apify API**

This node sends a `POST` request to [Apify](https://apify.com), where you've configured a **web scraping actor** to collect data from **Upwork job listings**.

📥 **Response**: A JSON array of job data, including:

* 📌 `title` – What the job is about
* 📝 `description` – A short job overview
* 🎯 `skills` – Required skills
* 🗓 `postedDate` – When it was posted
* 🔗 `link` – Direct link to the job

✅ **Why Apify?**
Because Upwork’s API is **not public**, Apify acts as your friendly bot that **scrapes the job board safely and returns structured data**.

💡 **Pro Tip**: You can customize your Apify actor to filter by keyword (e.g., `AI`, `Python`, `Design`, etc.).

---

## 📊 **Section 2: Data Transformation & Logging**

> 🧠 *“Let’s clean this up and put it somewhere useful.”*

### 🔁 Nodes Combined:

* ✏️ `Format Job Data`
* 📄 `Log Jobs to Google Sheets`

---

### 🧩 Step-by-Step Breakdown:

#### ✏️ 3. `Format Job Data`

🧹 **Field Cleaner / Formatter**

This node helps you:

* Extract only **relevant fields** from the Apify response
* Optionally **rename or restructure fields** (like mapping `postedDate` to `Date Posted`)
* Prepare the data in a clean format so it's ready for Google Sheets

📌 Example Output:

```json
{
  "Job Title": "Build AI chatbot",
  "Skills": "LangChain, Python",
  "Posted Date": "2025-06-06",
  "Link": "https://upwork.com/jobs/..."
}
```

💡 **Why This Matters**: Raw data isn’t always useful. This node ensures that what goes into Google Sheets is **clean, consistent, and human-readable**.

---

#### 📄 4. `Log Jobs to Google Sheets`

📑 **Append Data to Sheet**

This node takes the formatted job data and **adds it to a Google Sheet** row by row.

📌 Each job becomes a row with columns:

| Job Title    | Skills            | Posted Date | Link                                                    |
| ------------ | ----------------- | ----------- | ------------------------------------------------------- |
| Build AI Bot | Python, LangChain | 2025-06-06  | [https://upwork.com/jobs/](https://upwork.com/jobs/)... |

✅ **Why Use Google Sheets?**

* You can **analyze market trends** easily
* Share with your team
* Build charts, dashboards, or even connect to Looker Studio

💡 **Bonus Tip**: Add filters or conditional formatting to highlight certain keywords or top-paying jobs!

---

## 🎯 Why This Workflow is Powerful (Even for Beginners)

✅ **No coding required** – You’re using no-code tools like n8n, Apify, and Google Sheets
✅ **Automated** – Runs while you sleep 🌙
✅ **Real-time market insights** – Know what clients are looking for (great for freelancers, agencies, product devs)
✅ **Extendable** – Add Telegram alerts, Airtable dashboards, or link it with Notion or CRMs!

---

## 📌 What You Can Do Next:

| Task                      | Tool                              | Outcome                                   |
| ------------------------- | --------------------------------- | ----------------------------------------- |
| ✅ Add deduplication logic | Google Sheets or n8n `IF` node    | Avoid storing duplicate jobs              |
| ✅ Filter by skill/keyword | Apify task input                  | Focus on niche markets                    |
| ✅ Connect to Airtable     | Replace Sheets with Airtable node | Richer dashboards and tagging             |
| ✅ Set alerts              | Email/Telegram node               | Be the first to apply or inform your team |

---