Just Invest Here

Complete System Guide — Bot + Website + CRM

EN ES FR

Contents

  1. System Overview
  2. How to Add a New Property
  3. Photos & Videos
  4. Publishing & Unpublishing
  5. CRM → Website Auto-Sync
  6. VIP & Luxury Properties
  7. Managing Team Members
  8. News Articles (Blog)
  9. Newsletter
  10. Idealista & JamesEdition Feeds
  11. Telegram Bot Commands
  12. Website Pages & Languages
  13. Monday.com Boards Reference
  14. Long-Term To-Do
  15. What Changed (Apr 8 → May 5)

1. System Overview

The system has three connected parts:

Telegram Bot

Field agents create properties, leads, and deals directly from their phone. 15-step wizard with photo upload.

Monday.com CRM

Central database for all properties, leads, deals, and team members. Single source of truth.

Website

justinvesthere.com — public-facing luxury real estate site with 3 languages (ES, EN, FR).

Feeds

Idealista JSON and JamesEdition XML feeds auto-generated from the website database.

How They Connect

Agent (Telegram) Bot Monday.com CRM Website + Feeds

Any change in Monday.com automatically syncs to the website within seconds.

2. How to Add a New Property

Option A: Via Telegram Bot (for field agents)

Open the bot, tap the menu button, select /nueva. Follow the 15 steps:

Steps 1–3: Client Info

Name, email, phone → creates a Lead in Monday.com

Steps 4–5: Type

Transaction (Venta/Alquiler) + Property type (Piso, Casa, Chalet, etc.)

Steps 6–10: Details

Address, city, price, commission, area, bedrooms, bathrooms

Step 11: Description

Free text description (used for AI-enhanced listing text)

Step 12: Review

Review all data, confirm or edit

Step 13: Contract

Optional DocuSign contract (Standard or Exclusive)

Step 14: Photos

Upload up to 50 photos (send as files for best quality)

Step 15: Publish

Select platforms: Website, Idealista, JamesEdition

Option B: Directly in Monday.com

Step 1

Add a new item to the Properties board

Step 2

Fill in all columns: type, address, price, area, bedrooms, bathrooms, description

Step 3

Upload photos to the “Fotos” file column

Step 4

Check the publishing checkboxes (Publicar Web, Publicar Idealista, etc.)

Step 5

Set “Listo para Publicar” to Listo → auto-publishes

3. Photos & Videos

All media is uploaded to the property item in Monday.com. The website pulls it within seconds — no separate upload to the website is needed.

Photos

Where

Open the property item in Monday → Fotos file column → drag & drop, or paste from clipboard.

Formats

JPG, PNG, WebP, HEIC all accepted. iPhone HEIC photos are converted to JPEG automatically — no need to export to JPG yourself first.

Quantity

Up to 50 per property via the Telegram bot, unlimited via Monday upload. Recommended: 15–30 photos — more than that hurts page load.

Order

The first photo in Monday is the cover (used on the listing card and as the main photo on the detail page). Drag photos in Monday to reorder.

Resolution & size

Originals can be any size — the website automatically generates responsive variants via Cloudflare Image Transformations (one of: 400, 800, 1200, 1600, 2400 px wide). Visitors download only what their device needs.

Floorplans

Mark a photo as a floorplan in Monday (column Tipo de Foto = “Plano”) — it renders in a dedicated “Floorplans” section on the property page instead of the main gallery.

Videos

Three options — pick whichever you have:

OptionHow to addBest for
YouTube / Vimeo link Paste the public URL into the Video URL column in Monday. Tour videos, drone footage, agent walkthroughs — anything > 100 MB.
MP4 upload Attach the file to the Video file column. Keep under 100 MB. Short clips (under 1 minute), aerial shots.
360° / Matterport tour Paste the embed URL into the Tour URL column. Virtual tours, Kuula, Matterport, iGuide.

Videos appear above the photo gallery on the property detail page. If both an MP4 and a YouTube link are present, the MP4 is used and YouTube is shown as a fallback link.

Tip: for the JamesEdition feed, an MP4 or YouTube link is required — properties without video are accepted but ranked lower in their portal.

4. Publishing & Unpublishing

Action in Monday.com What Happens Speed
Set “Listo para Publicar” → Listo Property published to all selected platforms Automatic — seconds
Set “Listo para Publicar” → No Listo Property removed from website and all feeds Automatic — seconds
Set “Listo para Publicar” → Bloqueado Same as No Listo — property archived Automatic — seconds
Change Status to Vendido Property marked as sold on website Automatic — seconds
Key columns that control publishing:
Publicar Web — show on justinvesthere.com
Publicar Idealista — include in Idealista feed
Publicar JamesEdition — include in JamesEdition feed
Listo para Publicar — master switch (must be “Listo” to publish)

5. CRM → Website Auto-Sync

Every change you make to a property in Monday.com automatically updates the website.

Edit column in Monday Webhook fires (3s debounce) Bot syncs data Website updated

What syncs automatically

