# Import from a link

> Import from a Google Sheet with an optional daily sync, one product page, a whole store address, or a queue of many product links.

Source: https://docs.personacart.com/commerce/import-from-a-link

In short: {"Import from a Google Sheet with an optional daily sync, one product page, a whole store address, or a queue of many product links."}

The **From a link** tab holds four tools that start from an address instead of a file: a Google Sheet, one product page, a store address, and a queue for many product links.

1. Open **Commerce → Import / Export**. If you see a spreadsheet picker, open **Shop items and other stores**, then tab **From a link**.
2. Paste a Google Sheet link, a product page address or a store address.
3. Check the preview, then press the import button.

## Where to find it

Sidebar → COMMERCE → Import / Export, tab **From a link**. On an Academy store, open **Shop items and other stores** first to see the tabs.

## Import from a Google Sheet

1. Share your sheet as **"Anyone with the link can view"** (in Google Sheets: Share, General access).
2. Under **Import from a Google Sheet** choose **Products** or **Customers**.
3. Paste the link into **Paste the Google Sheet link here** and press **Check the sheet**.
4. [The import page](/commerce/import-job) opens with a preview. Check it and press the import button.

A private sheet cannot be read; the message says to check the link and sharing. Products arrive as drafts.

- **Update from this sheet every day.** After an import from a sheet, turn this switch on.
- Once a day PersonaCart re-checks the sheet, updates anything that changed and adds anything new as a draft.
- Nothing is ever deleted.
- The card shows **Last run** (updated successfully, blocked, or ran into an error) and **Next run**, and **Run now** starts a sync straight away.
- If three tries in a row fail, the sync is paused and the reason is shown.

## Import a product from a page (with AI)

Under **Import a product with AI**, press **Start import** and paste a product page address (works best with Shopify and WooCommerce product links). PersonaCart checks what the page is first:

- A product page: "we'll create a sellable product, with its product page", including variants and images re-hosted on your store.
- A shop or category page: refused, because importing a list creates an empty product. Open a single product and paste its own link.
- A page the site blocks: try the product's own link, or add the product by hand.
- A page, not a product: use **Copy a page instead** (New Page → Copy a page) to clone it as an editable page.

Press **Import as product**. It usually takes under a minute. When it finishes, **Product created** shows the product page and buttons **Open product** and **View product page**, with "A few things to finish" if something needs your attention. Check the price and details straight away.

## Import products from a store address

- **Import products from a store**: type a public store address (for example `https://yourstore.com`), press **Import products**, and PersonaCart detects the platform (Shopify, WooCommerce, Squarespace or any store with product pages) and brings the products in as drafts.
- When it finishes: "Imported N products as drafts" with **View products**.
- If the address is not a public storefront you get an error.

For connected, private access to your own store, use [Shopify](/commerce/import-from-shopify), [WooCommerce](/commerce/import-from-woocommerce) or [Squarespace](/commerce/import-from-squarespace) instead.

## Import products from URLs (queue)

- **Import products from URLs**: paste one or many product page links, one per line, and press **Add to queue** (or **Queue N URLs**).
- Lines that are not valid links are skipped and counted.
- Each link is imported in the background and PersonaCart emails you as each one finishes.
- A limited number run at a time, and you can close the page.
- An imported product arrives already **Published** and visible, so open it with **View product** and check the price and photos straight away.

- The **Import queue** lists everything you sent, newest first, with a status: **Queued** (with "#N in queue" and an estimate), **Importing**, **Imported** (with **View product**), **Failed** (with **Retry** and the number of attempts) or **Cancelled**.
- **Cancel** stops one queued import.
- Paste a link you already sent and press **Add to queue**: it shows **Already queued**.
- If you paste a page rather than a product, you are pointed to Copy a page.

## Questions
