Google Sheets Export
Automatically sync approved member data to a Google Sheet in real time. Every time GroupHunter approves a member, their contact info, answers, and lead score are added as a new row.
Setup
Google Sheets is configured individually per group in Per-Group Settings.
Step 1: Prepare Your Google Sheet
- Open Google Sheets and create a new sheet (or use an existing one)
- Click Share in the top-right
- Click Change to anyone with the link
- Set the role to Editor
- Click Copy link
Warning — The sheet must have Editor access. Viewer-only links will fail verification.
Step 2: Connect in GroupHunter
- Go to Groups in the sidebar
- Click Settings next to the group you want to connect
- Open the Setup tab
- Paste the Google Sheet link into the Google Sheet URL field
- Click Verify — GroupHunter tests the connection and writes a test row
- Click Save Settings
If verification succeeds, the field turns green with a confirmation message. If it fails, check the sheet permissions.
What Data Gets Written
Each approved member gets a new row with:
| Column | Example |
|---|---|
| Name | Jane Doe |
| jane@example.com | |
| Phone | +1 555 123 4567 |
| Group | My Facebook Group |
| Lead Score | 75 |
| Question 1 Answer | "Yes, here's my email: jane@example.com" |
| Question 2 Answer | "I'm a digital marketer" |
| Approved At | 2026-01-15 10:30:00 |
Columns for questions match your group's membership questions.
Multiple Groups, One Sheet
You can connect multiple groups to the same Google Sheet — data from all groups goes into the same sheet as separate rows, with the Group column identifying the source.
Alternatively, connect each group to a different tab or sheet for cleaner organisation.
When Data Gets Written
Data is written at the moment of approval — whether the member was auto-approved by GroupHunter or manually approved by you. If a member was approved before you set up the Sheets connection, they won't be retroactively added.
Troubleshooting
| Problem | Solution |
|---|---|
| Verify button returns error | Check the sheet URL is correct and permissions are set to Editor |
| Data not appearing after approval | Make sure the extension was running and the group is enabled |
| Wrong columns in sheet | Re-verify the connection to re-map columns |
| Sheet deleted or moved | Update the URL in group settings and re-verify |
Using the Data
Once data is in Google Sheets, you can:
- Filter and sort leads by email, score, or group
- Connect to email marketing tools using Zapier/Make
- Build charts and reports
- Share with your team
Tip — Add conditional formatting to highlight rows with high lead scores (e.g. 70+) to quickly identify your best leads.