# Error on Google Sheets Workflow

**URL:** <https://community.hubspot.com/t/error-on-google-sheets-workflow/74850>\
**Category:** Data Hub\
**Tags:** workflows\
**Created:** [February 9, 2023, 2:39pm UTC](https://community.hubspot.com/t/error-on-google-sheets-workflow/74850 "2023-02-09T14:39:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krista21](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/krista21/32/6328_2.png) [@Krista21](https://community.hubspot.com/u/Krista21)\
**Post date:** [February 9, 2023, 2:39pm UTC](https://community.hubspot.com/t/error-on-google-sheets-workflow/74850/1 "2023-02-09T14:39:31Z")

</div>

I’ve set up a workflow in Hubspot to update a row in a Google Sheet where the Lookup Column is “Company Name” and the Column to be updated is “Company Status”.

 ![Krista21_0-1675953406803.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/4/84836f5f645dceafe7ce7671684dc9e2ebb9996a.png)

 ![Krista21_1-1675953406642.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/d/d3e0ab94fefa73cf80530fef85d267f0675e4bab.png)

However, in testing the automation with real company data in Hubspot, here’s the error message I received in the event details. Oddly enough, it says “Success” and shows the status code as 400.

 ![Krista21_2-1675953406739.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/e/3ee683bbbf251221310692e16662ff4dc6586f7d.png)

Event

- Invalid input JSON on line 1, column 119: Cannot construct instance of `com.hubspot.googlesheetsintegration.core.models.UpsertRowRequest`, problem: The ID column can’t be changed

Server response

`{"status":"error","message":"Invalid input JSON on line 1, column 119: Cannot construct instance of `com.hubspot.googlesheetsintegration.core.models.UpsertRowRequest`, problem: The ID column can't be changed","correlationId":"123ad87e-c0e2-4e6b-b464-431c4e1e7f17"}`

Does anyone know how I could fix this?

---

<div class="post-metadata">

**Author:** ![kvlschaefer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kvlschaefer/32/71076_2.png) [@kvlschaefer](https://community.hubspot.com/u/kvlschaefer)\
**Post date:** [February 10, 2023, 2:17pm UTC](https://community.hubspot.com/t/error-on-google-sheets-workflow/74850/2 "2023-02-10T14:17:56Z")

</div>

Hi @Krista21,

Thanks for reaching out!

Can I ask you please to review [the steps included in this HubSpot Knowledge Base article here](https://knowledge.hubspot.com/workflows/add-data-to-google-sheets-with-workflows)?

Could you check if your data meets the [requirements for updating Google Sheets](https://knowledge.hubspot.com/workflows/add-data-to-google-sheets-with-workflows#:~:text=set%20up%20identifiers%20to%20determine%20which%20rows%20to%20update%3A) with a workflow?

Thank you!

Best,

Kristen
