Before configuring “Google Sheets” action nodes, you will need to have at least one Google Sheets integrations connected in your company. You can refer to this Help Center article to learn more about Google Sheets integrations.
Update Google Sheet row
The “Update Google Sheet row” action node modifies an existing row in the selected Google Sheet based on specified conditions. It ensures that records remain accurate and up to date without manual edits.
To set up the node, follow these steps:
- Click on the “Search Google Sheet rows” action node to open up its form, which will appear on the right side of the screen
[image] - The node form contains the following fields for you to configure your action:
-
Select a Google account and sheet
- Google account: Choose the connected Google account. If no Google account is connected, you can refer to the Help Center article here to set up your Google Sheets integration.
- Google Sheet: Select the spreadsheet you want to search in.
- Sheet: Pick the specific tab (worksheet) inside the spreadsheet.
-
Header row: Enter the row number that contains the column headers (usually 1).
- Choose which row to update (Row)
- Pick how the row is identified:
- Static row: Manually select a specific row number (e.g., 2).
- Flow variables: Provide the row index/ID via a variable (e.g., from a prior Search Google Sheet rows step).
- Pick how the row is identified:
- Map column values
- For each field you want to change:
- Google Sheet column: Select the target column (e.g., Status, Tracking URL, Tier).
- Value: Enter a static value or insert a variable using the picker.
- Click Add to update multiple columns in the same row.
- For each field you want to change:
-
Select a Google account and sheet
💡 Tips for selecting header row for complex Google Sheets
Make sure to select the correct header row—this tells SleekFlow where to start reading your data. For simple sheets, this is usually the first row. For more complex sheets (e.g. those with titles, merged cells, or multiple sections), choose the row where your column names or property labels begin.
Any data above the selected header row will be ignored.
✅ Example 1: How a simple Google Sheet should be structured
Let’s say your Google Sheet includes instructions or grouped content before the actual data starts:
In this example:
- Rows 1 and 2 contain meta info or titles.
- Row 3 is where the actual column headers begin.
You should select row 3 as your header row when configuring the Google Sheets action node—this ensures the system correctly maps Name, Email, and Source as column names and fetches the data accordingly.
✅ Example 2: Complex eCommerce sheet with metadata and multiple side notes
In this example:
- Row 1 contains internal notes and report metadata
- Row 2 is where the actual headers begin
You should select row 2 as your header row. This allows SleekFlow to correctly read structured columns like Order ID, Email, Add-ons, and Status, while ignoring the content above.