API Update To Google Sheets

I am using sheet.best for an API to read/write to the Google Sheet. I have no issues with reading the data or creating a new entry to the Google Sheet. However, I am not able to update a record.

Any help would be greatly appreciated.

1 Like

You will need to make use of the PATCH command within this API in order to do that.

Thanks, Colin, I now am able to update an individual row with PATCH. However, I have to hard code which row I want to edit. My goal is to be able to click on an item from a list and edit that information.

You should be able to do that with custom actions for individual rows.

I attempted to use the PATCH and the custom action but was unable to update the cell.

Which part was not working? Did you get an error message or anything specific I can help with here?

I add the API Base URL, select PATCH for the Method.Run the test and it comes back successful however nothing changes. I am new to how API’s work so there definitely is a possibility I’m missing something.

I did a quick test and was able to successfully patch a record. Maybe check that the sheets have the correct permissions (anyone can edit) and you are using the right method etc. It may be more beneficial to seek help from sheet.best with this as it seems you are creating a successful connection.

Thank you for your help.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.