Zoe Agent now allows you to import WhatsApp contacts directly from Google Sheets, making it easier than ever to manage your subscribers and launch powerful broadcast campaigns. In this guide, you’ll learn exactly how to connect your Google account, import sheets, map fields correctly, and build a clean, personalized contact list for your WhatsApp marketing
Checklist Before Importing
Before initiating the import process, use this checklist to ensure a smooth transfer of data:
- ✅ Ensure your phone numbers are correctly formatted with country codes.
- ✅ Use clean, alphanumeric column headers.
- ✅ Double-check all field mappings during import.
- ✅ Test a few sample contacts first if needed.
Step 1: Import WhatsApp Contacts from Google Sheet
Once your Sheet is ready, follow these steps to import the contacts into Zoe Agent:
- Go to WhatsApp → Subscriber Manager inside Zoe Agent.
- Click on Options.
- Select Import Subscribers.
- Choose Import from Google Sheet.
- Select the Google Sheet you want to use.
Step 2: Map Fields Correctly
After selecting your Google Sheet:
- Zoe Agent will show a sample preview of two data rows.
- Click Map Fields.
- Match your sheet columns to Zoe Agent fields:
- Map phone → Subscriber Phone (Mandatory)
- Map name → Subscriber Name
- Double-check each field mapping carefully.
Proper mapping ensures data is stored correctly and used in personalization later.
Step 3: Confirm and Import
After mapping the fields, click Confirm.
Zoe Agent will then begin importing your contacts.
Once the process is complete, all imported contacts will appear inside your WhatsApp Subscriber List.
Congratulations! Your WhatsApp contacts are now ready for broadcast, segmentation, and automation campaigns.
FAQs
Can I import contacts from any Google account?
No, you must first connect your Google account to Zoe Agent through Settings $\rightarrow$ Google Sheets and authorize access. Only Sheets from connected accounts can be imported.
What is the required format for the Google Sheet?
- The Sheet must have proper column headers (e.g., phone, name, email).
- Column headers should be alphanumeric only, with no spaces or special characters.
- Phone numbers must include country codes (e.g., +1 for USA, +91 for India).
Is the phone number field mandatory during import?
Yes. The phone number field is mandatory because it identifies WhatsApp subscribers inside Zoe Agent. Without it, the contact cannot be imported.
How do I find the Sheet ID to import an existing sheet?
The Sheet ID is part of the Google Sheet URL.
Can I map additional fields like email, city, or interests?
Yes. During field mapping, you can assign additional columns from your Google Sheet to custom fields inside Zoe Agent. This helps you personalize future broadcasts even more.
What happens if some fields are missing or wrongly mapped?
- If fields are not mapped correctly, only the mapped fields will be imported.
- Missing fields will be empty.
- It’s highly recommended to review your mappings carefully before confirming the import.
Can I update an existing subscriber’s data through import?
No. Importing from Google Sheets in Zoe Agent only adds new subscribers. It does not update existing contacts automatically. For updating, manual editing or automation setups would be needed.
Is there a limit on how many contacts I can import from a Sheet?
Zoe Agent allows bulk importing of contacts. However, for best performance, it’s recommended to import sheets containing up to 5,000–10,000 rows per import. For larger lists, break them into multiple sheets.
Can I automate updates from a Google Sheet to Zoe Agent?
Currently, imports from Google Sheets are a manual process (you initiate the import). Live sync between Sheets and Zoe Agent is not available at the moment.
After import, how can I use the contacts?
Once imported, you can:
- Launch broadcasts to them immediately
- Add them into labels, sequences, or flow campaigns
- Personalize WhatsApp messages using dynamic fields like name, service interest, etc.
