Checks a blog, job board or news feed you follow every six hours and turns each new item into a Trello card, never the same one twice.
Uses
Claude
Google Sheets
Trello
Turn new posts from a site you follow into Trello cards
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 fetchErrorTry
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 http:// replaced by / and save it as feedHost.Get the first item of feedUrl with https:// replaced by http:// replaced by / and save it as feedHost.If feedReached is no or feedText is emptyIf feedReached is no or feedText is emptyYes
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 trelloBoardNameYes
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 emptyYes
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 trelloListNameYes
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 emptyYes
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 logErrorTry
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 emptyYes
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 noYes
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 readItemsErrorTry
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 emptyYes
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 emptyYes
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 1Yes
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 2Yes
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 emptyYes
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 itemLinkYes
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.
itemLinkTrim 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.