Hi,
I’ve followed the instructions on the web to figure out how to change the name on a sheet that I’ve copied in to another Google sheets file. Here’s a blue print and below that a screenshot of the module settings:
blueprint (6).json (159.1 KB)
Thank you kindly
I don’t think you need the replace function in the title.
Just put the new title variable in the double quotes.
Hi, thank you for your comment, much appreciated, I still get the error below:
Hi, in addition to the Title, remove the " around the sheetid value:
“SheetId”: {{50.Sheet ID}},
Ah, you are using the wrong URL. Read the description below the URL field.
Hi, Thank you for your comment. Could you expand on that a bit. The path I am using is https://sheets.googleapis.com/v4 as per directed. What am I missing?
Thank you for the suggestion, but there is something else bugging, same error
You are using the absolute URL (containing the protocol and domain name).
The description is saying that it already does that first part for you, and you only need to use the relative URL to what it is already including for you.
Sorry, still Greek to me :-),l do you mean like this: {{44.id}}:batchUpdate, should that be all I leave in? Can you show me what is to be put in as the URL?
Thank you for your patience and support.
You’re using the full (absolute) URL. But you only need to enter the part of the URL after the /v4/.
So you currently have this: https://sheets.googleapis.com/v4/spreadsheets/{{44.id}}:batchUpdate
Can you change it to this:
/spreadsheets/{{44.id}}:batchUpdate
The tooltip mentions “enter a path relative to https://sheets.google.com/v4/” this means you only need to enter whatever comes after that.
Sure, take a look at this screenshot:
Hope this helps!
Thank you @NolaDigital and @samliew for your instructions, I will test and revert
Hey @Christopher_Lembke,
I just ran it on my account to be sure, this should work:
It seems like it needs that preceding /, even though that’s included in the relative path /v4/
Thank you! You are a star. Worked like a charm
