Skip to content
JacobaliciousPublic

About

Turns a spreadsheet of household locations into colour-coded saved pins on KakaoMap, using Express and Puppeteer

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

2 Commits

Folders and files

Repository files navigation

🗺️ K-Mapper

A small server that turns a spreadsheet of addresses into colour-coded pins on KakaoMap, automatically.

Node.js Puppeteer KakaoMap

✨ What it does

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.

🚀 Features

  • 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.

🛠️ How it works

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]
Loading
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.

📦 Getting started

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 the storage/ folder private and only run the server somewhere you trust.

🧰 Built with

  • Node.js + Express
  • Puppeteer (headless Chrome) for login and pin creation
  • axios for KakaoMap folder requests
  • JSZip for compressed uploads

About

Turns a spreadsheet of household locations into colour-coded saved pins on KakaoMap, using Express and Puppeteer

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages