Is it possible to create a sheet if it doesn't exist?

[patrickdevivo]

Hi! This is a really cool extension, thank you for creating it! I'm looking to build some automation that will use this extension to update a Google Sheet with new data on a regular basis. I'd love if I could create a new sheet every time I insert new data, right now it doesn't seem possible as I get the following error if I pass in (FORMAT gsheet, sheet 'Testing123') where Testing123 does not exist within the Google Sheet:

IO Error:
Error writing to Google Sheet: Unable to parse range: Testing123

It would be great if there were another param (format gsheet, sheet 'Testing123', create_sheet true) (or similar) to support this capability. Or, if it already exists, would love to know how to use it!

[mharrisb1]

Super cool idea. @archiewood any thoughts on this?

[archiewood]

I like the idea.

Creating a sheet in an existing spreadsheet seems like it would be quite easy. I suppose syntax wise we'd want to:

copy <table_name> 
to 'https://docs.google.com/spreadsheets/d/11QdEasMWbETbFVxry-SsD8jVcdYIT1zBQszcF84MdE8/edit' 
(format gsheet, create true, sheet 'Woot' );

and / or create_or_replace true

Not sure what the right default behaviour is but I think definely some circumstances where you would want the operation to fail if the sheet does not exist

[archiewood]

A potentially harder case to design syntax for is to create a brand new spreadsheet. You'd return the URL to the user.

COPY <table> TO ? (format gsheet)

Perhaps we'd even want to use the CREATE statement. Not sure if we can hook into that.

Perhaps:

create table new_sheet as from <table> (format gsheet)

create gsheet new_sheet as from <table>

(We don't need to support this, at least initially, just some ideas)