Add the ‘Get Cell’ Tool step to your Tool
You can add the ‘Get Cell’ Tool step to your Tool by:- Creating a new Tool, then searching for the ‘Get Cell’ Tool step
- Click ‘Expand’ to see the full Tool step
- Using the dropdown menu:
- Select the Google account you would like to use.
- Select the Drive you would like to use (defaults to “My Drive”).
- Select the Spreadsheet you would like to fetch from.
- Select the worksheet you would like to fetch from.
- Select the Cell you would like to fetch.
- Click ‘Run step’ to test out the Tool
Parameters
The Drive you want to use. By default, the tool uses “My Drive”.
The ID of the spreadsheet you want to fetch from.
The ID of the worksheet you want to fetch from.
The coordinates of the cell you want to fetch. For example, “A1”, “B2”, etc.