I wanted to copy one Google Sheets every month and now I have the following questions:
- How to delete this first blank sheet?
2.The copied Sheets have “Copy name”. How to delete this “Copy”? How to assign the old names?
Welcome to the Make community!
Yes, that is possible. Assuming you only have a single Sheet in your Spreadsheet document, you’ll need a minimum of four modules:
1. Get Sheets in Spreadsheet
2. Make a copy of the Sheet in the same Spreadsheet document
3. Delete original Sheet
4. Rename new Sheet
Using Make an API call because there is no module for this. The documentation can be found at “Method: spreadsheets.batchUpdate | Google Sheets | Google for Developers”
Give it a go and let us know if you have any issues!
If you want to learn more about Make, you can read up in the Help Center. I also recommend doing the tutorials in the Make Academy, and learn advanced skills like how to make custom apps to any API in the Make Partner Training Portal - both have certificates for successful completion.
2 Likes