A small server that turns a spreadsheet of addresses into colour-coded pins on KakaoMap, automatically.
KakaoMap is the most popular map app in South Korea, but adding hundreds of saved places by hand is slow. K-Mapper takes a list of households from a spreadsheet (names, coordinates, notes and a status) and puts every one of them onto your KakaoMap account as a saved pin in its own folder, coloured by status. Run it again and the folder is rebuilt from scratch, so the map always matches the sheet.
- Spreadsheet to map: send a list of households and they appear as pins in a
MEMBERS❤️favourites folder. - Colour-coded status: each pin's colour shows its status, with a legend saved in the folder's memo (yellow inactive, green member, pink visited, red bad).
- Notes on every pin: a memo travels with each household onto the map.
- Automatic sign-in: logs in to Kakao with a headless browser and saves the session cookies.
- Self-healing sessions: checks whether the saved session still works and logs in again by itself when it has expired.
- Big lists, small uploads: data arrives as a compressed ZIP and is sent to the map 50 pins at a time.
- Multiple users and sheets: each user and sheet keeps its own saved session.
flowchart LR
A[Spreadsheet] -->|"/api/checkKMLogin"| B[Express server]
A -->|"/api/login"| B
A -->|"/api/upload (zipped JSON)"| B
B --> C[cookieGrabber.js<br/>Puppeteer login]
B --> D[updateKM.js]
D --> E[Delete + recreate<br/>favourites folder]
D --> F[Headless browser on<br/>map.kakao.com]
F --> G[📍 Pins added in<br/>batches of 50]
| File | Role |
|---|---|
index.js |
Express API: check login, log in, upload household data |
cookieGrabber.js |
Signs in to a Kakao account with Puppeteer and saves the cookies |
updateKM.js |
Rebuilds the favourites folder and adds the pins |
A neat detail: KakaoMap stores pins in its own map coordinate system rather than latitude/longitude. Instead
of converting them by hand, K-Mapper runs the conversion inside a real KakaoMap page, using Kakao's own
map library (kakao.maps.LatLng(...).toCoords()), so every pin lands exactly where it should.
Requires Node.js 18 or newer.
npm install # also downloads the browser Puppeteer uses
npm start # starts the server on port 3000 (or $PORT)Visiting / returns a "Kakao Login API is alive!" message, which is handy as a health check. Sessions are
stored under storage/<sheet>/<user>/.
⚠️ Saved sign-in details and cookies are kept on the server's disk. Keep thestorage/folder private and only run the server somewhere you trust.
- Node.js + Express
- Puppeteer (headless Chrome) for login and pin creation
- axios for KakaoMap folder requests
- JSZip for compressed uploads