Want to bulk import your contacts into BotCommerce? With the Google Sheets integration, you can easily upload and organize your WhatsApp subscribers directly from a spreadsheet. This tutorial walks you through connecting your Google account, creating or linking a sheet, and importing your subscriber data in just a few steps.

Connect the Google Account

To import subscribers from a Google Sheet, you must add the Google account to BotCommerce. From your dashboard, click on Settings, then select Google Sheet. Click on Sign in with Google.

If you’re already logged into your Google account, select the account. Then, click Continue. Allow all the permissions requested, then click Continue again.

After connecting the Google account, you will have two options: create a Google Sheet and add your subscribers’ information to it, or import an existing one that already has it.

Create a new sheet

To create a new sheet, click on the Create New Sheet button. Select your Google account and give the sheet a title.

Now, click on the header button. Add the headers for the data you wish to import. Headers work as the column names of the Google Sheet. Note that they should only contain alphanumeric characters and have no spaces. After adding your headers, click on the Save button.

As soon as the sheet is created, it will be shown in the list. Click on the View button to add data to the sheet.

Finally, add the data of the subscribers you wish to import into the app.

Add an existing sheet

To add existing sheet, just click on the Add Existing Sheet button.

Select the account from the list. You will be asked to provide a Sheet ID.

To obtain it, open your sheet on a new tab. Copy the part of the URL that comes after /d/ (as shown on the image).

Paste the ID on the corresponding field. Click on Save.

Import the subscribers

Now, you can import contacts from the sheet to BotCommerce. To do that, go to the WhatsApp Subscriber Manager. From the Options menu, click on Import Subscribers.

Select the Google Sheet. It will show two samples data.

Click on the Map button. Select the file header. This is actually the column header of the sheet. Select the Subscriber field for which the column data will be used. For example, if you have a column named Phone_Number you can map it to the Phone Number Data Field on the app.

Repeat this process as many times as needed to map every column on your Google Sheet.

Finally, click on the Confirm button. The subscribers from the Google Sheet will be imported.