sheets_create
Create a new spreadsheet (.xlsx) in a folder in Files (folder_id from list_doc_folders; not Recently emailed or Trash). sheets = [{name, rows: [[…], …]}], rows starting at A1. Values: numbers and true/false stay typed; text starting with '=' is an Excel formula (e.g. "=SUM(B2:B9)"); 'YYYY-MM-DD' / 'YYYY-MM-DDTHH:MM' become dates; start text with an apostrophe to keep it as plain text. Formulas calculate when the file is opened. Returns file_id and a link to open it in the editor.
Parameters
- folder_id (string, required)
- name (string, required)
- sheets (array)