Create workbook action in Google Sheets

Create workbook action enables you to create a new workbook in your Google Sheets.

Settings

Creates a new Google Sheets workbook.
Note: You cannot create a workbook in the Shared with me folder because Google API does not support it.
  • Enter the username you used in the Connect action.
  • Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action.
  • Enter the workbook name with one of the following file extensions: .xlsx, .xls, or .xlsm
  • Enter the file path for the new workbook or select a file variable.

Example

The following example provides information to create a file in Google Drive:
  1. Double-click or drag the Connect action. See Connect action for Google packages.
    Note: When you create bot, replace the values below with yours.
    1. In the Username field, select the Insecure string option and enter aatest@gmail.com
    2. Enter Default in the Session name field.
    3. In the Client Id field, select the Insecure string option and enter 55064436-7t68im3caev0941oqa1iae.apps.googleexample.com.
    4. In the Client Secret field, select the Insecure string option and enter b129wCSpmYcwzXg77_DOc.
    5. Specify the wait time (in minutes) in the Wait for action to complete (In minutes) field.
  2. Double-click or drag the Create workbook action.
    1. In the Username field, select the Insecure string option and enter aatest@gmail.com
    2. Enter Default in the Session name field.
    3. Enter Investment plan.xlsx in the Workbook name field.
    4. For the File path, select From my shared location option and enter My Drive/Finance 2023 in the File Name (optional) field.
  3. Double-click or drag the Disconnect action. See Disconnect action
    1. In the Username field, select the Insecure string option and enter aatest@gmail.com
    2. Enter Default in the Session name field.
  4. Click Save and then Run.