Integrate with Google Sheets

This guide will teach you how to export events, and define and publish annotations to Google Sheets.

Integrate with Google Sheets

  1. In Formant, in the upper-left corner, open the menu and click Settings.
  2. Click Integrations. Next to Google Sheets, click Connect.
  3. Choose the Google account you want to connect to Formant.
  4. Allow Formant edit, create, and delete access to your spreadsheets

You will now be able to export export events to Google Sheets, and annotations templates can be defined from Google Spreadsheet.

Export events to Google Sheets

  1. Navigate to the device whose events you want to export
  2. In the upper-right corner, click the three dots >> Export...
Exporting data.

Exporting data.

  1. You will now be able to select the time range of data to export. You should see the Google Sheets option:
Choosing data range and export method.

Choosing data range and export method.

Define annotation templates and publish annotations in Google Sheets

You can use Google Sheets to define annotation templates. You can also publish annotations to Google Sheets for analysis.

For more information, see Mission and data annotations.

See also

👋

If you notice an issue with this page or need help, please reach out to us! Use the 'Did this page help you?' buttons below, or get in contact with our Customer Success team via the Intercom messenger in the bottom-right corner of this page, or at [email protected].