Turn new posts from a site you follow into Trello cards

Every six hours, the feed you follow is fetched, whether a release feed, a job board, a regulator's notices or a blog, and each new item becomes one Trello card on the board and list you name. The card carries the item's own title and link and nothing else.

You end up with a list that fills itself with what is new, once and only once. Every title and link the AI picks out is checked back against the feed word for word, and anything not found there is dropped and counted, so no card is ever made from an invented headline. Each item carded is logged to a tab in your spreadsheet, and that log is read before any card is made. If the log cannot be read, the run stops without creating anything rather than recreating the whole feed.

Before the first run you need the feed address, a Trello board and list named exactly as they appear in Trello, and a spreadsheet with a log tab that has a column headed 'Link'.

Run every 6 hours.Run every 6 hours.

Set feedUrl to blank.Set feedUrl to blank.

Set trelloBoardName to blank.Set trelloBoardName to blank.

Set trelloListName to blank.Set trelloListName to blank.

Set logSpreadsheetUrl to blank.Set logSpreadsheetUrl to blank.

Set logTabName to Feed log.Set logTabName to Feed log.

Set maxCardsPerRun to 10.Set maxCardsPerRun to 10.

Set feedText to blank.Set feedText to blank.

Set feedReached to false.Set feedReached to false.

Set failureNote to blank.Set failureNote to blank.

If a step below fails, save the error as fetchErrorIf a step below fails, save the error as fetchError

Try

Fetch feedUrl and save it as response.Fetch feedUrl and save it as response.

Change feedReached to response.ok.Change feedReached to response.ok.

Trim response.body and save it as feedText.Trim response.body and save it as feedText.

On error

Replace feedUrl with the feed address in fetchError.message and save it as failureNote.Replace feedUrl with the feed address in fetchError.message and save it as failureNote.

If failureNote contains :// (ignoring case)If failureNote contains :// (ignoring case)

Yes

Change failureNote to it could not be reached.Change failureNote to it could not be reached.

No

No steps

Get the first item of feedUrl with https:// replaced by with http:// replaced by split by / and save it as feedHost.Get the first item of feedUrl with https:// replaced by with http:// replaced by split by / and save it as feedHost.

If feedReached is no or feedText is emptyIf feedReached is no or feedText is empty

Yes

Stop and report a problem: Nothing could be read from the feed at feedHost. failureNote.Stop and report a problem: Nothing could be read from the feed at feedHost. failureNote.

No

No steps

TrelloList your boards. Save it as boards.List your boards. Save it as boards.

Set trelloBoardId to blank.Set trelloBoardId to blank.

For each board in boards.boards:For each board in boards.boards:

If board.name is trelloBoardNameIf board.name is trelloBoardName

Yes

Trim board.id and save it as trelloBoardId.Trim board.id and save it as trelloBoardId.

No

No steps

If trelloBoardId is emptyIf trelloBoardId is empty

Yes

Stop and report a problem: No Trello board is named exactly '@trelloBoardName'. Check the 'trelloBoardName' step against the board's name in Trello.Stop and report a problem: No Trello board is named exactly '@trelloBoardName'. Check the 'trelloBoardName' step against the board's name in Trello.

No

No steps

TrelloList the lists on trelloBoardId. Save it as lists.List the lists on trelloBoardId. Save it as lists.

Set trelloListId to blank.Set trelloListId to blank.

For each boardList in lists.lists:For each boardList in lists.lists:

If boardList.name is trelloListNameIf boardList.name is trelloListName

Yes

Trim boardList.id and save it as trelloListId.Trim boardList.id and save it as trelloListId.

No

No steps

If trelloListId is emptyIf trelloListId is empty

Yes

Stop and report a problem: The board '@trelloBoardName' has no list named exactly '@trelloListName'. Check the 'trelloListName' step.Stop and report a problem: The board '@trelloBoardName' has no list named exactly '@trelloListName'. Check the 'trelloListName' step.

No

No steps

Set loggedLinks to an empty list.Set loggedLinks to an empty list.

Set logReadable to false.Set logReadable to false.

If a step below fails, save the error as logErrorIf a step below fails, save the error as logError

Try

Google SheetsRead the rows of logSpreadsheetUrl. Save it as log.Read the rows of logSpreadsheetUrl. Save it as log.

Change logReadable to true.Change logReadable to true.

For each logRow in log.rows:For each logRow in log.rows:

Trim logRow.Link and save it as loggedLink. Trim logRow.Link and save it as loggedLink.

