Walmart grocery prices — US pickup · no login

What is Walmart grocery prices — US pickup · no login?

Search public Walmart grocery pickup results and save product title, brand, USD price, stock status, and item URL.

• The sample query is milk
• Results use the public pickup facet, not a logged-in account
• Download JSON, CSV, Excel, or HTML, or send the rows to Sheets, BI tools, n8n, Make, or Zapier

Documentation

What grocery data can I scrape?

Field	What it is	Example
productId	Walmart item id	46942839
title	Product name	Crystal Creamery Whole Milk Gallon
brand	Brand	Crystal Creamery
price	Current price	5.26
currency	ISO currency	USD
availability	Stock flag	IN_STOCK
fulfillmentType	Pickup vs ship	STORE
url	Item page	https://www.walmart.com/ip/...
sourceUrl	Search page used	https://www.walmart.com/search?q=milk
scrapedAt	When this run saved the row	2026-10-03T17:00:00.000Z

How do I scrape Walmart grocery pickup items?

1. Click Try for free.
2. Keep Search query on milk or type bananas, eggs, or another grocery term.
3. Set Maximum products. The sample stops at 5.
4. Click Start.
5. Open the dataset and download it, or send it on with one of the integrations below.

The run keeps the first matches, up to Maximum products.

Saved runs on the Tasks tab:

• Milk pickup sample
• Bananas pickup sample
• Eggs pickup sample

Input

{
    "searchQuery": "milk",
    "maxItems": 5
}

The Input tab lists every field.

Output

Rows are in the dataset on the Output tab. scrapedAt changes with each run.

How much does a Walmart grocery scrape cost?

You pay for each product row saved. Platform usage is included. Current rates are on the Pricing tab.

How pay-per-event billing works: Actors in Store.

Integrations

Excel

1. Click Try for free, run the lookup, and wait until the run finishes.
2. Open that run and go to its dataset.
3. Choose Export, then Excel.

To download the newest successful run later without opening the dataset:

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. On this Actor, open the Tasks tab, open the task you want, and copy the task ID from the URL.
3. Run that task once.
4. Paste this into a browser. Replace TASK_ID and YOUR_TOKEN.

https://api.apify.com/v2/actor-tasks/TASK_ID/runs/last/dataset/items?format=xlsx&clean=true&status=SUCCEEDED&token=YOUR_TOKEN

Anyone with that URL can read the rows. Treat the token like a password.

Dataset export formats: Dataset items.

Google Sheets

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. On this Actor, open the Tasks tab, open the task you want, and copy the task ID from the URL.
3. Run that task once so there is a successful dataset.
4. In a Google Sheet, click cell A1 and paste this formula. Replace TASK_ID and YOUR_TOKEN.

=IMPORTDATA("https://api.apify.com/v2/actor-tasks/TASK_ID/runs/last/dataset/items?format=csv&clean=true&status=SUCCEEDED&token=YOUR_TOKEN")

5. Wait until the columns fill. Sheets refreshes IMPORTDATA on its own. Use Data → Data connectors → Refresh when you want it now.

Anyone with that URL can read the rows. Treat the token like a password.

API, Python, and Node

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. Send this request. Replace YOUR_TOKEN.

curl -X POST "https://api.apify.com/v2/acts/bakos_bence~walmart-grocery-products/runs?token=YOUR_TOKEN&waitForFinish=120" \
  -H "Content-Type: application/json" \
  -d '{"searchQuery":"milk","maxItems":5}'

3. From the response, copy defaultDatasetId.
4. Fetch the rows:

https://api.apify.com/v2/datasets/DATASET_ID/items?format=json&clean=true&token=YOUR_TOKEN

The API tab on this page has the same call in JavaScript, Python, and the CLI. Client docs: JavaScript, Python, Run an Actor.

Zapier

1. In Apify Console, open Settings → API & Integrations and copy an API token. You will only need it if the connection asks for a token. The usual path is the access prompt below.
2. In Zapier, create a Zap. For the action, search Apify and choose Run Actor.
3. Connect your Apify account and choose Allow Access.
4. Select Walmart Grocery Pickup Products Scraper.
5. Paste this input:

{
    "searchQuery": "milk",
    "maxItems": 5
}

6. Use a synchronous run only when the lookup will finish within 30 seconds. Otherwise leave it asynchronous, then add Fetch dataset items, or start the Zap with the Finished Actor run trigger.
7. Test the step. Add the next action, such as Google Sheets, Slack, or email. Publish the Zap.

Triggers and the other actions: Zapier integration.

Make

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. In a Make scenario, add a module and search Apify.
3. Create the connection with OAuth, or paste the API token.
4. Choose Run an Actor. Select Walmart Grocery Pickup Products Scraper. Set Run synchronously to Yes.
5. Paste this input:

{
    "searchQuery": "milk",
    "maxItems": 5
}

6. Add Get Dataset Items. Set the dataset ID to the default dataset ID from the Run an Actor module.
7. Add the module that should receive the rows, such as Google Sheets Bulk add rows, and map the fields.

