Skip to content

Create Spreadsheet Activity

The Create Spreadsheet activity creates a new Google Sheets document. It enables users to specify the title of the new spreadsheet and optionally add initial sheets to it.

Field Description Requirement
Google sheet name The reference name of the Google Sheet which has already been opened or created is chosen in the dropdown. Required
Spreadsheet name Spreadsheet name (it will be created in "My Drive") Required
Credential file Pre-authorized user credentials Required

Action Types & Examples

Output Google Sheet Reference

  • Format: Object (Google Sheet Reference)
  • Example Result: newGoogleSheet

Implementation Examples

Field Setup - Google sheet name: newGoogleSheet - Spreadsheet name: "My Project Report" - Credential file: "C:\Users\User\Documents\credentials.json"

Execution Parameters - spreadsheetTitle: "My Project Report" - credentialFilePath: "C:\Users\User\Documents\credentials.json" - outputSheetReference: newGoogleSheet

Technical Notes

Ensure the provided credential file has the necessary Google Sheets API permissions for creating and managing spreadsheets. The activity creates the spreadsheet in the "My Drive" folder of the authenticated user.