FieldMonday.com Column
PricePrecio
DescriptionDescripción
PhotosFotos (file column)
Bedrooms / Bathrooms / AreaHabitaciones, Baños, Superficie
Property typeTipo (Piso, Casa, etc.)
Transaction typeTipo de Operación
AmenitiesPiscina, Jardín, Terraza, A/C, etc.
VIP / Luxury flagsDestacado (VIP), Lujo
Energy ratingClasificación Energética
Publishing flagsPublicar Web / Idealista / JamesEdition

No manual action needed — just edit in Monday.com and the website updates automatically.

6. VIP & Luxury Properties

Checkbox in MondayEffect on Website
Destacado (VIP) Property appears in the Featured Properties carousel on the homepage (top 3 shown)
Lujo Property appears in the Prestige Collection section and on the /luxury page with a luxury badge

Just check the checkbox in Monday.com — the website updates automatically.

7. Managing Team Members

Team members are managed in the Team Members board in Monday.com (ID: 5094178524).

To add a new team member

Step 1

Add a new item to the Team Members board. The item name is the person's full name.

Step 2

Fill in: Title (ES/EN/FR), Email, Phone, Photo, LinkedIn, Languages, Location

Step 3

Check Activo and Publicar Web checkboxes

Step 4

Set Orden (sort order) — 1 appears first

The team section on the website updates automatically when any column changes.

Team Board Columns

ColumnPurpose
Título (ES/EN/FR)Job title in 3 languages
EmailContact email
TeléfonoPhone number
FotoProfile photo (uploaded to Monday)
LinkedInLinkedIn profile URL
IdiomasLanguages spoken
UbicaciónCity/country
Bio (ES/EN/FR)Biography in 3 languages
OrdenDisplay order (1 = first)
ActivoMust be checked to appear
Publicar WebMust be checked to show on website

8. News Articles (Blog)

News articles published at /news are managed in the News group of the Properties board (or a dedicated News board if you prefer — ask Dev to split). Each article supports 3 languages and a featured image.

To publish a new article

Step 1

In Monday, create a new item. The item name is the slug (URL part) — e.g. guide-investing-ibiza-2026. Lowercase, hyphens, no accents.

Step 2

Fill the language columns:

  • Title (ES / EN / FR) — the article headline.
  • Excerpt (ES / EN / FR) — 1–2 sentences shown on the news listing card.
  • Body (ES / EN / FR) — the full article. Plain text or basic HTML.
  • Category (ES / EN / FR) — e.g. “Mercado” / “Market” / “Marché”.
Step 3

Upload a Featured Image (file column) — landscape, min 1200×800. This becomes the cover on the listing and at the top of the article page.

Step 4

Set Published At (date column) and switch Status to Published. Tick Publicar Web.

Step 5

Within ~5 minutes the article appears at /news/your-slug (and /en/news/your-slug, /fr/news/your-slug).

Status values

