Wiresk

Wiresk

Google Sheets – Search – Add/Update/Delete

Estimated reading time: 5 min

What will start your automation…

SHEETS Google Sheets - Search - Add/Update/Delete

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* Look up Multiple Rows
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet.

or Map the ID.

Worksheet*:

Select the Worksheet.

or Map the ID.

Header Row*:

If the Worksheet has a header, select it row :

  • First
  • Second Row
  • Third Row
  • Fourth Row
  • Fifth Ro

If not select No Header.

MATCHING CRITERIA

Look up Column*:

Select the column to look up.

Look up Value*:

Search value (must be exact match).

(*) required field

Response sample

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* Look up One Row
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet.

or Map the ID.

Worksheet*:

Select the Worksheet.

or Map the ID.

Header Row*:

If the Worksheet has a header, select it row :

  • First
  • Second Row
  • Third Row
  • Fourth Row
  • Fifth Ro

If not select No Header.

MATCHING CRITERIA

Look up Column*:

Select the column to look up.

Look up Value*:

Search value (must be exact match).

(*) required field

Response sample 
{
  "row": 2,
  "values": {
    "header 1": "sample1-1",
    "header 2": "sample2-1",
    "header 3": "sample3-1",
    "header 4": "sample4-1"
  }
}
Expand
SHEETS Google Sheets - Search - Add/Update/Delete

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 Spreadsheet Row
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet.

or Map the ID.

Worksheet*:

Select the Worksheet.

or Map the ID.

Row Delete From*:

The starting row to delete (1-based index like in Sheets UI).

Row Delete to:

If set, deletes a range of rows. If left blank, only one row is deleted.

(*) required field

Response sample

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* Format Spreadsheet Rows
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet.

or Map the ID.

Worksheet*:

Select the Worksheet.

or Map the ID.

Start Row Index*:

The starting row to format (1-based index like in Sheets UI).

End Row Index:

If set, format a range of rows. If left blank, only one row is formated.

Bold*:

True – False

Italic*:

True – False

StrikeThrough*:

True – False

Underline*:

True – False

Text Color*:

Select the text color.

Background Color*:

Select the background color.

(*) required field

Response sample 
{
  "columnInsertedAt": "A"
}
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* Insert New Column
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet.

or Map the ID.

Worksheet*:

Select the Worksheet.

or Map the ID.

Header Row*:

If the Worksheet has a header, select it row :

  • First
  • Second Row
  • Third Row
  • Fourth Row
  • Fifth Ro

If not select No Header.

Column Position:

Select the column index. This shifts all columns from the insert point to the right.

Name*:

Name of the new column

(*) required field

Response sample 
{
  "columnInsertedAt": "G"
}
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* Insert New Row
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet.

or Map the ID.

Worksheet*:

Select the Worksheet.

or Map the ID.

Header Row*:

If the Worksheet has a header, select it row :

  • First
  • Second Row
  • Third Row
  • Fourth Row
  • Fifth Ro

If not select No Header.

Data*:

Dynamic fields from your spreadsheet will appear here for data mapping.

For example, if your spreadsheet has headers, Wiresk will display each header as an individual mapping field for you to map values into (one per column).

(*) required field

Response sample 
{
  "spreadsheetId": "1l5rLYNWZi-B0S4PiFxEFn04KCW3kEnEAFkl9Z21Sy6g",
  "tableRange": "'Sheet1'!A1:E5",
  "updates": {
    "spreadsheetId": "1l5rLYNWZi-B0S4PiFxEFn04KCW3kEnEAFkl9Z21Sy6g",
    "updatedRange": "'Sheet1'!A6:E6",
    "updatedRows": 1,
    "updatedColumns": 5,
    "updatedCells": 5
  }
}
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* Update a Row
Connection*Select your Google connection or create one.

MAP FIELDS

Drive*:

Select your Drive

Spreadsheet*:

Select the spreadsheet.

or Map the ID.

Worksheet*:

Select the Worksheet.

or Map the ID.

Row*:

The row index that you want to update (e.g., 6).

Header Row*:

If the Worksheet has a header, select it row :

  • First
  • Second Row
  • Third Row
  • Fourth Row
  • Fifth Ro

If not select No Header.

Data*:

Dynamic fields from your spreadsheet will appear here for data mapping.

For example, if your spreadsheet has headers, Wiresk will display each header as an individual mapping field for you to map values into (one per column).

(*) required field

Response sample 
{
  "rowUpdated": 6
}
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.