Google Sheets Extension

The Fairing Google Sheets extension allows you to sync your Fairing response data with Google Sheets.

The Fairing Data Sync Google Sheets extension enables you to easily pull your Fairing data directly into a Google Sheet for further analysis and joining with other data sources.

Step 1: Install Fairing Data Sync

  1. Visit the Google App Marketplace here

Step 2: Activate the Extension

  1. Select 'Extensions' from the Google Sheets Header
  2. Select 'Fairing Data Sync'
  3. Select 'Sync'

Step 3: Insert your API Key

  1. You have a unique, revokable API Key under Integrations >> Google Sheets >> Connect/Settings
Integrations >> Google Sheets

Integrations >> Google Sheets

Note: You can also use the API key on your Fairing Account page under 'Secret Token' (you cannot revoke access for this token)

  1. Click 'Enable' to generate a unique API key
    1. You can click 'Revoke Access' at any time to invalidate the token
    2. You can again click 'Enable' to generate a new unique token
  2. Enter the API key into the extension panel and click 'Save'

Step 4: Configure Reports

  1. You can configure a report per sheet, to get started click 'Add new data report'
  2. For each report you have the option to select the question, date range, and columns
  3. Once the report settings have been configured, click 'Load Responses' (this will also save the report)
    1. Note: Data will always appear in A1 for the sheet you are currently on
  4. Click the back arrow in the top left of the data sync modal to return to see your existing reports or to create a new report
  5. To remove an existing report, you can X out the report on the main page or override the existing data by creating or editing a report for the same sheet
Remove or edit an existing report

Remove or edit an existing report

Step 5: Refresh Reports

  1. Click the refresh icon for an existing report to get the latest data
    1. Note: If the time period is Today, Last 7 days or Last 30 days - the data will be refreshed and overriden with the latest data relative to the date the button is clicked. If the time period is All Time or Year to Date, the data will be refreshed and any new data will be added to the top of the report (existing data will be pushed down).
Refresh report data

Refresh report data

Step 6: Schedule Reports

  1. Add a schedule to your document by clicking 'Add Schedule'
    1. Note: You can only have one schedule per document, each saved report configuration will run on the schedule set
Add Schedule

Add Schedule

  1. You have the option to set a hourly, daily, weekly or monthly sync - depending on the sync frequency, different settings will be available (ex. for weekly you will select the days of the week vs monthly you will select the day of the month)
    1. Note: Time Zone will always default to the time zone originally set when setting up the Fairing Data Sync
Schedule Settings

Schedule Settings

  1. A schedule can be edited or removed at any time
Edit or Delete a Schedule

Edit or Delete a Schedule