Help Center
Column mapping
Mapping tells Replyk which column in your spreadsheet holds each piece of customer data. Only the Phone column is required — the AI Agent will ask for anything else during the conversation.
Order fields
For each field below you pick the column header from your sheet (or leave it unmapped).
| Field | Required | Description |
|---|---|---|
| customer_phone | Yes | The customer's WhatsApp-capable phone number. Must be in international format (e.g. +212600000001) or a local number that Replyk can normalize using your business country. |
| customer_name | No | Full name of the customer. |
| customer_email | No | Email address. |
| customer_address | No | Street address or full address string. |
| customer_city | No | City / commune. |
| customer_country | No | Country name or ISO code. |
| customer_notes | No | Any free-form notes attached to the order. |
Phone number format
Replyk normalizes phone numbers automatically using your business country as the default country code. The following formats are all accepted for a Moroccan number:
Template variables
If your WhatsApp template contains dynamic variables (for example, a placeholder for the customer name), you can map each variable to a sheet column. The variable index corresponds to its position in your approved template.
Example: if your template greets the customer by name and then confirms their product, map variable 1 to the Name column and variable 2 to the Product column.
What the AI Agent fills in
Any unmapped order field (name, address, city, etc.) becomes an open question for the AI Agent to ask the customer during the WhatsApp conversation. The order is then updated automatically as the customer replies.
This means you can create a connection with only the Phone column mapped and let the Agent handle the rest — ideal when your leads only provide a phone number.