This Shortcut uses SheetBox to read OrionAPILookup.csv and check whether a Chrome/Firefox extension will work on Orion iOS.
- SheetBox app installed
OrionAPILookup.csvsaved to your Files app (iCloud Drive or On My iPhone)
| /* | |
| How to setup | |
| ============ | |
| 1. Go to https://script.google.com and login | |
| 2. Click New Project | |
| 3. Give the project a name be clicking on "Untitled Project" and giving a new name | |
| 4. Copy this whole code and overwrite everything on Code.gs file. Click on the Save icon to save. | |
| 5. Go to Google drive and open the worksheet that you want to manipulate | |
| 6. Take a look at the url. It should be in this format -- https://docs.google.com/spreadsheets/d/spreadheet-id-as-some-long-seemingly-random-characters/edit#gid=478439860 |
| <%* | |
| /* | |
| You need to install yt-dlp and jq to use this template: | |
| $ brew install yt-dlp jq # on macOS | |
| You need to define user function in Templater plugin settings named "ytmeta" with the following command: | |
| /opt/homebrew/yt-dlp -j "https://www.youtube.com/watch?v=${id}" | /opt/homebrew/jq "${query}" | |
| replace /opt/homebrew with your path to yt-dlp and jq |
| #!python3 | |
| ''' | |
| Directions: | |
| - install yt-dlp via Pip (e.g. using (StaSh)[https://github.com/ywangd/stash] - `pip install yt-dlp`) | |
| - add this script as a Share extension through Settings -> Share Extension Shortcuts | |
| - while watching a video in the YouTube site or app, just share the video to Pythonista and select this script | |
| - the video will download, and when it's done you can share the video file itself with any app (e.g. VLC) | |
| Advanced usage: |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <title>Paper Cost Calculator</title> | |
| <link rel="stylesheet" href="styles.css"> | |
| </head> | |
| <body> | |
| <h1>Paper Cost Calculator</h1> |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <title>Paper Cost Calculator</title> | |
| <link rel="stylesheet" href="styles.css"> | |
| </head> | |
| <body> | |
| <h1>Paper Cost Calculator</h1> |