If the run can take longer than your Make plan lets a synchronous module wait, start with Watch Actor Runs instead, then add Get Dataset Items. Details: Make integration.

n8n

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. On n8n Cloud, open the nodes panel, search Apify, and install the node. On a self-hosted n8n, go to Settings → Community Nodes → Install and enter @apify/n8n-nodes-apify.
3. Create a credential. Search Apify API, paste the token, and save. On n8n Cloud you can use Apify OAuth2 instead.
4. Add an Apify node. Choose Run Actor. Pick Walmart Grocery Pickup Products Scraper. Turn on Wait for finish.
5. Set the input to:

{
    "searchQuery": "milk",
    "maxItems": 5
}

6. Add another Apify node, Get Dataset Items. Set the dataset ID to the defaultDatasetId from the Run Actor node.
7. Add the next node, such as Google Sheets, and map the fields.

Full setup, triggers, and the AI-tool node: n8n integration.

Power BI

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. On this Actor, open the Tasks tab, open the task you want, and copy the task ID from the URL.
3. Run that task once.
4. Open Power BI Desktop → Home → Get data → Web.
5. Paste this URL. Replace TASK_ID and YOUR_TOKEN.

https://api.apify.com/v2/actor-tasks/TASK_ID/runs/last/dataset/items?format=csv&clean=true&status=SUCCEEDED&token=YOUR_TOKEN

6. When asked how to sign in, choose Anonymous → Connect.
7. Check that the preview is a table, then Load.
8. After you publish, schedule refresh against that same URL.

A 401 means the token is missing or you did not choose Anonymous. Anyone with the URL can read the rows.

Looker Studio

Looker Studio does not open a private CSV URL on its own. Put the rows in a Google Sheet first.

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. On this Actor, open the Tasks tab, open the task you want, and copy the task ID from the URL.
3. Run that task once.
4. In a Google Sheet, click cell A1 and paste this formula. Replace TASK_ID and YOUR_TOKEN.

=IMPORTDATA("https://api.apify.com/v2/actor-tasks/TASK_ID/runs/last/dataset/items?format=csv&clean=true&status=SUCCEEDED&token=YOUR_TOKEN")

5. Wait until the columns fill.
6. In Looker Studio, choose Create → Report → Google Sheets and pick that spreadsheet.
7. After the next run, refresh the Sheet, then refresh the Looker data source.

For a single snapshot, open the finished run, export CSV from the dataset, and use File upload in Looker Studio.

Tableau

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. On this Actor, open the Tasks tab, open the task you want, and copy the task ID from the URL.
3. Run that task once.
4. In Tableau Desktop 2023.3+, install the REST API connector from Tableau Exchange.
5. Choose Connect → To a Server → REST API.
6. Paste this URL. Replace TASK_ID and YOUR_TOKEN. Set the response format to CSV.

https://api.apify.com/v2/actor-tasks/TASK_ID/runs/last/dataset/items?format=csv&clean=true&status=SUCCEEDED&token=YOUR_TOKEN

7. Leave credentials empty. The token is already in the URL.
8. Create an extract. Refresh it after the next run.

For a single snapshot, open the finished run, export CSV from the dataset, and connect Tableau to that file.

Qlik

1. In Apify Console, open Settings → API & Integrations and copy an API token.
2. On this Actor, open the Tasks tab, open the task you want, and copy the task ID from the URL.
3. Run that task once.
4. In Qlik Cloud or Qlik Sense, choose Add data → REST.
5. Set the method to GET and paste this URL. Replace TASK_ID and YOUR_TOKEN.

https://api.apify.com/v2/actor-tasks/TASK_ID/runs/last/dataset/items?format=csv&clean=true&status=SUCCEEDED&token=YOUR_TOKEN

6. Set the response type to CSV.
7. Test the connection, pick the table, and load.
8. Reload the app after the next run.

For a single snapshot, open the finished run, export CSV from the dataset, and add that file in Qlik.

Webhooks

1. In Apify Console, open this Actor and go to Integrations.
2. Add a webhook for Actor run succeeded.
3. Set the URL of the service that should receive the run.
4. When a run finishes, the payload includes defaultDatasetId. Read the rows with this URL. Replace DATASET_ID and YOUR_TOKEN. The token is under Settings → API & Integrations.

https://api.apify.com/v2/datasets/DATASET_ID/items?format=json&clean=true&token=YOUR_TOKEN

Event types and the payload: Webhooks.

AI tools

1. Open the API tab on this Actor.
2. Copy the MCP config shown there.
3. Paste it into the MCP client (Claude, Cursor, or another client that accepts that config).
4. Sign in when the client asks. It can then run this lookup.

Setup for each client: Apify MCP server.

Airtable, Google Drive, Slack, and Snowflake are listed in Integrations.

FAQ

Is this the full Walmart marketplace?

No. The default path is grocery pickup search on walmart.com.

Can I schedule this?

Yes. Save a Task from the input you want, then add a schedule in Console.

This Actor is not run by Walmart. It is unofficial and not affiliated with Walmart Inc.