Google Sheets : Create a Spreadsheet

[Wolf]

Hello, I am trying to find out information o the Google sheet headers, I can create a new spreadsheet with the info required but there are no headers. I see the notation is for the row fields is Enter the row values here. E.g. {"userEnteredValue": { "stringValue": "yourText1" }}, {"userEnteredValue": { "stringValue": "yourText2" }}

Please see if there is more information on creating headers and the variable types in the speadsheet

I also want to create the speadsheet in a folder on Google Drive not the root folder.

 

[ArshilAhmad]

Pabbly

connect.pabbly.com

You can try using the 'Create a Spreadsheet' action step to create a new spreadsheet with headers in this manner.

You can then use the 'Move a File' action step to move the spreadsheet to your desired folder.