StatusWhat happens
DraftHidden from the public site. Use while writing.
PublishedLive on /news in the languages you filled in.
ArchivedRemoved from the listing but URL still works (so old links don't 404).
Language fallback: if you fill only the Spanish title/body, the article shows on /news only. To make it visible on /en/news and /fr/news, fill those language fields too — or leave them blank if the article is intentionally Spanish-only.

9. Newsletter

Status: partially built. The website database has a subscribers table ready to receive emails, but the subscribe form on the public site and the sending pipeline are not yet implemented.

What works today

Nothing visitor-facing. The schema is in place; no UI; no provider connected.

To turn this on, we need three decisions from you

DecisionOptions
Email provider Mailchimp, Brevo (ex-Sendinblue), Resend, Beehiiv, ConvertKit. Pick one — we will integrate.
Where the form appears Footer-only, or also a popup on second visit, or inline at the bottom of news articles.
Who writes & sends each issue You? Us? Frequency: monthly, quarterly, or only on new property launches.

Once decided, here is what we'll build

A

Subscribe form component (footer + optional inline). Single email field, GDPR consent, double-opt-in confirmation email.

B

POST /api/subscribe endpoint that writes to the subscribers table and pushes to your chosen provider's list.

C

One-time export of any existing subscribers from your current tools into the new provider, if applicable.

D

A short separate guide on how to send campaigns from the chosen provider's dashboard.

Estimated effort: 1–2 hours of dev work once a provider is chosen.

10. Idealista & JamesEdition Feeds

PortalFeed URLStatus
Idealista justinvesthere.com/api/feeds/idealista.json Live — V6 schema, HEIC photos auto-converted to JPEG.
JamesEdition justinvesthere.com/api/feeds/jamesedition.xml Live — only properties with Publicar JamesEdition checked appear.

Feeds are auto-generated from the website database. When you publish/unpublish a property in Monday.com with the Idealista or JamesEdition checkbox, it appears in or disappears from the feed automatically.

Idealista polls the feed URL periodically. No manual upload needed.

11. Telegram Bot Commands

CommandWhat it does
/startWelcome message, request access
/nuevaStart 15-step property creation
/syncSync all properties to website
/cancelCancel current conversation
/statusShow conversation progress
/resumeResume interrupted conversation

These commands appear in the Telegram menu button (☰) for easy access.

Authorization: New users must be approved before they can use the bot. Currently authorized: Oleh Veheria, Vicente Martinez. To add a new agent, provide their Telegram user ID.

12. Website Pages & Languages

The website is available in 3 languages. Spanish is the default (no URL prefix).

PageSpanishEnglishFrench
Home//en/fr
Properties/properties/en/properties/fr/properties
Luxury/luxury/en/luxury/fr/luxury
News/news/en/news/fr/news
Team/team/en/team/fr/team
Contact/contact/en/contact/fr/contact

Location pages: /locations/valencia, /locations/ibiza, /locations/zanzibar

Coming Soon: Dubai, Costa Blanca, South of France

13. Monday.com Boards Reference

BoardIDPurpose
Properties2112025682All real estate listings
Leads2112025567Client contacts
Deals2112025532Active transactions
Conversations5084545513Bot conversation tracking
Team Members5094178524Team (synced to website)
Testimonials5094195204Client testimonials (synced to homepage)

14. Long-Term To-Do

Day-to-day decisions live in Monday.com and the project's STATE.yaml. This list is for structural and longer-horizon items.

Content & data quality

#TaskWhoStatus
1 GPS coordinates for map pins
Properties missing Latitud / Longitud in Monday don't render a map pin on the detail page. Right-click on Google Maps to copy coordinates, paste into Monday.
Agent Optional
2 Review property descriptions
Bot-created properties often have brief auto-generated text. Polish the Descripción column in Monday — changes sync to the website automatically.
Agent Recommended
3 Translate all property descriptions to EN + FR
Spanish is the default; missing EN/FR text falls back to Spanish on the localised pages. For best UX (and SEO), fill all three.
Agent / Dev (auto-translate) Recommended

Distribution

#TaskWhoStatus
4 Newsletter pipeline
Pick a provider (Mailchimp / Brevo / Resend / Beehiiv), confirm where the form should appear, decide who writes campaigns. See section 9.
Vicente Decision
5 Coming Soon destinations
Dubai, Costa Blanca, South of France are shown as “Coming Soon”. As soon as you add a property with one of these cities in Monday, the destination becomes live automatically.
Vicente TBD
6 JamesEdition shortlist (recurring)
Each new luxury property: tick Publicar JamesEdition if it belongs in the JE feed (premium portal, only your best listings).
Vicente Recurring

Team & access

#TaskWhoStatus
7 Add field agents to the Telegram bot
Each new agent: open Telegram, message @userinfobot, send numeric ID to Dev. Added immediately, no redeploy.
Vicente + Dev Recurring
8 Social media links (LinkedIn + Google Business)
For website footer and SEO. Send URLs once, we wire them in.
Vicente Needed

Technical (handled by Dev)

#TaskWhoStatus
9 Contact form email delivery via Resend
Submissions are saved to the DB; email forwarding to vicente@justinvesthere.com requires domain verification on Resend.
Dev Technical
10 Restore guide hosting at jih.futurist.systems/todo
Origin currently returns SSL handshake error. Re-establish the deploy pipeline (CF Pages or Worker), document it.
Dev Technical

15. What Changed (Apr 8 → May 5, 2026)

Highlights of the last four weeks of work. Earlier history is in git log.

Media pipeline

✓ HEIC photos work end-to-end (F6) — iPhone HEIC files are now converted to JPEG automatically through Cloudflare Image Transformations. The Idealista feed and gallery render correctly even when an agent uploads straight from their phone. One-shot fixup applied to back-catalogue (prop-24).
✓ Cloudflare Image Transformations enabled — on the Free plan (5,000 unique transformations/month). Property card images are resized via /cdn-cgi/image, fixing broken cards caused by oversized R2 originals.
✓ Video support shipped — properties can now have YouTube/Vimeo links, MP4 uploads, or 360° tour embeds. Renders above the photo gallery on the detail page. Included in the V6 Idealista feed when present.
✓ Property card upgrade — shows year_built and a localised property-type chip (Casa / Villa / Apartamento …).

News & content

✓ News articles now flow from Monday — the /news blog is no longer hard-coded. Articles are managed in the CRM with 3-language fields, status (Draft/Published/Archived), and a featured image. See section 8.
✓ Legal pages translated — Privacy and Terms now exist in EN and ES (in addition to FR).

Infrastructure

✓ Domain on Cloudflarejustinvesthere.com DNS migrated to Cloudflare on 2026-04-30. Faster propagation, free DDoS protection, prerequisite for Image Transformations.
✓ Monday “Add new property” Form view — a clean entry form for new properties (instead of editing the wide Monday board directly). Created via the Monday API; columns are pre-grouped and required fields enforced.

Quality

✓ CI tightened — tests + build run on every PR (GitHub Actions). Codex review with auto-merge on a clean run.