How to Import WhatsApp Contacts from Google Sheet to Sendwo

Broadcasting WhatsApp messages is a cornerstone of Sendwo's functionality. Previously, importing contact lists was limited to CSV files. However, Sendwo now offers enhanced flexibility by allowing you to import WhatsApp contacts directly from Google Sheets.

This guide will walk you through the process of importing subscribers or contacts from your Google Sheet to Sendwo. The first step involves connecting the Google account containing your WhatsApp contact data. Follow these steps to establish the connection.

Step 1: Connect Google Account:

• To connect your Google Sheet to Sendwo:
• Navigate to your Sendwo dashboard.
• Go to "Settings" in the left-hand menu.
• Select "Google Sheets."
• Click "Sign in with Google."
• Log in to your Google account.
• Allow Sendwo the necessary permissions.

Step 2: Create or import Sheets from your Google Account:

You can either create a sheet from Sendwo itself or import an existing Google Sheets from your account. We will go over both methods.

Creating a sheet from Sendwo:

• To create a new sheet for your Google Sheets integration:
• Navigate to the Google Sheets integration page within Sendwo.
• Select the desired Google account if you have multiple accounts linked.
• Provide a descriptive title for your new sheet.
• Click on 'Add Header' to define a column name.
• Add as many columns as needed. (Please note: Column headers can only contain alphanumeric characters and cannot include spaces.)

Once the sheets are created, click on the 'view' button to add your contacts.

Importing a Sheet from Google Account:

To connect your Google Sheet, simply click "Add Existing Sheet." Select the desired Google account and then paste the Sheet ID into the provided field. You can easily find the Sheet ID from the sheet's URL.

Once created or added, your connected sheets will appear in a list and can be readily used for importing contacts.

Step 3: Importing WhatsApp Subscribers from Google Sheets to Sendwo

To import your WhatsApp subscribers from Google Sheets to Sendwo, follow these simple steps within the WhatsApp Subscriber Manager:

1. Access Import Options:
   • Navigate to the "Options" menu within the WhatsApp Subscriber Manager.
   • Select "Import Subscribers" from the available options.
2. Select Your Google Sheet:
   • A modal will appear, prompting you to choose the Google Sheet containing your subscriber data.
3. Data Mapping:
   • Two sample data rows will be displayed.
   • Click on the "Map" button.
   • Match each column in your Google Sheet to the corresponding data field in Sendwo.
     • For example, map the "Phone Number" column in your sheet to "Subscriber Phone Number" in Sendwo.
     • Similarly, map "Name" to "Subscriber Name".
   • If your sheet includes additional data columns, map them to relevant custom fields in Sendwo.
4. Confirm and Import:
   • Once all data fields are correctly mapped, click the "Confirm" button to initiate the import process.

This completes the process. The contacts from the Google Sheet will be imported into your Sendwo WhatsApp subscriber list.