Integrating Google Sheets with LandinChat allows you to import, update, and manage WhatsApp contacts efficiently—without CSV uploads or manual entry. This is ideal for teams handling frequent lead updates, shared databases, or collaborative contact management.

Before doing anything, you must set up custom fields and labels. Skipping this step leads to broken mappings and unusable data.

When Should You Use Google Sheets Integration? #

Use Google Sheets if:

• Your leads are updated regularly
• Multiple team members manage contacts
• You want quick re-imports without CSVs
• You’re syncing leads from ads, sales teams, or ops

If it’s a one-time bulk import, CSV is fine. Sheets shine with ongoing workflows.

Prerequisites (Mandatory) #

Before starting, ensure you have:

• An active LandinChat account
• A Google account with Google Sheets access
• Custom Fields created in LandinChat
• Labels created for segmentation

If column names don’t match custom fields, import will fail or map incorrectly.

Step 1: Sign in to Your LandinChat Account #

1. Log in to LandinChat
2. Go to Settings (under Management)
3. Click Google Sheets Integration

Step 2: Connect Your Google Account #

1. Click Connect Google Account
2. Select the Google account where your sheets exist
3. Grant required permissions
4. Click Continue

Your Google account is now connected.

✅ You can connect multiple Google accounts if needed.

Step 3: Create or Use a Google Sheet #

Option 1: Create a New Sheet (Recommended for New Users) #

1. Select your connected Google account
2. Enter a sheet name
3. Add headers using alphanumeric characters only

Example headers:

• phone_number
• name
• company

4. Click Save
5. Open the sheet and add contact data:
   • Phone number (country code + number only)
   • Name
   • Company or other custom fields

⚠️ Do NOT use spaces or special characters in headers.

Option 2: Use an Existing Google Sheet #

1. Open your existing Google Sheet
2. Copy the Sheet ID from the URL
3. Go back to LandinChat
4. Click Add Existing Sheet
5. Select the Google account
6. Paste the Sheet ID and click Save

Your existing sheet is now linked.

Step 4: Prepare for Contact Import #

Before importing, ensure alignment:

Custom Fields #

• Go to Subscriber Manager → Custom Fields
• Create fields that match your sheet headers
  Example:
  • Sheet column: company
  • Custom field: Company

Labels #

• Go to Labels
• Create a label (e.g., Google_Leads)
• This helps track where contacts came from

Step 5: Import Contacts from Google Sheets #

1. Go to Subscriber Manager
2. Click Options → Import Subscribers
3. Select Google Sheets
4. Choose the connected sheet
5. Select the label to assign
6. Map fields correctly:
   • Phone Number → Phone Number
   • Name → Subscriber Name
   • Company → Custom Field: Company
7. Click Confirm

Import completes instantly.

Important Rules (Read This or Face Issues) #

• Phone numbers must include country code
• No special characters in phone numbers
• Headers must match custom field names
• Import does not bypass WhatsApp opt-in rules
• Duplicate numbers are ignored or updated (based on settings)

Bad sheet formatting = silent failures.

Key Takeaway #

Google Sheets integration in LandinChat is:

• Faster than CSV
• Better for teams
• Ideal for recurring imports

But only if your fields and labels are set up correctly.

Frequently Asked Questions (FAQs) #

1. Can I re-import the same sheet multiple times? #

Yes. Existing contacts will update; new ones will be added.

2. Can I use multiple Google Sheets? #

Yes. You can connect and import from multiple sheets.

3. What happens to duplicate phone numbers? #

They are updated, not duplicated.

4. Can I auto-sync sheets continuously? #

No auto-sync yet. Imports are manual but fast.

5. Do I need to format phone numbers in a specific way? #

Yes. Use country code + number only. No spaces or symbols.

6. Can I assign labels during import? #

Yes. Labels are mandatory and recommended.

7. Can I import custom fields via Sheets? #

Yes, as long as the field exists in LandinChat.

8. What’s the most common mistake? #

Mismatched column names and missing custom fields.

9. Is this better than CSV import? #

For recurring updates—yes. For one-time bulk—CSV is fine.

10. Who should use Google Sheets integration? #

Teams managing:

• Daily leads
• Sales handoffs
• Ops-managed contact lists
• Shared databases