How to Import WhatsApp Contacts from a Google Sheet

One of the most used and valuable features of BotSailor is broadcasting WhatsApp messages to the imported contacts or subscribers. Before, BotSailor was only allowed to import subscribers or contacts from a CSV file, but now BotSailor has the option to import WhatsApp contacts from a Google Sheet.

From this article, you will learn how to import subscribers or contacts from a Google Sheet to BotSailor.

To begin with, we have to connect the Google account from which we want to import WhatsApp contacts. To connect the Google account, go through the steps below.

Connect Google Account:

1. Go to BotSailor’s dashboard and then select “Settings” from the left navigation menu and then select Google Sheets.
2. Click on Sign in with Google. It will take you to Google and ask you to login to your account or select your account. After selecting the account, click on continue. Select all the permissions and click on continue again.

Create or import Sheets from your Google Account:

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

Creating a sheet from BotSailor:

1. From the Google Sheets integration page, click on the Create New Sheet
2. Select the Google account if you have multiple accounts added.
3. Provide a title for the sheet.
4. Click on add header to add a header name for the column. We can add multiple columns. (Column header only allows alpha numeric characters; we can not use space in the header name.)

After creating the sheets successfully, you need to add contacts to the sheet. Click on the view button and add contacts there.

Importing a Sheet from Google Account:

You just need to click on the Add Existing Sheet button, then select the Google account and enter the sheet ID. The Sheet ID can be copied from the sheets URL. Please check the attached screenshot.

After being created or added, the sheets will be available for importing contacts and will be visible in a list.

Importing Contacts from Google Sheet:

To import WhatsApp subscribers from Google Sheets to BotSailor, we need to go to WhatsApp Subscriber Manager and then follow the below steps:

1. From the WhatsApp Subscriber Manager, go to options and select the Import Subscribers option.
2. BotSailor will open a modal and ask you to select the Google Sheet from which you want to import WhatsApp subscribers.
3. After selecting the sheet, two samples of data will be shown, and there will be a map button.
4. Click on the Map button and select the Sheet column and map it to the BotSailor’s Data field. For example, the sheet's phone number column should be mapped to BotSailor’s subscriber phone number field, and the name should be mapped to subscriber name.
5. If there are more data columns in the sheet, they should be mapped for custom fields.
6. After mapping all the data fields, click on the confirm button.

That wraps it up; the contacts from the Google sheet will be imported to the BotSailor’s WhatsApp subscriber list.

Enhance Your Broadcasts with Personalization

Once you’ve successfully imported your WhatsApp contacts from a Google Sheet into BotSailor, you can take your messaging campaigns to the next level by personalizing your broadcasts. Personalized messages have a greater impact and resonate more with your audience.

Learn how to create personalized broadcast messages with different data on WhatsApp in our detailed guide: How to Create a Personalized Broadcast Message with Different Data on WhatsApp. This step-by-step tutorial will show you how to utilize dynamic variables for sending tailored messages that include names, order details, or any other custom information.

By combining Google Sheets import with personalization features, you can unlock the full potential of BotSailor to deliver effective and meaningful communication to your audience.

Related Blogs:

Automatically Broadcast your New WordPress Blog post to WhatsApp Subscribers with BotSailor