The Scenario
You work on the product team at a food subscription company. Every week, the team finalizes the configuration for a "build your own box" option — 25 product names listed in an Excel workbook. Customers who choose this option need a shareable Instacart shopping page where they can grab everything in one click.
The person who used to generate these links left the company two months ago. Nobody wrote down how they did it. You're the third person this quarter to get handed the task.
The bad version:
- Dig through Slack history to find the last message from the person who left, hoping they mentioned the Instacart Developer Portal URL.
- Figure out which endpoint generates a shopping list page versus a recipe page versus a shoppable ingredient link — they're different.
- Manually construct the product array from the 25 items in the workbook. Submit the request. Copy the returned URL.
- Paste it somewhere so the customer-facing team can add it to the box configuration page. Hope you didn't transpose two product names.
This happens every week. It's a 30-minute task that nobody should own permanently.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the product list, calls the Instacart Developer Platform to generate a shopping list page from all 25 items, and writes the shareable URL directly into the workbook.
Take all items in my Excel 'Weekly Box Contents' sheet and generate one Instacart shopping list page — write the link to cell A1 so I can share it with customers.
What You Get
- Cell A1 of the Weekly Box Contents sheet contains a live, shareable Instacart shopping list URL that includes all 25 products.
- The link is ready to hand off to the customer-facing team immediately — no reformatting, no copying, no intermediate steps.
- If any product name is unrecognized or blank, SheetXAI notes which ones were excluded rather than silently dropping them.
What If the Data Is Not Quite Ready
Product names have inconsistent formatting
Some products are in all caps, some have trailing spaces, some use brand names that Instacart doesn't recognize.
Clean the product names in the Weekly Box Contents sheet by trimming whitespace, converting to title case, and removing brand prefixes in parentheses. Then generate a single Instacart shopping list page from the cleaned names and write the URL to cell A1.
You need separate shopping list pages for different box configurations
The workbook has three box configurations in separate columns. Each needs its own Instacart shopping page.
For each product list in columns A, C, and E of the Weekly Box Contents sheet, create a separate Instacart shopping list page. Write the URL for the column A list into cell B1, the column C list into cell D1, and the column E list into cell F1.
Some products are out of season and should be excluded this week
Column B has a flag: "include" or "exclude." Only the included rows should go into this week's shopping page.
In the Weekly Box Contents sheet, filter the product list to rows where column B says "include." Create an Instacart shopping list page from only those products and write the URL to cell C1.
Clean the product list, generate the page, and log the final product count in one pass
You need to tell the product manager exactly how many items made it into this week's link before it goes live.
Trim and clean all product names in the Weekly Box Contents sheet. Generate a single Instacart shopping list page from the cleaned list. Write the shopping page URL to cell A1. Write the count of products included to cell A2 and the count of any excluded or blank rows to cell A3.
The cleanup, the API call, and the count report land in one shot.
Try It
Get the 7-day free trial of SheetXAI and open your product or grocery list workbook, then ask it to build a shareable Instacart shopping page from the contents. Related: Generate Shoppable Instacart Links for Recipes and the Instacart integration overview.