Services Plugins FAQs

Google sheet service / update title

Hello,

In order to change the title of the spreadsheet, I used the action “update a spreadsheet” with the following JSON :

{“requests”:[{“updateSheetProperties”:{“properties”:{“title”:“myCustomSheet”}}}]}

but it doesn’t work … :frowning:
If someone can help, welcome !!!

Hello, @fpoinsard!

Thanks for reaching out!

Please be so kind and make sure that you have done the Event with the action “Update a spreadsheet” with the following JSON:
{ “requests”: [{“updateSpreadsheetProperties”: { “properties”:{“title”: “My New Title”},“fields”: “title” } }]}

Could you please update me if the suggested solution helped? Thank you.

Have a nice day!
Regards,

Hello Lera,
Thanks for your answer :slight_smile:
I paste the JSON you gave me :
image
But unfortunatley it returned an error :frowning: :flushed:
image
Thanks to tell me,
Regards,
François

Hello, @fpoinsard!

François, I have checked the action “Update a spreadsheet” with this JSON once again and I suppose that the error cause is the type font of quotes. The quotes must be like this "", not “”

{ "requests": [{ "updateSpreadsheetProperties": { "properties": { "title": "Test ZQ" }, "fields": "title" } }] }

Please update the action once again and let me know if it works properly. Thank you.

Regards,

Yes, it’s working perfectly now !!! Thanks for your support !

@fpoinsard , you’re always welcome! Thanks for your feedback, I’m glad it worked :slight_smile:

If you like our plugin so far, could you please rate it by going to the Plugins tab in Bubble editor? :pray:
You can find the plugin by name and give it as many stars as it deserves. The more feedback we get, the more motivated we are to build great plugins!

Thanks in advance!
Have a good day. :wink:

I will do :+1:
Thanks again for your answer !!!

1 Like