Demo/template tables

TV Series

TV Episode Table

Use

By default, this assumes you have a TV Series table (with titles, TMDb IDs, and season counts), and assumes you want to fill in a TV Episodes table in the style of the template linked above. It does this using the official Notion integrations system, rather than the reverse-engineered third party module of the previous scripts.

Alternatively, you can specify show IDs yourself, and get the episode information directly to upload however you wish. To do that...

xfiles = Series(series_id=4087)
for episode in xfiles.episodes:
    print(episode)

An Episode object can be used like this:

> print(episode)
"""
"Fire"
Season 1, Episode 12
Aired 1993-12-17

An old Oxford girlfriend of Mulder's asks for his help on an international case
concerning the unexplainable execution of several British dignitaries, and they
encounter an assassin who can produce fire from his bare hands.

Written by Chris Carter, directed by Larry Shaw
Guest starring Amanda Pays, Dan Lett, Duncan Fraser, Lynda Boyd
"""

> episode.airdate
"1993-09-10"

> episode.director_list
['Robert Mandel']

> episode.directors
"Robert Mandel"

> episode.episode_number
3

> episode.guest_star_list
['Charles Cioffi', 'Cliff DeYoung', 'Sarah Koskoff', 'Leon Russom', 'Zachary Ansley', 'Stephen E. Miller', 'Malcolm Stewart', 'Alexandra Berlin', 'Ken Camroux-Taylor', 'Doug Abrams', 'Katya Gardener', 'J. B. Bivens', 'Ric Reid', 'Lesley Ewen', 'Jim Jansen', 'William B. Davis']

> episode.guest_stars
"Charles Cioffi, Cliff DeYoung, Sarah Koskoff, Leon Russom, Zachary Ansley, Stephen E. Miller"

> episode.id
283988

> episode.image
"<https://www.themoviedb.org/t/p/original/dSN3I7UqBMMILd7BUH2zUljKvqc.jpg>"

> episode.plot
"Special Agent Dana Scully is partnered with Special Agent Fox Mulder to validate his work on a special project called the X-Files. While he is a believer in the paranormal fueled by a lost memory of his sister's abduction, she is a scientist and prefers to look for rational, logical explanations. Their first case takes them to Oregon to investigate the unsolved murders of several High School classmates who "Spooky" Mulder believes have been experimented on by aliens."

> episode.season_number
5

> episode.series_id
4087

> episode.title
"Syzygy"

> episode.writer_list
['Chris Carter']

> episode.writers
"Chris Carter"

> episode.save()
"Saved to Notion table."

Setup

• Be using Python 3.9, with Requests installed (python -m install pip; pip install requests).
• Fill in your TMDb API key on line 8.
• Create a new integration.
• Invite your integration to your TV Series and TV Episode tables using the Share feature.
• By the "Internal Integration Token" field, click "Show", and copy the value you see into line 9 (integration = "secret_fh9h8erqjeq....").
• Take the URL of your TV episode table, and isolate its ID. In the URL below, the ID is highlighted.

https://www.notion.so/ryanplant/***7055ecbeb0a34c0aa740c388fd7ac756***?v=8bd227750d2543b790dfcf49796d0a15

Use it as the EPISODE_DB_ID value on line 10.

• Do the same for your TV series table, and the SERIES_DB_ID value on line 11.
• In your TV Series table, check off boxes in a column marked "Fetch Episodes", and let it run.

Script