Export to Google Sheet

Our Google Sheets integration allows you to export all profile data, except images. These can be exported separately by our support team.

Create your spreadsheet

In Google Sheets (or Google Drive) select the option to create a new spreadsheet.

If you want to export your profile data to an existing Google Sheet, add a new blank worksheet tab.

Open your directory

1. Log in to your Community Box dashboard
2. Open the directory you want to export profiles from
3. Select Integrations
4. Select Google Drive
5. Export from sheet

Share your spreadsheet with Community Box

1. Copy the integration email address provided in the dashboard
2. Open your spreadsheet in Google Sheets
3. Click share
4. Paste the email address into the sharing field

You need to set the permission to Editor. This only gives Community Box permission to edit that specific Google Sheet; we cannot access any additional Google Drive data.

You can also uncheck the option notify people.

Click Share to complete this step.

Find your spreadsheet identifier

Next, copy the spreadsheet ID from the address bar. This is an example Google Sheet link:

docs.google.com/spreadsheets/d/1AbCdeFGhijkLMnopQRsTuvWxYZ123456/edit

The spreadsheet ID is the section in bold, between /d/ and /edit.

Connect your spreadsheet

1. Return to your Community Box dashboard
2. Paste the spreadsheet ID into the spreadsheet identifier field
3. Click Connect

If the connection is successful, Community Box will confirm that the spreadsheet has been connected, and you will see a new option to select a worksheet. If your spreadsheet contains multiple sheets, choose the one you want to export the data to.

Launch the export

Click on the Launch export button, and Community Box will begin the export.

Once the export is complete, click Close.

Review your exported profiles

After the export is complete, return to your spreadsheet. You should now see the profiles from your directory.

Export profile images

If you would like to also export your profile images, please reach out to us and our support team can manually export these as a zip file. Send us a message via your Community Box dashboard or email help@communitybox.co