The Eniq.ai integration with Google Spreadsheets allows you to automatically export analysis results to Google Spreadsheets. This is useful when you need to store processed results in a separate document, share them with your team, use them for reporting, or continue working with the data manually.
With this integration, you can configure which prompts should be exported, which fields should be transferred to the spreadsheet, how columns should be named, and how sheet names should be generated in Google Spreadsheets.
Preparing the Google Spreadsheet
Before creating the integration, you need to prepare the Google Spreadsheet to which the data will be exported.
First, create a new Google Spreadsheet or open an existing one. Eniq.ai will transfer the analysis results to this document.
Then grant access to the spreadsheet to the Eniq.ai technical account. To do this:
Click Share in the upper-right corner of the Google Spreadsheet.
In the field for adding users, enter the technical account address:
Select the Editor access level.
Click Send or Share.
Editing access is required so that Eniq.ai can create sheets, add columns, and write analysis results to the spreadsheet.
Important: if access to the spreadsheet is not granted, Eniq.ai may not be able to access the document, and data export may not work correctly.
To configure the integration, you also need to copy the Google Spreadsheet ID. The spreadsheet ID is located in the document URL. This is the value that must be entered in Eniq.ai in the Spreadsheet ID field.
How to Add the Integration in Eniq.ai
To create an integration with Google Spreadsheets, go to the Integrations section in the left-hand menu of Eniq.ai.
In the top integration menu, select the Google Sheets tab. If no integrations have been created yet, the system will display a message stating that no Google Spreadsheet integrations have been configured. To create the first integration, click Add Integration.
Completing the Integration Settings
After clicking Add Integration, the integration creation window will open.
Complete the Integration Name, Description — optional — and Spreadsheet ID fields by entering the Google Spreadsheet ID copied from the document URL.
In the Sheet Naming Configuration section, select which components should be used to generate sheet names. For example, you can include the year, month, prompt name, representative, or department. At least one component must be enabled. We recommend using only the prompt name.
In the Format Options section, you can select the month display format and the separator symbol between the components of the sheet name.
At the bottom of the window, there is an Active toggle. When enabled, the integration is active and can transfer data to the Google Spreadsheet. To temporarily disable the integration, turn off the toggle.
After completing all settings, click Test Connection. This checks whether the Spreadsheet ID is correct, whether Eniq.ai has access to the Google Spreadsheet, and whether the system can connect to the document.
If the connection test is successful, click Create.
What the Created Integration Looks Like
After the integration is created, it will appear in the list of Google Spreadsheet integrations.
The list displays the integration name, a link to the Google Spreadsheet, mapping settings, the date of the last synchronization, the integration status, and available actions.
In the Spreadsheet column, click Open Spreadsheet to quickly access the Google Spreadsheet receiving the exported data.
The Last Sync column displays the time of the most recent export. If synchronization has not yet occurred, it will display Never.
The Status column shows whether the integration is active. If the integration is enabled, the status Active will be displayed.
The Actions column contains icons for editing the integration, starting synchronization, and deleting the integration.
Configuring Prompt Mapping
After creating the integration, you need to specify which prompts should be exported to the Google Spreadsheet.
To do this, click Prompt Mappings in the row of the required integration.
The Prompt Mapping window will open. It displays a list of available prompts. Each prompt has an Export to Google Spreadsheets toggle. To export the results of a specific prompt to the Google Spreadsheet, enable the toggle next to that prompt.
Important: only prompts with export enabled will be exported to the Google Spreadsheet.
After selecting the required prompts, click Save Prompt Mappings.
System Columns Added Automatically
During export, Eniq.ai automatically creates and fills in the first five columns of the Google Spreadsheet:
Analysis Date — the date when the analysis was performed.
Entity Creation Time — the date and time when the analyzed entity was created.
Entity Type — the type of entity.
Entity ID — the entity identifier.
Responsible User — the responsible user.
These are standard system columns and are populated automatically. They do not need to be added separately through field mapping.
Field mapping is used to configure additional columns that should appear after the standard system data. These may include scores, summaries, recommendations, client information, metadata, and other fields from the selected prompt results.
Configuring Field Mapping
Field mapping determines which data from the analysis results will be transferred to the Google Spreadsheet and which columns the data will appear in.
To configure it, click Field Mapping in the row of the required integration. The Field Mapping Configuration window will open.
First, select a prompt in the Prompt field. The system will then display all available fields that can be exported.
Fields may be grouped by type:
Standard Fields — standard data such as the analysis date, ID, user, and other information.
Content Fields — prompt analysis results such as scores, recommendations, summaries, and other data.
Metadata — additional information, such as the department or representative.
System Fields — system information related to the analysis.
To add a field to the export, select it from the list or click Add Mapping. The field will appear in the Field Mappings section.
You can configure the following settings:
Source Field — the field from Eniq.ai.
Target Column — the name of the column in the Google Spreadsheet.
Format — the data format, such as string, number, date, JSON, and others.
After completing the configuration, click Save Mappings. Eniq.ai will then automatically transfer analysis results to the Google Spreadsheet according to the selected prompts and configured field mappings.