How to Import Contacts from Google Sheets

Connect Google Sheets to WhatChimp and import contacts directly

Updated 10 February 2026

Integrating Google Sheets with Whatchimp allows you to import and manage contacts efficiently. Before proceeding, it’s crucial to set up your custom fields and labels to ensure proper data mapping and segmentation. Follow the Manage Custom Fields and Labels Guide first, then continue with this guide for Google Sheets integration.

Prerequisites

Before you begin, ensure that you have:

  • A Google account with Google Sheets access

Video

1: Sign in to Your Whatchimp Account

  • Navigate to Settings under the Management section.
  • Click on Google Sheets Integration.

2: Connect Your Google Account

  • Click Connect Google Account.

  • Select the Google account where your sheets are stored.

  • Grant necessary permissions and click continue

  • Your Google account is now connected.

  • (Optional) You can connect multiple Google accounts.

3: Create or Use an Existing Google Sheet

Option 1: Create a New Sheet

  • Select your connected Google account.
  • Enter a name for the new sheet.

  • Add headers using alphanumeric characters (e.g., phone_number, name, company).

  • Click Save to create the sheet.
  • Click the View icon to open the sheet in a new tab.

  • Enter contact data:
  • Phone Number (without special characters, only country code and number)
  • Name
  • Company Name (or any other custom field)

Option 2: Add an Existing Sheet

  • Open your existing Google Sheet.
  • Copy the Sheet ID from the URL.

  • Go back to Whatchimp and click Add Existing Sheet.

  • Select your connected Google account.
  • Paste the copied Sheet ID and click Save.

  • Your existing sheet is now integrated.

4: Prepare for Contact Import

  • Ensure your custom fields in Google Sheets match those in Whatchimp.
  • Create a custom field in Whatchimp:
  • Click Custom Fields.

  • Enter the field name (e.g., Company Name).
  • Choose the reply type (e.g., Text) and Save.

  • Create a Label to categorize imported contacts:
  • Go to Labels.

  • Enter a name for the label (e.g., Test) and Save.

5: Import Contacts

  • Go to Subscriber Manager.
  • Click Options > Import Subscribers.

  • Select the appropriate Google Sheet.

  • Choose the Label you created.

  • Map fields from the sheet to Whatchimp:
  • Phone Number → Phone Number
  • Name → Subscriber Name
  • Company → Custom Field: Company

  • Click Confirm.
  • Your contacts are now successfully imported into Whatchimp.

Your contacts are now imported and ready for broadcasting and automation.

More in Subscriber Manager