The requested URL /v4/spreadsheets/2 was not found on this server

When trying to update a row in a Google sheet using the Row ID from a Google Sheets trigger, the developer will encounter an error, "The requested URL /v4/spreadsheets/2 was not found on this server".

ANALYSIS

The Google Sheets app was implemented using different API versions for the Google Sheets trigger and for the Google Sheets actions. This means the Row ID that is returned by the trigger is not compatible with the Row ID input that the Google Sheets "update row" action uses.

STEPS TO REPRODUCE

1. Create a spreadsheet in Google Sheets, and populate it with a few rows of data
2. Create a Google Sheets connection in Workato
3. Create a Workato recipe which uses the Google Sheets "New row in sheet" trigger
4. Add a Google Sheets "Update a row' action to the recipe
5. Map the Row ID from the trigger to the Row ID in the action
6. Test the recipe. The job will fail with the error described above.