Guide
Your portfolio sheet is the first step of setup. Copy the template, enter your listings, share the sheet with us — this page walks through all three and the mistakes worth avoiding.
Realtiq Team · notes from the field
Last updated · July 25, 2026
The first step of a Realtiq setup is not deciding where your portfolio will live — that decision is already made: your portfolio lives in your own Google Sheet. The system reads that sheet; you never enter listings into a second place. We explain why in making Google Sheets the single source. This page covers the practical half: how to create the sheet and connect it.
You don't need to build a sheet from scratch. Open the template, choose Make a copy, and a sheet appears in your own Google account. It has two tabs: Portföy, where your listings go, and Yardım, which explains every column.
The template ships with dropdowns and per-column notes, so you never have to guess at spelling. Do not rename the Portföy tab or edit the header row — those are the two anchors the system uses to recognise your sheet.
Fill one row per listing. Leave anything you're unsure about blank; only a handful of fields are genuinely required.
For a listing to be processed at all, six columns must be present: ilan_id, baslik (title), islem_tipi (sale or rent), emlak_tipi (property type), fiyat (price) and durum (status). The verification step on the setup page looks for exactly these six headers and names any that are missing.
Four rules prevent almost every mistake:
satilik, kiralik, aktif, pasif, evet, hayir. A capitalised variant reads as a different value.4500000.Two fields carry extra weight. If emlak_tipi is empty the system assumes an apartment — always fill it for land, offices, shops and similar, or the listing gets offered to the wrong buyer. For those types oda_sayisi (room count) should stay empty, since the concept doesn't apply. A detailed aciklama (description) also improves matching directly: the artificial intelligence reads it and compares it against what the buyer described.
The durum column marks whether a listing is live. Setting a sold property to pasif is enough — no buyer will be pointed at it again.
This is the most commonly skipped step. Your copy is private by default; we cannot see it. Press Share and add realtiq@realtiq.io as a Viewer.
Viewer is a deliberate choice: we can read your sheet, never write to it. Editor access is not needed. You can revoke access at any time from the same Share dialog, and syncing stops the moment you do.
Paste the sheet link into the setup page and press Verify. Three things are checked at once: whether we can reach the sheet, whether the required columns are in place, and how many listings it holds. If something is wrong you don't have to guess — the missing column name or the access warning appears on screen.
The WhatsApp step stays locked until verification passes. That is deliberate: connecting a number before the portfolio is attached would put an assistant live with nothing to offer.
Once setup is done, the only thing left is to keep the sheet current as you always have. The system re-reads it every half hour: new rows appear, edited prices are re-evaluated, and anything you mark pasif is deactivated. There is no second system to log into.
How we process your sheet, how long we keep the data and how to end our access are set out in our Privacy Policy and KVKK notice.
2 min read
Most offices already keep their portfolio in a spreadsheet. Make that the single source instead of migrating it, and double entry and stale listings end at the root.
Read the article →4 min read
Scanning the QR takes thirty seconds; what matters is understanding what it means. What a linked-device session is, which number to use, what happens if it drops, and which behaviour puts your number at risk.
Read the article →