---
title: "Automatic WordPress Import from a URL on a Schedule (CSV, XML or Google Sheets)"
url: "https://wpimportexport.com/wordpress-scheduled-import-from-url/"
description: "Import a CSV, XML or Google Sheet into WordPress from its link and repeat it hourly or daily: existing posts are updated, new rows added, no duplicates. Free."
type: post
published: 2026-11-11T11:00:00+00:00
modified: 2026-11-14T10:43:37+00:00
categories: ["Import Guides", "Tutorials"]
tags: ["CSV import", "Import Export by RockStarLab", "WordPress automation"]
docs_topics: ["Bulk updates and automation", "Import guides"]
---

# Automatic WordPress Import from a URL on a Schedule (CSV, XML or Google Sheets)

Many sites get their content from a file that someone else keeps up to date: a booking system’s event list, a partner’s price list, a Google Sheet the team edits. [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) can import that file straight from its link and then do it again every hour, day or week, downloading the current version each time. Rows that already exist are updated, new rows are added, and nothing is duplicated. The example is a coffee roastery whose booking tool publishes its tasting events as a CSV file.

**Free:** import from a URL, schedules, updating existing posts and the AI agent abilities. Products, orders and other WooCommerce data need PRO; see [automatic supplier feed import for WooCommerce](https://wpimportexport.com/automatic-supplier-feed-import-woocommerce/).

## Short Answer

1. Go to **Import Export → Import**, choose the content type and, in step 2, paste the file’s link under **Or import a file from a URL**. Click **Fetch File**.
2. Map the columns and, in step 5, choose a field that identifies each row, such as **Slug**, with **If Match Found: Update**.
3. Run the import once and check the result.
4. Go to **Jobs Log → Schedules**, choose that job as the **Source Job**, set **Recurring** and **Daily** (or hourly, twice daily, weekly) and click **Add schedule**.

## What the link must be

The link has to return the file itself, not a web page that shows it: CSV, XML, JSON, XLSX, ODS, or a ZIP with one of them. The site must be able to reach it; addresses on a private network are refused. Some common sources:

- **Google Sheets:** in the sheet, choose **File → Share → Publish to web**, pick the tab and **Comma-separated values (.csv)**, and copy the link (see [Google’s help on publishing](https://support.google.com/docs/answer/183965)). We checked that a public Google Sheet link is downloaded as a CSV file with all its rows.
- **A booking, shop or inventory system** that offers a CSV or XML export link.
- **A file on your own server or storage** that another tool updates.

## Step 1: Import the file from its link

Our booking tool publishes the upcoming tastings with a slug, a title, a description and a status for each event:

```
post_name,post_title,post_content,post_status
tasting-ethiopia-guji,"Ethiopia Guji Tasting, November 14","Saturday, November 14, 11:00. Floral, peach and black tea. 8 seats.",publish
tasting-colombia-huila,"Colombia Huila Tasting, November 21","Saturday, November 21, 11:00. Caramel and red apple. 8 seats.",publish
tasting-kenya-nyeri,"Kenya Nyeri Tasting, November 28","Saturday, November 28, 11:00. Blackcurrant and grapefruit. 8 seats.",publish
```

In **Import Export → Import**, choose **Posts**, then paste the link in step 2:

![Import step 2 with the field Or import a file from a URL filled with a link to tastings.csv and a Fetch File button](https://wpimportexport.com/wp-content/uploads/2026/11/01-import-from-url.webp)

_Paste a direct link to the file and click Fetch File._

**Fetch File** downloads it and shows where it came from:

![Step 2 showing tastings.csv, 449 bytes, CSV, downloaded from the roastery's feed address](https://wpimportexport.com/wp-content/uploads/2026/11/02-file-downloaded.webp)

_The file is downloaded and the wizard shows where it came from._

In step 4, **Auto Map** matched all four columns, because they are named after WordPress fields. With other column names, map them by hand or apply a [saved mapping template](https://wpimportexport.com/save-reuse-field-mapping-templates-wordpress-import/).

## Step 2: Update rows that already exist

A repeated import must recognise the events it has already created. In step 5, set **Check for Existing Items by Field** to a value that stays the same for each row. We used **Slug**; a title works too if it never changes.

![Step 5 Import Options with Check for Existing Items by Field set to Slug, If Match Found Update and If No Match Found Create](https://wpimportexport.com/wp-content/uploads/2026/11/03-update-by-slug.webp)

_Match rows by slug so later runs update the same posts._

The first run created the three events:

![Import Completed Successfully with 3 successful, 0 updated, 3 created, 0 skipped and 0 failed](https://wpimportexport.com/wp-content/uploads/2026/11/04-first-import.webp)

_The first run created the three events._

## Step 3: Schedule it

Open **Jobs Log → Schedules**, name the schedule and choose the import you just ran as the **Source Job**. Each run makes a new job with the same settings and downloads the file again from the same link.

![Schedule form with the name Tasting events from the booking feed, source job #69 import post, Recurring, Daily and first execution on 9 November 2026 at 16:10](https://wpimportexport.com/wp-content/uploads/2026/11/05-daily-schedule.webp)

_A daily schedule made from the first import._

The schedule runs with WP-Cron, which starts on visits to your site. On a site with few visitors, a run can start later than planned; a real cron job on your host that calls `wp-cron.php` every few minutes makes the time exact.

## What happened at the next run

Before the first scheduled run, the booking tool’s file changed: the Colombia tasting sold out, the Kenya tasting moved to 12:00 and a Brazil tasting was added. The schedule ran at 16:10 and made job #70:

![Schedules list: Tasting events from the booking feed, source #69, Daily, next run 2026-11-10 16:10, last run 2026-11-09 16:10 with job #70, Active](https://wpimportexport.com/wp-content/uploads/2026/11/06-schedules-list.webp)

_After the first scheduled run: job #70, next run tomorrow._

The job read 4 rows: 3 matched existing events by slug and were updated, and 1 was created. Colombia now says “sold out” in the title, Kenya shows the new time, and Brazil Cerrado is a new post. The Ethiopia row had not changed, so its post stayed as it was. The site had four tasting posts, with no duplicates.

## When the file can’t be downloaded

Links sometimes fail: the source is being updated, the server is down or the file was moved. To see what happens, we removed the file before a run. The run didn’t start, and the schedule shows why:

![Schedules list with the status Active and the message Run on 2026-11-09 16:13 did not start: The file could not be downloaded (HTTP 404). It will try again at the next run.](https://wpimportexport.com/wp-content/uploads/2026/11/07-feed-down.webp)

_A failed download skips one run; the schedule stays active._

The schedule stays active and tries again at its next run, so one failed download doesn’t stop a daily import. Nothing on the site changes when the file can’t be read. If the reason doesn’t go away, fix the link or edit the schedule. A one-time schedule stops after a failed run. To be told about failed rows in jobs that did run, turn on [email or webhook alerts](https://wpimportexport.com/wordpress-import-email-webhook-alerts-failed-rows/).

## Removing rows

A scheduled import adds and updates; it doesn’t delete posts whose rows disappear from the file. To take an event down, keep its row and change its status, for example to `draft` or `private`.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) can set up the same import:

```
Import the tastings from https://www.example-roastery.com/wp-content/uploads/feeds/tastings.csv
as posts, update existing ones by slug, and repeat it every day at 7:00.
```

In our run, the agent downloaded the file with `rsl-ie/upload-from-url`, which returned 4 rows and the columns `post_name`, `post_title`, `post_content` and `post_status`. It started the import with `rsl-ie/import-start`, with `unique_field` set to `post_name` and `if_exists` set to `update`; the job processed 4 rows with no failures. It then made a daily schedule from that job with `rsl-ie/schedule-create`. We ran the schedule early to test it: its job downloaded the file again from the link and updated the same 4 posts without creating new ones. `rsl-ie/schedule-get` also returns `error_code` and `error_message` when a run could not start, so the agent can tell you why.

## Before you schedule it

A scheduled import changes content without anyone watching, so [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) first and run the import by hand once. Check that the identifying field really matches the existing posts: with the wrong field, every run would create new posts instead of updating them.

## FAQ

### Can I import a Google Sheet automatically?

Yes. Publish the tab as CSV with File → Share → Publish to web, paste that link in the import and schedule it. Your edits in the sheet reach the site at the next run.

### Does a scheduled import create duplicates?

No, if step 5 checks a field that identifies each row, such as the slug or the title, with If Match Found: Update. Existing posts are updated and only new rows create posts.

### How often can it run?

Hourly, twice daily, daily or weekly. The time depends on WP-Cron, so use a real cron job on low-traffic sites.

### What if the link doesn’t work at a run?

That run is skipped, Jobs Log → Schedules shows the reason, and the next run tries again.

### Does it delete posts that are no longer in the file?

No. Change the row’s status to draft or private instead.

## Related Guides

- [Save and Reuse Field Mapping Templates for Recurring WordPress Imports](https://wpimportexport.com/save-reuse-field-mapping-templates-wordpress-import/)
- [Get Email and Webhook Alerts When a WordPress Import Finishes (and Fix Failed Rows)](https://wpimportexport.com/wordpress-import-email-webhook-alerts-failed-rows/)
- [Automatic Supplier Feed Import for WooCommerce (Hourly or Daily)](https://wpimportexport.com/automatic-supplier-feed-import-woocommerce/)
- [Import a Large CSV (100k Rows) Without Crashing Your Site](https://wpimportexport.com/import-large-csv-wordpress-100k-rows/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
