How to Import WhatsApp Contacts from a Google Sheet to BotSailor

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.