Import Dev.to Job Listings Into a Google Sheet

The Scenario

A technical recruiter at a fintech startup is building compensation bands for three open engineering roles. Her process involves benchmarking against current market listings before she sets the ranges. She uses DEV Community job listings as one of her sources because the signal quality is high — these are developer-posted, developer-read roles.

The DEV jobs listing doesn't have a download button. There's no export. She can filter by tag. She cannot sort by anything useful.

The bad version:

Open DEV Community listings filtered to the jobs category. Read the first listing. Note the title, salary range if listed, tech stack mentioned, and location. Type it into the sheet.
Reload the page because the listing page paginates and the URL doesn't preserve your position.
Spend 40 minutes doing this and end up with 25 listings, which isn't enough to set a compensation band with any confidence.

Setting comp without enough market data is a guess. And the data that would make it less of a guess is sitting on a web page she has no way to download.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It connects to the Dev.to API and can pull all current listings from the jobs category — titles, descriptions, tags, and poster metadata — directly into your sheet in one pass.

Open the SheetXAI sidebar and paste:

Fetch all job listings from DEV Community's 'jobs' category and write them to the DevJobListings sheet — job title in column A, body excerpt (first 200 characters) in column B, tags in column C, author username in column D, published date in column E.

What You Get

One row per job listing in DevJobListings.
Columns A–E populated with title, description excerpt, tags, poster, and published date.
All available listings returned — not just the first page.
Raw data ready for filtering, sorting, and compensation analysis without any additional cleanup.

What If the Data Is Not Quite Ready

You only want listings tagged with a specific technology

You're hiring for Go and Rust engineers specifically. Most listings are irrelevant.

Fetch DEV Community job listings tagged with 'go' or 'rust' and write them to DevJobListings — title in A, tags in B, body excerpt (first 300 characters) in C, author in D, published date in E.

Some body excerpts are cutting off mid-sentence

The 200-character truncation is leaving some rows with partial sentences that are hard to read.

Fetch all DEV Community job listings and write to DevJobListings — title in A, full body text in B, tags in C, author in D, published date in E. Truncate column B to the first complete sentence that falls within 400 characters rather than cutting mid-word.

You want to extract salary ranges from the body text

Some listings mention salary ranges inline. You want those pulled into a separate column for the comp analysis.

Fetch all DEV Community job listings into DevJobListings — title in A, body in B, tags in C. In column D, extract any salary or compensation range mentioned in column B (e.g., "$120k-$160k", "€80,000", "120,000 USD") using a pattern match. Leave column D blank if no salary is mentioned.

Pull listings, filter by tech stack, extract salary, and rank by recency

You need a clean analyst-ready table: only listings from the past 30 days, filtered to roles mentioning Python or TypeScript, with salary extracted where present, sorted newest first.

Fetch all DEV Community job listings published in the last 30 days. Filter to rows where the body or tags mention 'python' or 'typescript'. Write results to DevJobListings — title in A, tags in B, published date in C, extracted salary range in D (or "not listed" if absent), body excerpt in E. Sort by published date descending.

One prompt produces the analysis-ready table. The comp bands get set from actual data rather than from 25 hand-copied rows.

Try It

Get the 7-day free trial of SheetXAI and open a Google Sheet set up for compensation benchmarking or market research — then ask SheetXAI to pull all current DEV Community job listings with salary extraction already applied. The Dev.to integration is included in every SheetXAI plan.