> Markdown versions of all pages of this connector library are available by appending `.md` to the page URL. For the full index of connectors, see [llms.txt](https://connectors.appmixer.com/llms.txt).

# appmixer.googleAds.core.AddUsersFromCSVToUserList

- Component: `appmixer.googleAds.core.AddUsersFromCSVToUserList`
- Kind: Action
- Version: 1.0.0
- Visibility: Public
- Connector: [appmixer.googleAds 1.3.3](https://connectors.appmixer.com/connector/appmixer.googleAds/1.3.3.md)
- Component page: <https://connectors.appmixer.com/connector/appmixer.googleAds/1.3.3/component/appmixer.googleAds.core.AddUsersFromCSVToUserList>

Upload a CSV file of users to a Google Ads Customer Match user list via the Offline User Data Job API. Supports large files by processing them in batches across multiple continuations. Provide a schema mapping for each upload so different CSV headers can be mapped explicitly.

## Input ports

### Port `in`

| Field | Type | Description |
| --- | --- | --- |
| CSV File (`fileId`) | filepicker | A CSV file containing user data. Use the Schema field below to map each CSV header to the Google Ads identifier it represents. |
| Customer ID (`customerId`) | text | Google Ads customer ID (digits only, e.g. 1234567890). Hyphens are ignored. |
| Login Customer ID (`loginCustomerId`) | text | The Google Ads Manager Account (MCC) ID. Required when accessing accounts managed through an MCC hierarchy. Format: 10-digit number, e.g. 1234567890. See https://developers.google.com/google-ads/api/docs/concepts/call-structure#login-customer-id |
| User List ID (`userListId`) | text | Numeric ID of the Customer Match user list to upload users into. |
| Upload Mode (`uploadMode`) | select | ADD appends users to the list. REPLACE removes all existing users and replaces them with this upload. |
| Schema (`schema`) | expression | Required mapping between CSV headers and Google Ads identifiers. This component does not infer identifiers from header names. |
| Column Separator (`columnSeparator`) | text | Character used to separate columns in the CSV file. Default is a comma (,). |
| Ad Personalization Consent (`adPersonalization`) | select | Consent status for ad personalization. Required by EU User Consent Policy. |
| Ad User Data Consent (`adUserData`) | select | Consent status for use of user data for ads. Required by EU User Consent Policy. |

## Output ports

### Port `out`

| Field | Type | Description |
| --- | --- | --- |
| Total Users Uploaded (`totalUsers`) | integer | - |
| Total Rows Skipped (`totalSkipped`) | integer | - |
| Total Rows in File (`totalRows`) | integer | - |
| Job Resource Name (`jobResourceName`) | string | - |
| API Errors (`errors`) | array | - |
| Internal Errors (`internalErrors`) | array | - |
| Success (`success`) | boolean | - |

### Port `progress`

| Field | Type | Description |
| --- | --- | --- |
| Status (`status`) | string | - |
| Message (`message`) | string | - |
| Total Rows (`totalRows`) | integer | - |
| Last Processed Row (`lastProcessedRow`) | integer | - |
| Total Users Uploaded (`totalUsersUploaded`) | integer | - |
| Percentage (`percentage`) | integer | - |
| Elapsed Seconds (`elapsedSeconds`) | integer | - |
| ETA (seconds) (`eta`) | integer | - |

## Full metadata (component.json)

```json
{
  "name": "appmixer.googleAds.core.AddUsersFromCSVToUserList",
  "description": "Upload a CSV file of users to a Google Ads Customer Match user list via the Offline User Data Job API. Supports large files by processing them in batches across multiple continuations. Provide a schema mapping for each upload so different CSV headers can be mapped explicitly.",
  "author": "Appmixer <info@appmixer.com>",
  "version": "1.0.0",
  "auth": {
    "service": "appmixer:googleAds",
    "scope": [
      "https://www.googleapis.com/auth/adwords"
    ]
  },
  "quota": {
    "manager": "appmixer:googleAds",
    "resources": "requests"
  },
  "inPorts": [
    {
      "name": "in",
      "schema": {
        "type": "object",
        "properties": {
          "fileId": {
            "type": "string"
          },
          "customerId": {
            "type": "string"
          },
          "loginCustomerId": {
            "type": "string"
          },
          "userListId": {
            "type": "string"
          },
          "uploadMode": {
            "type": "string"
          },
          "schema": {
            "type": "object"
          },
          "columnSeparator": {
            "type": "string"
          },
          "adPersonalization": {
            "type": "string"
          },
          "adUserData": {
            "type": "string"
          }
        },
        "required": [
          "fileId",
          "customerId",
          "userListId",
          "schema"
        ]
      },
      "inspector": {
        "inputs": {
          "fileId": {
            "type": "filepicker",
            "label": "CSV File",
            "tooltip": "A CSV file containing user data. Use the Schema field below to map each CSV header to the Google Ads identifier it represents.",
            "index": 1
          },
          "customerId": {
            "type": "text",
            "label": "Customer ID",
            "tooltip": "Google Ads customer ID (digits only, e.g. 1234567890). Hyphens are ignored.",
            "index": 2
          },
          "loginCustomerId": {
            "type": "text",
            "label": "Login Customer ID",
            "tooltip": "The Google Ads Manager Account (MCC) ID. Required when accessing accounts managed through an MCC hierarchy. Format: 10-digit number, e.g. 1234567890. See https://developers.google.com/google-ads/api/docs/concepts/call-structure#login-customer-id",
            "index": 3
          },
          "userListId": {
            "type": "text",
            "label": "User List ID",
            "tooltip": "Numeric ID of the Customer Match user list to upload users into.",
            "index": 4
          },
          "uploadMode": {
            "type": "select",
            "label": "Upload Mode",
            "tooltip": "ADD appends users to the list. REPLACE removes all existing users and replaces them with this upload.",
            "index": 5,
            "defaultValue": "ADD",
            "options": [
              {
                "label": "Add (append)",
                "value": "ADD"
              },
              {
                "label": "Replace (overwrite)",
                "value": "REPLACE"
              }
            ]
          },
          "schema": {
            "type": "expression",
            "levels": [
              "ADD"
            ],
            "index": 6,
            "label": "Schema",
            "tooltip": "Required mapping between CSV headers and Google Ads identifiers. This component does not infer identifiers from header names.",
            "fields": {
              "csvHeader": {
                "type": "text",
                "label": "CSV Header",
                "tooltip": "The header name in the CSV file. Matching is case-insensitive."
              },
              "googleAdsType": {
                "type": "select",
                "label": "Google Ads Type",
                "tooltip": "The Google Ads identifier type represented by this CSV column.",
                "options": [
                  {
                    "value": "email",
                    "label": "Email"
                  },
                  {
                    "value": "phoneNumber",
                    "label": "Phone Number"
                  },
                  {
                    "value": "firstName",
                    "label": "First Name"
                  },
                  {
                    "value": "lastName",
                    "label": "Last Name"
                  },
                  {
                    "value": "countryCode",
                    "label": "Country Code"
                  },
                  {
                    "value": "postalCode",
                    "label": "Postal Code"
                  },
                  {
                    "value": "mobileId",
                    "label": "Mobile Device ID"
                  },
                  {
                    "value": "thirdPartyUserId",
                    "label": "Third Party User ID"
                  }
                ]
              }
            }
          },
          "columnSeparator": {
            "type": "text",
            "label": "Column Separator",
            "tooltip": "Character used to separate columns in the CSV file. Default is a comma (,).",
            "index": 7,
            "defaultValue": ","
          },
          "adPersonalization": {
            "type": "select",
            "label": "Ad Personalization Consent",
            "tooltip": "Consent status for ad personalization. Required by EU User Consent Policy.",
            "index": 8,
            "options": [
              {
                "label": "Unspecified",
                "value": ""
              },
              {
                "label": "Granted",
                "value": "GRANTED"
              },
              {
                "label": "Denied",
                "value": "DENIED"
              }
            ]
          },
          "adUserData": {
            "type": "select",
            "label": "Ad User Data Consent",
            "tooltip": "Consent status for use of user data for ads. Required by EU User Consent Policy.",
            "index": 9,
            "options": [
              {
                "label": "Unspecified",
                "value": ""
              },
              {
                "label": "Granted",
                "value": "GRANTED"
              },
              {
                "label": "Denied",
                "value": "DENIED"
              }
            ]
          }
        }
      }
    }
  ],
  "outPorts": [
    {
      "name": "out",
      "schema": {
        "type": "object",
        "example": {
          "totalUsers": 150,
          "totalSkipped": 3,
          "totalRows": 153,
          "jobResourceName": "customers/1234567890/offlineUserDataJobs/456",
          "errors": [],
          "internalErrors": [],
          "success": true
        },
        "properties": {
          "totalUsers": {
            "type": "integer",
            "title": "Total Users Uploaded"
          },
          "totalSkipped": {
            "type": "integer",
            "title": "Total Rows Skipped"
          },
          "totalRows": {
            "type": "integer",
            "title": "Total Rows in File"
          },
          "jobResourceName": {
            "type": "string",
            "title": "Job Resource Name"
          },
          "errors": {
            "type": "array",
            "title": "API Errors",
            "items": {
              "type": "string"
            }
          },
          "internalErrors": {
            "type": "array",
            "title": "Internal Errors",
            "items": {
              "type": "string"
            }
          },
          "success": {
            "type": "boolean",
            "title": "Success"
          }
        }
      }
    },
    {
      "name": "progress",
      "schema": {
        "type": "object",
        "example": {
          "status": "in-progress",
          "message": "Uploaded 75 users (50%)",
          "totalRows": 153,
          "lastProcessedRow": 75,
          "totalUsersUploaded": 75,
          "percentage": 50,
          "elapsedSeconds": 120,
          "eta": 120
        },
        "properties": {
          "status": {
            "type": "string",
            "title": "Status"
          },
          "message": {
            "type": "string",
            "title": "Message"
          },
          "totalRows": {
            "type": "integer",
            "title": "Total Rows"
          },
          "lastProcessedRow": {
            "type": "integer",
            "title": "Last Processed Row"
          },
          "totalUsersUploaded": {
            "type": "integer",
            "title": "Total Users Uploaded"
          },
          "percentage": {
            "type": "integer",
            "title": "Percentage"
          },
          "elapsedSeconds": {
            "type": "integer",
            "title": "Elapsed Seconds"
          },
          "eta": {
            "type": "integer",
            "title": "ETA (seconds)"
          }
        }
      }
    }
  ],
  "icon": "(data URI omitted)"
}
```
