A Google Sheet that fills itself with a cinema’s showtimes

Date        Time   Film                        Runtime  Version  Format  Booking
2026-11-06  11:50  Sourires d'une nuit d'été   1 h 49   VOST     2D      https://www.cinema-lechampo.com/…
2026-11-06  11:55  Le Septième Sceau           1 h 36   VOST     2D      https://www.cinema-lechampo.com/…
2026-11-06  13:45  Affreux, sales et méchants  1 h 55   VOST     2D      https://www.cinema-lechampo.com/…

curl "https://api.api-cinema.com/v1/cinemas?q=champo" -H "Authorization: Bearer ac_live_…"

// A Google Sheet that fills itself with a cinema's showtimes, from API Cinéma.
// Menu "Cinéma": set the key once, update now, or every morning.

const API = 'https://api.api-cinema.com/v1'
const HEADER = ['Date', 'Time', 'Film', 'Runtime', 'Version', 'Format', 'Booking']

function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu('Cinéma')
    .addItem('Update showtimes', 'updateShowtimes')
    .addItem('Update every morning', 'installDailyTrigger')
    .addSeparator()
    .addItem('Set API key…', 'setApiKey')
    .addToUi()
}

/** The key lives in the script properties: never in a cell, never in the code. */
function setApiKey() {
  const ui = SpreadsheetApp.getUi()
  const answer = ui.prompt('API Cinéma key', 'Paste your key (ac_live_…).', ui.ButtonSet.OK_CANCEL)
  if (answer.getSelectedButton() !== ui.Button.OK)
    return
  PropertiesService.getScriptProperties().setProperty('API_CINEMA_KEY', answer.getResponseText().trim())
}

function updateShowtimes() {
  const key = PropertiesService.getScriptProperties().getProperty('API_CINEMA_KEY')
  if (!key)
    throw new Error('No API key yet: Cinéma › Set API key…')

  const ss = SpreadsheetApp.getActiveSpreadsheet()
  const config = configSheet(ss)
  const slug = String(config.getRange('B1').getValue()).trim()
  const days = Math.max(1, Math.min(14, Number(config.getRange('B2').getValue()) || 7))
  if (!slug)
    throw new Error('Put the cinema slug in Config!B1')

  const rows = fetchShowtimes(key, slug, days).map(s => [
    s.startsAt.slice(0, 10), // the cinema's local date and time, as the API gives them
    s.startsAt.slice(11, 16),
    s.movie.title,
    s.movie.durationMin ? `${Math.floor(s.movie.durationMin / 60)} h ${String(s.movie.durationMin % 60).padStart(2, '0')}` : '',
    s.version,
    s.format,
    s.bookingUrl || '',
  ])

  const sheet = ss.getSheetByName('Showtimes') || ss.insertSheet('Showtimes')
  sheet.clearContents()
  sheet.getRange(1, 1, 1, HEADER.length).setValues([HEADER]).setFontWeight('bold')
  if (rows.length)
    sheet.getRange(2, 1, rows.length, HEADER.length).setValues(rows)
  sheet.setFrozenRows(1)
  sheet.autoResizeColumns(1, HEADER.length)
  config.getRange('B3').setValue(new Date())
}

/** Every showtime of the cinema from now to `days` days ahead, page by page. */
function fetchShowtimes(key, slug, days) {
  const to = new Date()
  to.setDate(to.getDate() + days - 1) // `to` is a whole day: 7 days = today and the 6 after
  const params = { to: Utilities.formatDate(to, Session.getScriptTimeZone(), 'yyyy-MM-dd'), include: 'movie', limit: 1000 }
  const all = []
  let cursor
  do {
    const query = Object.entries({ ...params, cursor })
      .filter(([, v]) => v !== undefined)
      .map(([k, v]) => `${k}=${encodeURIComponent(v)}`)
      .join('&')
    const res = UrlFetchApp.fetch(`${API}/cinemas/${encodeURIComponent(slug)}/showtimes?${query}`, {
      headers: { Authorization: `Bearer ${key}` },
      muteHttpExceptions: true,
    })
    if (res.getResponseCode() !== 200) {
      throw new Error(`API Cinéma answered ${res.getResponseCode()}: ${res.getContentText().slice(0, 200)}`)
    }
    const body = JSON.parse(res.getContentText())
    all.push(...body.data)
    cursor = body.meta && body.meta.nextCursor
  } while (cursor)
  return all
}

/** The Config sheet, created with defaults the first time. */
function configSheet(ss) {
  let sheet = ss.getSheetByName('Config')
  if (!sheet) {
    sheet = ss.insertSheet('Config')
    sheet.getRange('A1:B3').setValues([
      ['Cinema slug', 'le-champo-paris-5e-arrondissement'],
      ['Days', 7],
      ['Last update', ''],
    ])
    sheet.autoResizeColumns(1, 2)
  }
  return sheet
}

/** One update a day, around 6 in the morning, in the spreadsheet's time zone. */
function installDailyTrigger() {
  ScriptApp.getProjectTriggers()
    .filter(t => t.getHandlerFunction() === 'updateShowtimes')
    .forEach(t => ScriptApp.deleteTrigger(t))
  ScriptApp.newTrigger('updateShowtimes').timeBased().everyDays(1).atHour(6).create()
  SpreadsheetApp.getUi().alert('The Showtimes sheet will update every morning.')
}