Adding new sheet to an existing spreadsheet in Google Sheets

App Building
1

Hi,

I'm trying to add a new sheet/page to an existing spreadsheet but can not figure how to do it.

Is there any way to do this?

2

Hi @dadiomars

Thanks for reaching out! Our Google Sheets integration supports copying an existing sheet into another spreadsheet.

If you want to create a brand new spreadsheet in a new tab of an existing spreadsheet, this is the best solution I've found with our integration:

1. Write a query using the action type "Create a spreadsheet"

2. Copy this new spreadsheet over to a new tab of your existing spreadsheet using the "Copy a single sheet to another spreadsheet" action

3. Write another query that deletes the sheet you created in step 1

Unfortunately, it's a bit tedious! Our integration doesn't support every single Google Sheets API functionality, so you might be able to do this in a more efficient way by connecting to Google Sheets via a Rest API resource.