# Google Sheets Extraction Error Reference

The errors in this guide are specific to Google Sheets integrations. Refer to the [Common SaaS extraction error reference](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/common-saas-extraction-error-reference) for errors common to all SaaS integrations.

These errors will surface in the integration’s [Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs).

* [DUPLICATE HEADER ERROR: SHEET: \[sheet_name\], COL: \[column_name\], CELL: \[cell\]](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#duplicate-column-names)
* [SKIPPING Empty sheet: \[sheet_name\]](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#empty-sheet)
* [SKIPPING Malformed sheet: \[sheet_name\]](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#malformed-sheet)

### Header row contains duplicate values

```
DUPLICATE HEADER ERROR: SHEET: [sheet_name], COL: [column_name], CELL: [cell]
```

`DUPLICATE HEADER ERROR: SHEET: [sheet_name], COL: [column_name], CELL: [cell]`DUPLICATE HEADER ERROR: SHEET: [sheet\_name], COL: [column\_name], CELL: [cell]

| **Applicable to** | Google Sheets v1 integrations |
| --- | --- |
| **Level** | Warning<br><br>the Warning 2 icon<br><br>Data has been replicated, but something may require your attention. |
| **Category** | Sheet setup |
| **Potential cause(s)** | The sheet’s header row contains duplicate values. Header row values are used to create column names and must therefore be unique, as per [Stitch’s requirements](https://help.qlik.com/en-US/stitch/integrations/saas/google-sheets#setup-requirements). |
| **Suggested action(s)** | Modify the sheet’s header row so that all values (column names) are unique, excluding case.<br><br>For example: While `customer_id` and `Customer_ID` may be unique due to case differences, this may still cause errors during extraction and loading. For this reason, column names must be completely unique. |

[Back to Google Sheets error list](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#)  
[Back to top](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#)

### Empty sheet

```
SKIPPING Empty sheet: [sheet_name]
```

`SKIPPING Empty sheet: [sheet_name]`SKIPPING Empty sheet: [sheet\_name]

| **Applicable to** | Google Sheets v1 integrations |
| --- | --- |
| **Level** | Info<br><br>the Success icon<br><br>Everything is working. |
| **Category** | Sheet setup |
| **Potential cause(s)** | The sheet doesn’t have a header row and a data row, as per [Stitch’s requirements](https://help.qlik.com/en-US/stitch/integrations/saas/google-sheets#setup-requirements). Columns in the data row (second row) must all have non-`NULL` values. |
| **Suggested action(s)** | Modify the sheet so that it contains a header row in the first row and a full row of data in the second row. |

[Back to Google Sheets error list](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#)  
[Back to top](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#)

### Malformed sheet

```
SKIPPING Malformed sheet: [sheet_name]
```

`SKIPPING Malformed sheet: [sheet_name]`SKIPPING Malformed sheet: [sheet\_name]

| **Applicable to** | Google Sheets v1 integrations |
| --- | --- |
| **Level** | Info<br><br>the Success icon<br><br>Everything is working. |
| **Category** | Sheet setup |
| **Potential cause(s)** | The sheet isn’t formatted according to [Stitch’s requirements](https://help.qlik.com/en-US/stitch/integrations/saas/google-sheets#setup-requirements). |
| **Suggested action(s)** | Verify that the sheet meets Stitch’s requirements and modify if necessary. |

[Back to Google Sheets error list](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#)  
[Back to top](https://help.qlik.com/en-US/stitch/troubleshooting/integrations/google-sheets-extraction-error-reference#)