Copy stories for spreadsheet

Pulls archived items from a specific tag and extracts the title/URL from the choice, separated by two tabs and copied to the clipboard so it can be pasted across columns in a spreadsheet.

Matthew's Score
Total Actions
Built For

Shortcut Information

Use this shortcut to copy out the title and link for any stories you’ve saved and paste them somewhere like a Google Sheet.

I created this to find stories for my podcast, then, once I’ve read them, pick the best stories and move them into a shared Google doc with my cohost before our show.

Items are separated in columns by Title | Notes | URL, so the two tabs allow the title to drop in the first cell, then one tab skips to Notes, the second skips to URL, and then my link gets placed there.

This workflow was not previously possible in the same way via Instapaper, because I’d either have to star every story or save items before archiving (since Instapaper doesn’t sort the archive).With Reeder, I can properly read/archive/star stories as normal, then pick from the archive later and move them into my doc.

Actions Used

Add PDF to Books
Opens the input as a PDF in iBooks.
Add New Event
Creates a new event and adds it to the selected calendar.
Add Frame to GIF
Adds an image to the existing animated GIF passed as input. If no GIF is passed as input, a new animated GIF is created.

Extra Details

Run Shortcut deep link
Open Shortcut deep link
AppleScript code
tell application “Shortcuts Events” run shortcut “Copy stories for spreadsheet” end tell

More From This Folder

You Might Also Like

Get way deeper into Shortcuts – become a member.