In this section you will learn:

  • How to connect amoCRM data import.

Attention! The Google BigQuery integration has to be enabled to use this feature.

Importing data from amoCRM


After enabling this data source, amoCRM data will be uploaded to BigQuery once every 24 hours.

Connecting and configuring


The process of connecting data sources is described in detail in the overview.

After authorization you need to set the data source parameters.

Options description


Display name

The name of the data source. It is displayed in the interface in the list of sources.

Import leads

Enable import of leads data. If this option enabled, updated leads for the previous day will be uploaded.

Leads custom fields

The leads amoCRM custom fields to import.

Import lead name

Indicates whether or not to download leads names. It’s necessary for cases when the leads names contain sensitive information.

Saving, Disconnecting, Disabling data source

To save and enable the data source, click Save.

The Disconnect button is used to revoke the authorization data. The settings are saved.

You can enable or disable the data source at any time by using the switch on the top right.

Where to get leads data

  • amoCrmLeads_{SUBDOMAIN}_{YYYYMMDD} - data for updated “Leads”

Table structures


amoCrmLeads table structure

Field name Type Mode
id INTEGER NULLABLE
name STRING NULLABLE
responsible_user_id INTEGER NULLABLE
created_by INTEGER NULLABLE
created_at INTEGER NULLABLE
updated_at INTEGER NULLABLE
account_id INTEGER NULLABLE
pipeline_id INTEGER NULLABLE
status_id INTEGER NULLABLE
status_name STRING NULLABLE
updated_by INTEGER NULLABLE
is_deleted BOOLEAN NULLABLE
group_id INTEGER NULLABLE
closed_at INTEGER NULLABLE
closest_task_at INTEGER NULLABLE
sale INTEGER NULLABLE
loss_reason_id INTEGER NULLABLE
custom_fields RECORD REPEATED
custom_fields.id INTEGER NULLABLE
custom_fields.name STRING NULLABLE
custom_fields.is_system BOOLEAN NULLABLE
custom_fields.values RECORD REPEATED
custom_fields.values.value STRING NULLABLE
custom_fields.values.enum INTEGER NULLABLE