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
5/5
Total Actions
8

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.
Category
Compatibility
Complexity
Interactivity
Cross-Platform Features

Actions Used In This

📔
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
shortcuts://run-shortcut?name=Copy%20stories%20for%20spreadsheet
Open Shortcut deep link
shortcuts://open-shortcut?name=Copy%20stories%20for%20spreadsheet
AppleScript
tell application “Shortcuts Events” run shortcut “Copy stories for spreadsheet” end tell

More From This Category

You Might Also Like

Open work YouTube playlists

If you don’t want the Grab YouTube playlist ID shortcut installed, delete the Run Shortcut action above and the URL action below.

However, the shortcut won’t work with links from videos inside playlists anymore.

Get shortcut »


Get way deeper into Shortcuts – become a member.