Rename a duplicated gsheet tab

Hey there,

I built a workflow that

  1. duplicates a spreadsheet tab template in another spreadsheet
  2. creates a batch of data to populate the newly created spreadsheet tab
  3. populates the newly created spreadsheet tab

I would like to be able to rename a duplicated spreadsheet from retool in my case.

I believe there is no way to do this atm.

1 Like

Hi @Gregzddm, thanks for sharing this! You're correct that the Google sheets integration does not have a built in action type to rename a sheet or spreadsheet. It would indeed be a feature request to add that action to the integration and create a raw REST resource and query, so I'll log it in internally for our team to consider for future product planning!

Yes this would be great - is there a snippet to work around this today?

Hey @Yang!

As a workaround, you can try setting up a REST API resource to hit the Google Sheets REST API. The specific endpoint you'll like want to hit in order to change the sheet name is this one. Also going to drop links to OAuth2 in their docs as well as our own docs on creating a Google OAuth2 client that you can use for reference when setting up authentication for that resource.

Let me know if you run into any issues and we can help work through them :slightly_smiling_face: