Google Sheets integration
ForumScout can automatically export your mentions to a Google Sheets spreadsheet. New mentions sync in the background as your scouts find them.
Connecting Google Sheets
- Go to the Scouts page
- Find the Google Sheets card in the Integrations section at the bottom
- Click Connect
- Authorize ForumScout to access your Google account
ForumScout requests offline access so it can sync data in the background without you being logged in.
Once connected, click Configure to set up which scouts sync and how data is organized.
Configuring the sync
After connecting a spreadsheet, configure how data flows:
Selecting scouts
Choose which scouts should sync their mentions to the spreadsheet. You can select individual scouts or all scouts.
Combined vs individual tabs
- Combined — All selected scouts write to a single sheet tab
- Individual — Each scout gets its own tab in the spreadsheet
Column mapping
Mentions are synced with the following columns:
- Title
- Snippet
- URL
- Source (platform)
- Date
- Author
How syncing works
Once configured, ForumScout syncs new mentions to your spreadsheet in the background. When a scout finds new posts, they're automatically appended to the configured sheet.
Syncing is one-way — ForumScout writes to the sheet. Editing or deleting rows in the sheet does not affect your ForumScout data.
Disconnecting
To disconnect, go to the Scouts page, find the Google Sheets card in Integrations, and click Disconnect. This stops future syncing but does not delete data already in the spreadsheet.
Tips
- Use individual tabs for reporting — If you report on brand mentions separately from competitor mentions, use individual tabs so each scout has its own clean dataset.
- Build dashboards on top — Use Google Sheets charts or connect the sheet to Looker Studio for custom visualizations.
- Don't edit synced columns — ForumScout appends new rows, so your edits in other columns are safe. But avoid modifying the synced columns or the header row.