Error on Google Sheets Workflow

Data Hub Data Hub
1

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
Krista21_0-1675953406803.png400×358 32.9 KB

Krista21_1-1675953406642.png
Krista21_1-1675953406642.png265×400 41.2 KB

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
Krista21_2-1675953406739.png320×400 60.6 KB

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?

2

Hi @Krista21,

Thanks for reaching out!

Can I ask you please to review the steps included in this HubSpot Knowledge Base article here?

Could you check if your data meets the requirements for updating Google Sheets with a workflow?

Thank you!

Best,

Kristen