Skip to main content

trigger-chains Scenario 2 — Scrape Jobs → Transform → PostgreSQL → Email

Written by RTILA X Engineering Team

Beginner ~4 min

What You'll Learn

Create a simple two-step trigger chain

Real-World Use Case

Saving scraped data and sending via email
LIVE DEMO

Job Table Extraction

Scrape job postings for a transform-and-insert trigger chain.

Database Insert Pipeline

TitleCompanySalary
Senior Frontend Engineer BrightPixel Labs $120,000 - $155,000
Full Stack Developer CodeCraft $110,000 - $140,000
Backend Engineer (Go) ScaleWorks $130,000 - $160,000
DevOps Engineer CloudNest $125,000 - $150,000
Mobile Developer (Flutter) AppWise $105,000 - $135,000
QA Automation Engineer TestBridge $95,000 - $120,000

6 records ready for PostgreSQL insert

EXPECTED OUTPUT

Jobs

id title company location salary type posted description requirements url
1 Senior Frontend Engineer BrightPixel Labs Remote $120,000 - $155,000 Full-time 2025-01-03 Build modern Vue and React interfaces for a growing SaaS product. 5+ years frontend experienceVue 3 or ReactTypeScriptCSS architecture /scenarios/ecommerce/jobs/1
2 Full Stack Developer CodeCraft New York, NY $110,000 - $140,000 Full-time 2025-01-06 Work across the stack to ship features for our automation platform. 3+ years full stackNode.jsPostgreSQLCloud deployment /scenarios/ecommerce/jobs/2
3 Backend Engineer (Go) ScaleWorks Remote $130,000 - $160,000 Full-time 2025-01-09 Design and maintain high-throughput APIs powering millions of requests. GogRPCKubernetesObservability /scenarios/ecommerce/jobs/3
4 DevOps Engineer CloudNest Austin, TX $125,000 - $150,000 Full-time 2025-01-11 Own CI/CD pipelines and infrastructure automation for a growing platform. AWS or GCPTerraformGitHub ActionsMonitoring /scenarios/ecommerce/jobs/4
5 Mobile Developer (Flutter) AppWise Remote $105,000 - $135,000 Full-time 2025-01-13 Create polished cross-platform mobile experiences for iOS and Android. FlutterDartREST APIsCI/CD /scenarios/ecommerce/jobs/5
6 QA Automation Engineer TestBridge Chicago, IL $95,000 - $120,000 Full-time 2025-01-15 Build test automation frameworks for E2E releases and regression suites. Playwright or CypressJavaScript/TypeScriptCI integration /scenarios/ecommerce/jobs/6
RTILA X PROJECT JSON

RTILA X Automation Project

scrape-jobs-transform-postgresql.json 
{
  "name": "Scrape_Jobs_For_DB",
  "settings": {
    "urls": [
      "https://learn.rtila.com/scenarios/trigger-chains/2"
    ]
  },
  "datasets": {
    "jobs": {
      "item_selector": "css=table.job-data tbody tr",
      "properties": [
        {
          "name": "title",
          "type": "text",
          "selector": "css=td:nth-child(1)"
        },
        {
          "name": "company",
          "type": "text",
          "selector": "css=td:nth-child(2)"
        },
        {
          "name": "salary",
          "type": "text",
          "selector": "css=td:nth-child(3)"
        }
      ]
    }
  }
}

Trigger Chain Configuration

  • transform — normalizes salary strings and prepared columns.
  • postgresql — inserts the transformed rows into a database table.
  • send_email — sends a summary email after the database write.

Trigger chains are configured in the RTILA X UI, not via project JSON. The AI assistant can discuss them but cannot generate trigger chain configurations.

Database insertion patterns often rely on a transform step before the final insert. The trigger chain handles the transformation and sends an email when the operation completes.

Did you complete this scenario?

Ready to run this automation?

Copy the project JSON above, open RTILA X, create a new project, and paste it.

Download RTILA X Free → View setup guide →

This scenario covers 1 RTILA X command and is referenced in 1 learning article.

Continue Learning

Was this helpful?