Google Sheets#
Every approved member's data flows directly into your Google Spreadsheet — no manual exports.
Setup#
- Create a Google Sheet (or use an existing one)
- Set sharing to Anyone with the link can edit
- Go to Groups → Settings on an enabled group
- Open the Setup tab
- Paste your Google Sheet URL
- Click Verify to test the connection
Once verified, new approved members are appended as rows automatically.
Data columns#
Each row includes:
| Column | Description |
|---|---|
| Name | Member's Facebook name |
| Extracted from membership answers (if found) | |
| Phone | Extracted from membership answers (if found) |
| Group | Group name |
| Answers | Membership question responses |
| Lead score | Calculated engagement score |
| Approved date | When the member was approved |
Per-group sheets#
Each group can connect to a different spreadsheet. Configure the sheet URL in that group's Settings → Setup tab.
Troubleshooting#
Verify fails#
- Confirm the sheet URL is correct (copy from the browser address bar)
- Check that sharing is set to Anyone with the link can edit
- Make sure the sheet is not in a restricted Google Workspace domain
Data not appearing#
- Confirm the group is enabled and members are being approved
- Check that the sheet URL hasn't changed
- New rows appear when members are approved — pending requests are not exported
Related#
- Lead Capture — how emails and phones are extracted
- Webhooks — send data to other apps