SCRT-HQ / PSGSuite

Powershell module for Google / G Suite API calls wrapped in handy functions. Authentication is established using a service account via P12 key to negate the consent popup and allow for greater handsoff automation capabilities
https://psgsuite.io/
Apache License 2.0
234 stars 67 forks source link

Add-GSSheetValues - Create TAB in sheet #294

Open thomasbonsirven opened 4 years ago

thomasbonsirven commented 4 years ago

Hello,

I have not found the solution to create new tab ("sheet" in a google sheet file). I need to create new excel sheets every month in an already created file.

So I think this is a new function to set up.

FISHMANPET commented 4 years ago

This was also requested in #125, I've been working on a number of spreadsheet improvements and creating new tabs is on my list.

thomasbonsirven commented 4 years ago

Hello, thanks for your awnser.

Great for the new function. Thank you, but sorry for my next question... Do you have any idea how long it will take? Need help ?

FISHMANPET commented 2 years ago

I realize it's been a long time, but I'm getting ready for a new release, that includes a lot of work that makes it easy to work with tabs in spreadsheets. I think I can easily add some functionality to Add-GSSheetValues that will make this a lot easier. Cases I can think to add: