Blue card Berlin – Termin script automation for Ausländerbehörde

Script for automation of getting a termin / booking on https://otv.verwalt-berlin.de

Script doesn't book anything for you - it just helps to find an open slot by attempting to register every 1 min and leaves the browser open so you can continue the process in the same window.

You will receive a notification when you have a possible hit so it's probably good idea to allow notification in system settings. Also telegram notifications are available but you need to setup keys on your own unfortunately.

Setup

1. Install local packages npm i
2. If you have problems with chromedriver, try to install it in the system brew install --cask chromedriver

Config

Create .env file from .env.example and fill variables you want script to run with. Values there are text representation of select options on a website.

Run

To run execute: npm start

There are can be a lot of false positives, that's why you need to keep an eye on console to check why execution stopped and restart again if needed.

It should send 2 type of notifications when program terminates:

• the one when unexpected error happens
• the other one is possible success

Setup for dummies

1. Pre-requirements:

You will need to install nodejs; google for something like how to install nodejs for macos and you should be fine; Current node version: 18.16.0 Open terminal and confirm that you have node installed:

node -v
npm -v

2. Execute following commands in terminal to install script:

git clone https://github.com/dmitry-kostin/termin-buchen
cd termin-buchen
npm i

3. make a copy of .env.example file, rename this copy to .env and fill with your variables. You should be able to see two files laying nearby: .env.example and your new .env

.env file example:

MAIN_CITIZENSHIP=Russian Federation
NUMBER_OF_PEOPLE=one person
LIVE_WITH=yes
PARTNER_CITIZENSHIP=Germany
REASON=family

4. execute following to run automation: npm run start. Browser window opens - don't touch it, just leave it in the background. In terminal you should be able to see basic logging records. Allow notifications in notification center and keep an eye on notifications.

Termin not found, another attempt in 60 seconds:

[runner]: iteration 1 result: false`

Termin found – take the window from background and continue booking your termin.

[runner]: iteration 1 result: true`

Important notes:

• have first/last name, email, birth date and your visa number ready
• if you won't be able to fill all of this info fast enough - slot would be invalidated and you'll get an error at the end
• new slots are usually getting opened around the same time every day

Donate

If you had any luck with finding a slot using this script – feel free to donate me. I appreciate any help!

Current stats:

• found slots for 6 families
• average time to find a slot: 2 days
• donations: $59.40