The Scenario
It's Wednesday afternoon and you've been collecting article links all week in a Google Sheet — the "Content Queue" tab, forty rows by now, each with a URL in column A, a title in column B, and a short description in column C. The newsletter goes out Friday. You need all forty of these in Goodbits before you can start building the issue.
The bad version:
- Open Goodbits, click "Add content link," paste the URL from row 1, tab over to fill in the title, paste the description, click save, go back to the sheet, move to row 2
- Lose track around row 18, scroll up to verify which ones already have a "done" note, realize you forgot to mark some
- Spend 45 minutes on mechanical entry that could have been a single instruction
The thing is, your job is to curate the content — not to operate the import interface. That time belongs to writing, to selecting the best pieces, to actually building the issue. Not to forty identical form submissions.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the "Content Queue" tab, understands the column structure, and talks to Goodbits on your behalf. You describe the task; it does the rows.
For each URL in column A of the "Content Queue" tab, create a Goodbits content link using the article title in column B and the description in column C — write "done" into column D if it succeeds, "error" if it fails
What You Get
- A Goodbits content link created for each row where column D was blank at the start of the run
- Column D updated to "done" for each successful link and "error" for any that failed — so you can see at a glance which ones need attention
- The Goodbits content library refreshed and ready to use when you open it to build the issue
What If the Data Is Not Quite Ready
The descriptions in column C are inconsistent lengths
For each URL in column A of "Content Queue," create a Goodbits content link using column B as the title and column C as the description — if column C has more than 200 characters, trim it to the first sentence before sending, and write the result into column D
Some rows are missing a title
For each URL in column A of "Content Queue," create a Goodbits content link — if column B is blank, use the domain name from the URL as the title — use column C for the description, write "done" or "error" into column D
You want to join a "Category" column from a second tab before pushing
Look up the category for each URL in column A of "Content Queue" by matching the domain against column A of "Categories" tab — then create a Goodbits content link for each row using the category as a tag, title from column B, description from column C, result into column D
Clean up duplicates, confirm freshness, then push in one shot
In "Content Queue," find any rows where column A has a URL that already appears in column D of "Archive" — mark those as "duplicate" in column D and skip them — for the remaining rows, create Goodbits content links using columns B and C and write "done" or "error" into column D
The pattern: describe the guard conditions and the action together. SheetXAI handles both in one pass.
Try It
Get the 7-day free trial of SheetXAI and open your content curation sheet, then ask it to push this week's link queue into Goodbits in one go. You can also see how it handles importing subscribers from a sheet or get an overview in the Goodbits integration hub.