If loggedLink isn't empty If loggedLink isn't empty

Yes

Add loggedLink to the end of loggedLinks and save it as loggedLinks.Add loggedLink to the end of loggedLinks and save it as loggedLinks.

No

No steps

On error

Show in the output: The log tab could not be read, so no cards were made this run..Show in the output: The log tab could not be read, so no cards were made this run..

If logReadable is noIf logReadable is no

Yes

Stop and report a problem: The log tab '@logTabName' could not be read, so there is no way to tell which items have already been carded. Create that tab with a column headed Link and run it again. No cards were made.Stop and report a problem: The log tab '@logTabName' could not be read, so there is no way to tell which items have already been carded. Create that tab with a column headed Link and run it again. No cards were made.

No

No steps

Set prompt to The text below is the raw source of a feed. List the newest items in it, one per line, as: title ||| linkSet prompt to The text below is the raw source of a feed. List the newest items in it, one per line, as: title ||| link Copy the title and the link exactly as they appear in the text. Do not invent, complete, tidy or translate either of them, and do not add items that are not in the text. If the text holds no items at all, reply with the single word NONE. Feed source: feedText truncated to 6000 characters.

Set answerText to blank.Set answerText to blank.

If a step below fails, save the error as readItemsErrorIf a step below fails, save the error as readItemsError

Try

Trim the response text from the Claude “Ask Claude” step and save it as answerText.Trim the response text from the Claude “Ask Claude” step and save it as answerText.

On error

Show in the output: The step that lists the feed's items did not answer this run..Show in the output: The step that lists the feed's items did not answer this run..

If answerText is emptyIf answerText is empty

Yes

Stop and report a problem: The step that lists the items in the feed at feedHost did not answer this run, so no cards were made.Stop and report a problem: The step that lists the items in the feed at feedHost did not answer this run, so no cards were made.

No

No steps

Set cardsCreated to 0.Set cardsCreated to 0.

Set itemsRejected to 0.Set itemsRejected to 0.

For each answerLine in answerText split by a new line:For each answerLine in answerText split by a new line:

Trim answerLine and save it as entry.Trim answerLine and save it as entry.

If entry is emptyIf entry is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

If cardsCreated is greater than or equal to maxCardsPerRun multiplied by 1If cardsCreated is greater than or equal to maxCardsPerRun multiplied by 1

Yes

Stop repeating.Stop repeating.

No

No steps

Split entry by ||| and save it as parts.Split entry by ||| and save it as parts.

If the length of parts is less than 2If the length of parts is less than 2

Yes

Skip to the next item.Skip to the next item.

No

No steps

Trim the first item of parts and save it as itemTitle.Trim the first item of parts and save it as itemTitle.

Trim the last item of parts and save it as itemLink.Trim the last item of parts and save it as itemLink.

If itemTitle is empty or itemLink is emptyIf itemTitle is empty or itemLink is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

If itemLink doesn't start with http (ignoring case)If itemLink doesn't start with http (ignoring case)

Yes

Add 1 to itemsRejected.Add 1 to itemsRejected.

Skip to the next item.Skip to the next item.

No

No steps

If feedText doesn't contain itemTitle (ignoring case) or feedText doesn't…If feedText doesn't contain itemTitle (ignoring case) or feedText doesn't…

Yes

Add 1 to itemsRejected.Add 1 to itemsRejected.

Skip to the next item.Skip to the next item.

No

No steps

If loggedLinks contains itemLinkIf loggedLinks contains itemLink

Yes

Skip to the next item.Skip to the next item.

No

No steps

TrelloAdd the card '@itemTitle truncated to 240 characters' to trelloListId. Save it as createdCard.Add the card '@itemTitle truncated to 240 characters' to trelloListId. Save it as createdCard.From the feed you follow. itemLink

Trim createdCard.card.url and save it as cardUrl.Trim createdCard.card.url and save it as cardUrl.

Google SheetsAdd a row to logTabName in logSpreadsheetUrl.Add a row to logTabName in logSpreadsheetUrl.

Add itemLink to the end of loggedLinks and save it as loggedLinks.Add itemLink to the end of loggedLinks and save it as loggedLinks.

Add 1 to cardsCreated.Add 1 to cardsCreated.

Show in the output: Made cardsCreated card(s). itemsRejected suggested item(s) were dropped because they were not in the feed word for word.Show in the output: Made cardsCreated card(s). itemsRejected suggested item(s) were dropped because they were not in the feed word for word.