Wiresk

Wiresk

Google Sheets – Spreadsheet – Worksheet

Estimated reading time: 5 min

What will start your automation…

SHEETS Google Sheets - Spreadsheet - Worksheet

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.
Name* Create New Spreadsheet
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Folder ID*:

Select a folder in which the Spreadsheet will be created, or Map the folder ID.

Title*:

Name the new Spreadsheet.

(*) required field

Response sample 
{
  "spreadsheetId": "1t83taRBK3dmWinOJ4i-s_qSilK8kyX_5oZCDdIq9bDg",
  "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/1ttaRBK3dmgWinOJ4i-s_qSilK8kyX_5oZCDIqt9bDg/edit"
}
Expand

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.
Name* Find Spreadsheet
Connection*Select your Google connection or create one.

MATCHING CRITERIA

Drive*:

Select your Drive

Folder ID:

Optionally, select a folder, or Map the folder ID.

Title*:

Spreadsheet’s title to look for (Must be exact match).

If Not Found Consider As*:

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the workflow.

Failed – Wiresk treats this as an error or failure. The workflow stops or takes a predefined failure action.

(*) required field

Response sample 
{
  "id": "1l5rLYNWZi-B0S4PiFxEFn04KCW3fEnEAFkl9Z21Sy6g",
  "name": "Spreadsheet sample",
  "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/1l5rLYNWZi-B0S4PiFxEFw04KCW3kEnEA1kl9Z21Sy6g"
}
Expand
SHEETS Google Sheets - Spreadsheet - Worksheet

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.
Name* Copy Worksheet
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the Spreadsheet to copy the Sheet from.

or Map the ID.

Worksheet*:

Select the Sheet to copy.

or Map the ID.

Destination Spreadsheet*:

Select the the spreadsheet to copy the sheet to.

Or Map the ID.

(*) required field

Response sample 
{
  "sheetId": 1662675428,
  "title": "Copy of Sheet test",
  "index": 1,
  "sheetType": "GRID",
  "gridProperties": {
    "rowCount": 1001,
    "columnCount": 26
  }
}
Expand

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.
Name* Create Worksheet
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet where you want to create the sheet.

Or Map the ID.

Title*:

Name of the sheet.

(*) required field

Response sample 
{
  "sheetId": 847390727,
  "title": "test creation sheet",
  "index": 3,
  "sheetType": "GRID",
  "gridProperties": {
    "rowCount": 1000,
    "columnCount": 26
  }
}
Expand

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.
Name* Delete Worksheet
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet where you want to delete the sheet.

or Map the ID.

Title*:

Select the sheet to delete.

Or Map the ID.

(*) required field

Response sample 
{
  "spreadsheetId": "1l5rLYNWZi-B0S4PiFxEFn04KCW3kEnEAFkl9Z21Sy6g"
}
Expand

Configuration Table:

Input Options (Field Mapping):

  • Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
  • Default Value: Select value from a defined list or specify a fixed attribute.
  • Manual input: Set a custom value by using the Lightning Bold feature.
Name* Find Worksheet
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet where you want to find the sheet.

or Map the ID.

Title*:

Select the sheet to find.

Or Map the ID.

If Not Found Consider As*:

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the workflow.

Failed – Wiresk treats this as an error or failure. The workflow stops or takes a predefined failure action.

(*) required field

Response sample 
{
  "sheets": [
    {
      "properties": {
        "sheetId": 123456789,
        "title": "Sheet1",
        "index": 0,
        "sheetType": "GRID",
        "gridProperties": {
          "rowCount": 1000,
          "columnCount": 26
        }
      }
    },
    {
      "properties": {
        "sheetId": 987654321,
        "title": "SalesData",
        ...
      }
    }
  ]
}
Expand

Once your Flow is configured, you can test or automate it using the Run panel or by managing Triggers from the Flow Management screen.

  • Run Flow: Manually runs the Flow once using sample data. Ideal for testing logic and field mapping. See How to Run a Flow.
  • Run Scheduler: Force-runs the Trigger immediately using live input. This bypasses the recurrence rule and is useful for verifying real data mapping. Learn more in Wiresk Scheduler – The Fundamentals.

From the Trigger management panel (clock icon), you can:

  • Activate or deactivate Triggers
  • Force-run the scheduler
  • Copy Routing Keys (for HTTP Triggers)

If your Flow uses a Webhook Trigger, it runs automatically on each incoming webhook—no scheduler required. It remains active until you manually deactivate it.