Google Sheets Integration

How to Use Google Sheets Integration in BDM Lead Collector PRO

This guide will help you set up Google Sheets so that all your leads are automatically saved to a spreadsheet for easy tracking, follow-up, and backup.

Prerequisites

• BDM Lead Collector PRO must be installed and activated.
• Your license must be valid and active.
• You must have a Google account.

---

Step 1: Create a Google Sheet

1. Go to Google Sheets.
2. Click Blank (+) to create a new spreadsheet.
3. In Row 1, enter these column headers:
   
   Name | Email | Mobile | Message | Date
4. Rename the sheet tab (bottom-left) to Sheet1 (default name) or match the sheet tab name you’ll use later.

---

Step 2: Get a Google API Key

A. Enable Google Sheets API

1. Go to the Google Cloud Console.
2. Click Select a project → New Project → Give it a name → Click Create.
3. Go to the Navigation menu > APIs & Services > Library.
4. Search for Google Sheets API and click Enable.

B. Create API Credentials

1. Go to APIs & Services > Credentials.
2. Click Create Credentials → Select API key.
3. Copy the generated API key — you’ll need this in the plugin settings.
4. (Optional but recommended) Click Restrict key:
   • Under “API restrictions”, select Google Sheets API. (If it is not on the list, go to Library and search for Google Sheets API. Click it and then Enable it)
   • Under “Application restrictions”, choose HTTP referrers and allow your domain (e.g. https://yourdomain.com/*).

---

Step 3: Get Your Spreadsheet ID

1. Open your Google Sheet in the browser.
2. Look at the URL:
   
   https://docs.google.com/spreadsheets/d/1ABCdEfGHijKlMNOpQRStUvWXyZ45678yz9/edit#gid=0
3. Copy the long string between /d/ and /edit:
   
   1ABCdEfGHijKlMNOpQRStUvWXyZ45678yz9
4. This is your Sheet ID.

---

Step 4: Configure the Plugin Settings

1. Go to WordPress Admin > BDM Leads > Settings.
2. Scroll down to PRO Features section.
3. Enter the following:
   • Google Sheets API Key → paste the key you copied.
   • Google Sheets Sheet ID → paste the Sheet ID.
4. Click Save All Settings.

---

Step 5: Submit a Test Lead

1. Open your website and use the chatbot or lead form.
2. Submit a test entry.
3. Go back to your Google Sheet — you should see a new row appear with the lead info!

---

Notes & Troubleshooting

Problem	Solution
No rows appear	Make sure the API key and Sheet ID are correct.
API error or rate limit	Check the quota and ensure the API key is unrestricted or properly authorized.
Want to debug?	Check your server error logs or enable WP_DEBUG in WordPress.

---

Advanced: Use with Google Service Account (optional)

If you want more secure or large-scale usage:

1. Create a service account in Google Cloud.
2. Share your spreadsheet with the service account email (like your-service-account@project.iam.gserviceaccount.com).
3. Use OAuth 2.0 credentials instead of API key (not required for basic usage).

---

You’re Done!

You’ve now linked your WordPress site to Google Sheets! Leads will be sent automatically, helping you track submissions in real time.

---

Need Help?

If you need help or want to see a video walkthrough, visit:
https://businessdirectmedia.com/support
or contact Christo Fouché at christo@businessdirectmedia.com