Go to cell action in Google Sheets - Use the Go to cell action in the Google Sheets package to go to the specified cell.

Automation 360

Use the Go to cell action in the Google Sheets package to go to the specified cell.

Settings

Note:

You might encounter an issue when you use this action in a loop. This issue occurs because Google Cloud enforces quotas and limits on API key calls.

To resolve this issue, increase the following quotas for your project in the Google Cloud Console:
  • Read requests per minute
  • Write requests per minute
For more information about configuring quotas, see Quotas and limits.
  • Enter the name of the session used to open the current spreadsheet with the Open spreadsheet .
  • You can navigate to different cells in a Google Sheet using the Cell Options. To activate a cell, choose one of the following Cell options:
    • To select a specific cell, click Specific cell and enter the address of the cell you want to select. For example, A2.
    • To select a cell adjacent to the active cell, choose one of the following options:
      • One cell to the left: Selects the cell to the left of the active cell. For example, if the active cell is B3, A3 is selected.
      • One cell to the right: Selects the cell to the right of the active cell. For example, if the active cell is B3, C3 is selected.
      • One cell above: Selects the cell above the active cell. For example, if the active cell is B3, B2 is selected.
      • One cell below: Selects the cell below the active cell. For example, if the active cell is B3, B4 is selected.
    • To move the cursor to the beginning or the end of the current row, choose one of the following options:
      • Beginning of the row: Selects the first cell in the current row.
      • End of the row: Selects the last cell with data in the current row.
    • To move the cursor to the beginning or the end of the current column, choose one of the following options:
      • Beginning of the column: Selects the first cell in the current column.
      • End of the column: Selects the last cell with data in the current column.