The Scenario
It's Thursday afternoon and you've spent the week saving links. Forty-three of them, collected across browser tabs, Slack bookmarks, and a notes app — all now living in a Google Sheet with columns for URL, title, and the short description you wrote while the article was still fresh in your head.
Your Curated newsletter goes out Friday morning. The draft is empty.
The bad version:
- Open Curated, click into the link collection, paste a URL, type or paste the title, type or paste the description, hit save, go back to the sheet, move down one row.
- Repeat that forty-three times, losing your place twice, submitting one URL to the wrong field, and realizing at row 38 that your descriptions are getting cut off at the character limit Curated enforces.
- Open the draft, add all forty-three links to the issue, arrange them into sections, realize you forgot three links that were on a second sheet tab, add those manually.
You're a newsletter editor. That's not editorial work. Nobody pays you to paste URLs.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads what's in your columns and, through its built-in Curated integration, talks directly to your publication. You tell it what to do; it handles the API calls.
Open the SheetXAI sidebar and paste this:
Take all URLs and titles in columns A and B of the "Links" tab and add them as collected links to my Curated publication, then create a draft issue containing all of them
What You Get
- Every row in columns A and B becomes a link entry in your Curated link collection — URL and title mapped correctly, descriptions from column C included if present.
- A new draft issue is created in your Curated publication with all submitted links assembled inside it, ready for you to write the editorial layer.
- Any rows where the URL is malformed or already exists in Curated are surfaced back in the sheet so you can review them without hunting through Curated's UI.
What If the Data Is Not Quite Ready
The descriptions are in a separate column and some cells are blank
Add all rows from the "Links" tab to my Curated publication — column A is the URL, column B is the title, column C is the description. If column C is blank, submit the link without a description rather than skipping the row.
Links from two different tabs need to go into the same draft
Combine all rows from the "Tech" tab and the "Culture" tab into a single Curated draft — column A is the URL and column B is the title in both tabs. Add all of them as collected links and create one draft issue.
Only include links that have been marked as ready
Add every row from the "Links" tab where column D says "confirmed" to my Curated publication, then create a draft issue with those links only. Skip any rows where column D is blank or says "draft."
Clean the URLs, deduplicate, and build the draft in one pass
Check the "Links" tab for duplicate URLs in column A and remove the duplicates. Then add every remaining row to my Curated publication using column A as the URL and column B as the title, and create a new draft issue with all of them assembled. Write "submitted" in column E for every row that goes through successfully.
The pattern is to describe the cleanup and the action together — one prompt handles both.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you collect your weekly links, then tell it to submit everything to Curated and build the draft. You can also pull your subscriber list into a sheet or export your issue performance history — see the other guides in this series.