Renaming a sheet in Google Sheets

[Huntington_Learning]

I’m having a similar problem like here, but unfortunately this solution doesn’t seem to be working.

I’m trying to rename a specific sheet within a spreadsheet.

The error I’g getting is:

The operation failed with an error. 400: INVALID_ARGUMENT - Invalid JSON payload received. Unknown name “requests”: Cannot find field.

The body I’m using is:

{
    "requests": [
        {
            "updateSheetProperties": {
                "properties": {
                    "sheetId": {{4.sheetId}},
					"title": "Week of + {{addDays(timestamp; -7)}}"
				},
				"fields": "title"
			}
		}
	]
}

Or, in picture form:

Any hints? Thank you!

[samliew]

@Huntington_Learning looks like your sheetId value has to be in double quotes.

[Huntington_Learning]

Hello @samliew ! Thank you for your response.

I added double quotes, but am unfortunately getting the same error.

Here is what is being passed to make the API call:

I have confirmed the following:

• The SpreadsheetID
• The filter is identifying the correct SheetID
• The JSON is formatted correctly

It seems to be having issues with “requests” despite, to the best of my ability, following the documentation here.

Any other ideas? Thank you very much for your time and consideration.

[samliew]

@Huntington_Learning Ah, you are calling values:batchUpdate when you should just be using :batchUpdate without the values endpoint.

I’ve tested it myself in this example:

You should also probably just double confirm the sheetId is correct by using the List Sheets module before this. My first sheetId was 0, so your sheetId 273710006 might be incorrect.

The double quotes wasn’t correct, it needed to be an integer.

[Huntington_Learning]

Brilliant. The “**values:**batchUpdate” was the culprit!

Thank you so much!

[samliew]

No problem, glad I could help!

1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

others can save time when catching up with the latest activity here, and

• allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!